Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 115
  • Last Modified:

Paste on filtered data

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.
0
sanjay-gandhi
Asked:
sanjay-gandhi
  • 3
  • 2
1 Solution
 
Haris DjulicCommented:
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
0
 
sanjay-gandhiAuthor Commented:
Thanks,

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

San.
0
 
Haris DjulicCommented:
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.
0
 
sanjay-gandhiAuthor Commented:
Thanks Haris.
0
 
Haris DjulicCommented:
Sure, anytime..
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now