How to hide columns in Excel: Select the columns you want to conceal, right-click them, and choose Hide—or use keyboard shortcuts like Ctrl + 0 on Windows. 📉 This feature is essential for cleaning up your workspace, hiding sensitive data, or preparing reports without deleting anything. Whether you’re organizing massive spreadsheets or creating client-facing dashboards, hiding columns is a pro move you need in your Excel toolkit. ✅
💡 Why Hide Columns in Excel?
There are many reasons to hide columns, such as:
- Hiding sensitive data (e.g., internal notes, pricing) 🔒
- Focusing on key metrics while presenting 📊
- Making spreadsheets easier to read
- Temporarily removing unused data
- Simplifying complex reports or dashboards
And the best part? You can always unhide them later without losing any data!
🧭 How to Hide Columns in Excel (Mouse Method)
Step-by-Step:
- Select the column(s) you want to hide (e.g., click the letter header “C”)
- Right-click the selection
- Click Hide
The column disappears, but it’s still there—just hidden! 🙈
⌨️ Keyboard Shortcuts to Hide Columns
| Action | Windows | macOS | Ubuntu (LibreOffice Calc) |
|---|---|---|---|
| Hide Column | Ctrl + 0 | Cmd + 0 | Ctrl + Shift + 0 (or right-click > Hide) |
| Unhide Column | Ctrl + Shift + 0* | Cmd + Shift + 0 | Ctrl + Shift + 0 |
| Alternate Unhide (Mac) | Cmd + Option + 0 | Use Menu if shortcut blocked | Menu: Format > Column > Show |
⚠️ Mac users: Due to macOS default shortcut conflicts,
Cmd + 0may need to be enabled via System Preferences or used manually.
🧹 How to Unhide Columns in Excel
- Select the columns around the hidden one (e.g., B and D)
- Right-click the header
- Click Unhide
🎉 Your column reappears—no data lost!
Shortcut (Windows):
- Select area →
Ctrl + Shift + 0
🔀 Hide Multiple Columns at Once
To hide non-adjacent columns:
- Hold
Ctrl(orCmdon Mac) - Click each column header you want to hide
- Right-click → Hide
To hide adjacent columns:
- Click and drag across the headers
- Right-click → Hide
🎨 Use Case Examples
| Scenario | Should You Hide Columns? |
|---|---|
| Internal notes in financial sheet | ✅ Yes |
| Formulas you don’t want seen | ✅ Perfect use |
| Extra fields in a shared report | ✅ Recommended |
| Irrelevant columns during presentation | ✅ Cleaner view |
| Permanently deleting content | ❌ Use Delete instead |
🧠 Pro Tips for Hiding Columns in Excel
- Use hidden columns to store backup formulas or calculations
- Combine with protected sheets to hide sensitive formulas
- Use Group feature (
Alt + Shift + →) to create collapsible columns - Hide columns before printing for a cleaner report layout
🐧 How to Hide Columns in Ubuntu (LibreOffice Calc)
LibreOffice Calc offers similar functionality:
- To hide: Right-click column → Hide Column
- To unhide: Select columns around it → Right-click → Show Column
- Shortcut:
Ctrl + Shift + 0
Also available under:Format > Column > Hide
🔍 FAQs
Can I hide multiple columns at once?
Yes! Just select them together (adjacent or not), then hide.
What happens to formulas referencing hidden columns?
They still work! Excel reads the data even if it’s hidden.
Can I password protect hidden columns?
Yes. Combine hidden columns with sheet protection for better security.
Why doesn’t Ctrl + 0 work on Mac?
macOS often blocks it due to system shortcut conflicts. Use Cmd + Option + 0 or adjust system settings.
Is hiding columns the same as deleting?
No. Hidden columns are still there—you can unhide them anytime.
Can hidden columns affect sorting or filtering?
They don’t appear in the filter, but their values are still included in formula-based sorting logic.
✅ Final Thoughts on How to Hide Columns in Excel
Hiding columns in Excel is one of those small tricks with huge impact. Whether you’re tidying up data, preparing reports, or just organizing your workflow, this feature keeps things clean and professional. 🧼
Remember your keyboard shortcuts (Ctrl + 0, Cmd + 0, or Ctrl + Shift + 0) and you’re ready to work smarter—not harder—in any spreadsheet. 💼📉
Complete List of Windows Keyboard Shortcuts
If you need help for Windows, you can find a whole list of all keyboard shortcuts here.
https://keyboard-shortcuts.org/
Advertisment