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?