Excel’s hide feature is essential for visualizing the data you need after analyzing your data. Let’s look at the shortcuts for hiding and unhiding.
Excel Hide Shortcuts
Let’s look at shortcuts for both Windows and Mac.
Windows Shortcuts
- Hide columns: Ctrl + 0
- Unhide columns: Ctrl + Shift + 0
- Hide rows: Ctrl + 9
- Unhide rows: Ctrl + Shift + 9
Mac Shortcuts
- Hide columns: Command(⌘) + 0
- Unhide columns: Command(⌘) + Shift(⇧) + 0
- Hide rows: Command(⌘) + 9
- Unhide rows: Command(⌘) + Shift(⇧) + 9