Unhide and Re-hide in Excel 2003

[thorgal67]

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?

[Bird_FAT]

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