• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 116
  • 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

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

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