I have the following problem:

I have hidden quite a lot of rows (containing formulas). Now I want to copy an entire column with Copy-paste Special so they only contain values.

This means I first have to unhide all the rows, and then hide them again. But is there a possibility to hide whatever was hidden with one easy click?



Or do you I have to write down the numbers of all the rows that were hidden in the first place, and then select them all again to hide them again?

Unhide
Select and copy data
Use the 'Undo' button to hide all that you unhid
Paste previously copied data