How to not copy hidden rows from Filtered Data 1

Often the hidden rows also get copied when you copy the filtered data and paste it to the desired location. To fix this problem all it takes is one additional step and 5 sorry 2 seconds extra than the normal copy paste of the filtered data. Let’s get this real quick!

 

Step 1) Let’s apply filter on this Data

How to not copy hidden rows from Filtered Data 2

We have here around 600+ row items

  1. Apply Filter --> Use the shortcut Ctrl + Shift + L
  2. Filter Swati’s records and you’ll find the row numbers will turn blue (i.e. the rows are hidden)

 

Step 2) Select the only the visible rows

How to not copy hidden rows from Filtered Data 3

This is where the game changes

  1. Select the filtered data set --> Shortcut Ctrl + a
  2. Select the visible rows only --> Shortcut Alt + ; (semicolon)
  3. Now copy and paste

 

More tricks on Filter

  1. Learn to use Advanced Filter
  2. Automate the Advanced Filter
  3. A typical problem with Filter

 



Topics that I write about...






Download Smart Ebooks on
Excel and Power BI