Unhide hidden columns in selection
Master this Excel shortcut with our comprehensive guide
Hide/Unhide (Rows, Columns, Objects) Shortcuts
Ctrl + Shift + 0
⌘ + Option + Shift + 0
How to Use This Shortcut
Keyboard Shortcut
Ctrl + Shift + 0
Instructions
1. Select columns around hidden columns
2. Press Ctrl + Shift + 0
3. Hidden columns appear again
2. Press Ctrl + Shift + 0
3. Hidden columns appear again
Keyboard Shortcut
⌘ + Option + Shift + 0
Instructions
1. Highlight surrounding columns
2. Press Command + Option + Shift + 0
3. Columns are unhidden
2. Press Command + Option + Shift + 0
3. Columns are unhidden
💡 Pro Tip: Efficient for quickly reviewing hidden data in wide spreadsheets.
More Hide/Unhide (Rows, Columns, Objects) Shortcuts
Ctrl + 9
Ctrl + 0
Ctrl + Shift + 9