Forum Discussion
Select all data in filtered area (visible and non visible)
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)
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)
- Good morning
A lot of thanks to you "Sergei Baklan".
I don't know the background of this (Paste format) and why it is not the same of just (Normal format), but it works.
Regards:herb:Basem_Balkees , you are welcome