A short macro that will unhide all columns and rows in order to make all data visible again.
Might be useful in some cases.
' unhide all columns and rows on the current worksheet
Cells.EntireColumn.Hidden = False
Cells.EntireRow.Hidden = False
If you want more control on which rows and/or columns to unhide, you can also use this tool from within ASAP Utilities.