Paste on filtered data

Sanjay Gandhi
Sanjay Gandhi used Ask the Experts™
on
Hi,

Once I filter a list, for example, in Region column I filter a list for North entries only (there are South, East, and West also). Then after the filtered list is obtained, I want to be able to paste some values in a column only against North (at present North is filtered). How can I achieve this?

Thanks,

San.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
IT Architect
Commented:
Hello,

you just select the cells in column next to Region column and paste the values to selected cells.

Here you can see it  step-by-step video
Sanjay GandhiFounder, Kenhal

Author

Commented:
Thanks,

But some time back, I saw it copied on hidden rows also. Why would that happen?

San.
Haris DulicIT Architect

Commented:
If you select more cells and just paste in without selecting destination it will paste it starting from the selected cell and in that case if there are some hidden rows it will paste to those rows as well.
Sanjay GandhiFounder, Kenhal

Author

Commented:
Thanks Haris.
Haris DulicIT Architect

Commented:
Sure, anytime..

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial