Unhide Columns in Excel (Ctrl + Shift + 0)
Unhiding columns restores previously hidden columns to view, allowing you to work with all your data again.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| Ctrl + Shift + 0 | Cmd + Shift + 0 |
What Does This Shortcut Do?
The shortcut unhides any hidden columns in the selected range or adjacent to selected columns.
How to Unhide Columns
- Select the columns around the hidden columns
- Press Ctrl + Shift + 0 (Windows) or Cmd + Shift + 0 (Mac)
- The hidden columns will become visible again
Tips & Best Practices
- Ensure you select columns on both sides of the hidden columns for the shortcut to work
- Use unhiding after hiding columns for temporary data management
- Right-click the column header of the hidden range and choose "Unhide" as an alternative
FAQ
- Q: Can I unhide multiple hidden columns at once?
- A: Yes, select the surrounding columns and use the shortcut to unhide all hidden columns in that range.
- Q: Will unhidden columns restore formatting and formulas?
- Yes, all formatting, data, and formulas remain intact.
- Q: Is there an alternative way to unhide columns?
- Yes, right-click the column header of the hidden column range and select "Unhide".