Unhide all columns and rows

A short macro that will unhide all columns and rows in order to make all data visible again.
Might be useful in some cases.

Sub UnhideAllColumnsRows()
' unhide all columns and rows on the current worksheet
Cells.EntireColumn.Hidden = False
Cells.EntireRow.Hidden = False
End Sub

If you want more control on which rows and/or columns to unhide, you can also use this tool from within ASAP Utilities.

Comments are closed.

Pinterest