Forum Discussion
Solved
Select all data in filtered area (visible and non visible)
Hello
After application of a filter, I want to select all the data in the work sheet to apply some formatting without removing the filter. I could not. I can only select the visible cells.
Anny suggestions?
Thanks in advance
I'm not sure if it's easier way, possible workaround
- select the cell with proper format, doesn't matter in already formatted filtered range/table or outside, copy it (Ctrl+C or Ctrl+Ins)
- select entire filtered range/table
- Paste->Paste Special->Formats (or Alt+H+V+T)
After application of a filter, I want to select all the data in the work sheet to apply some formatting without removing the filter. I could not. I can only select the visible cells.
Anny suggestions?
Without knowing the bigger picture here, the only suggestion I could come up with--based just on what you've written--is that you try changing the sequence of the operations.
Since you want "to select all the data in the work sheet to apply some formatting" why not do that before you apply the filter?
Dear mathetes
Thanks a lot for your kind reply.
I have a big range of variables that I applied the filter to.
Removing the filter, applying the format and then picking out these variables again is a lot of work.
Anyway, this is what I did because I couldn't wait until I get the solution.
However, it is good to know if there is anyway to deal with this issue, so that we learn something new.
Best regards
Basem
I'm not sure if it's easier way, possible workaround
- select the cell with proper format, doesn't matter in already formatted filtered range/table or outside, copy it (Ctrl+C or Ctrl+Ins)
- select entire filtered range/table
- Paste->Paste Special->Formats (or Alt+H+V+T)
