Hide Columns in Excel (Ctrl + 0)
Hiding columns allows you to temporarily remove them from view without deleting data, useful for reports and presentations.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| Ctrl + 0 | Cmd + 0 |
What Does This Shortcut Do?
The shortcut hides the selected columns. Hidden columns can be unhidden later using the appropriate shortcut or context menu.
How to Hide Columns
- Select the column(s) you want to hide
- Press Ctrl + 0 (Windows) or Cmd + 0 (Mac)
- The selected column(s) will be hidden immediately
Tips & Best Practices
- Hidden columns still contain data and formulas, so calculations are unaffected
- Use for temporary hiding of sensitive or irrelevant data
- Combine with grouping for organized worksheets
FAQ
- Q: Can I hide multiple columns at once?
- A: Yes, select multiple columns before using the shortcut.
- Q: Will hiding columns affect formulas?
- No, formulas referencing hidden columns will still work normally.
- Q: How do I unhide columns?
- Use Ctrl + Shift + 0 (Windows) or Cmd + Shift + 0 (Mac) to unhide, or right-click the column header and select "Unhide".