This simple macro automatically unhides all rows and columns for you.
Sub UnhideAll() Columns.EntireColumn.Hidden = False Rows.EntireRow.Hidden = False End Sub
How This Macro Works
In this macro, we call on the Columns collection and the Rows collection of the worksheet. Each collection has properties that dictate where their objects are hidden or visible. Running this macro unhides every column in the Columns collection and every row in the Rows collection.
How to Use This Macro
To use this macro, you can copy and paste it into a standard module:
- Activate the Visual Basic Editor by pressing ALT F11.
- Right-click the project/workbook name in the Project window.
- Choose Insert -> Module.
- Type or paste the code in the newly created module.