How To Hide Columns In Excel
A practical step-by-step guide to how to hide columns in excel, including preparation, instructions, common issues, tips, and next steps.
How To Hide Columns In Excel
Hiding columns in Excel lets you tidy up your spreadsheet without deleting any data. You can temporarily remove columns from view for cleaner printing, simpler presentations, or focused data entry, and unhide them again whenever you need them. This guide walks you through every method, including keyboard shortcuts, right-click options, and the Ribbon menu.
Fast Answer
- Quickest method: Right-click the column letter and choose Hide.
- Best shortcut: Select columns, then press Ctrl + 0.
Before You Start
- Microsoft Excel installed on a Windows PC or Mac (Excel 2010 through Microsoft 365 all work the same way).
- A spreadsheet file open with the data you want to work with.
- Your data already saved somewhere safe, just in case you accidentally hide the wrong columns.
Step-by-Step Instructions
Select the Columns You Want to Hide
Click the letter at the top of the column you want to hide. For example, click the letter B to highlight the entire column B. The whole column should turn blue or grey, depending on your Excel theme.
To hide multiple columns that sit next to each other, click the first column letter, hold down your mouse button, and drag across the other letters. To hide columns that are not next to each other, hold down the Ctrl key on Windows (or the Command key on Mac) and click each column letter you want to hide.
Use the Right-Click Menu to Hide Columns
Once your columns are selected, right-click anywhere on the highlighted area. A small menu will pop up. Look for the word Hide — it usually sits about halfway down the menu, right below the Hide Rows option. Click it, and your selected columns will disappear from view.
This is the most reliable method because it works in every version of Excel, and it is hard to miss the option when you right-click directly on the column letters.
Use the Ribbon Menu to Hide Columns
Select the columns you want to hide. Then click the Home tab at the top of the Excel window. Look for the Format button in the Cells group — it is usually near the top-right of the ribbon. Click it, then choose Hide & Unhide from the dropdown menu, and finally click Hide Columns.
This method is a bit slower than right-clicking, but it is useful if you are already working in the ribbon or if you find the right-click menu too cluttered.
Use the Keyboard Shortcut for Hiding Columns
Select the column or columns you want to hide, then press Ctrl + 0 on Windows. On a Mac, press Command + 0. That is the number zero, not the letter O.
This is the fastest method once you memorise it. It takes less than a second and keeps both hands on the keyboard. The shortcut works in all modern versions of Excel, including Excel Online in your web browser.
Unhide a Single Column
To bring a single hidden column back, find the gap in the column letters. For example, if column B is hidden, the letters will read A, C, D. Click and drag across both letters that surround the gap — in this case, select columns A and C by clicking letter A, holding the mouse button, and dragging to letter C.
Right-click on the selected area and choose Unhide from the menu. Column B will reappear exactly where it was before.
Unhide Multiple Columns at Once
If you have hidden several columns that sit together, highlight the columns on both sides of the entire hidden block. For instance, if columns B, C, and D are hidden, select columns A through E. Right-click and choose Unhide. All three hidden columns will reappear at the same time.
For columns that are not next to each other, you have to unhide them one group at a time. Select the surrounding columns for the first hidden block, unhide it, then move on to the next block.
Unhide All Columns in the Entire Worksheet
Click the small square in the top-left corner of the spreadsheet, where the row numbers and column letters meet. This selects the entire worksheet. Then right-click anywhere on the selected area and choose Unhide.
Every hidden column in the entire worksheet will reappear at once. This is the fastest way to show all hidden columns if you are not sure which ones are hidden or how many there are.
Hide Columns for Printing Only
Sometimes you want to hide columns just for a printed page, but still see them on screen. Select the columns you want to keep out of your printout, right-click, and choose Hide. Then print your document as normal.
After printing, unhide the columns using the same unhide method described above. This keeps your on-screen view exactly how you left it, while your printout looks clean and focused.
Group Columns Instead of Hiding Them
If you hide columns often, you can use Excel's grouping feature to make the process faster. Select the columns you want to hide, press Shift + Alt + Right Arrow on Windows (or Command + Shift + K on Mac), and choose Group. A grey bracket will appear above the columns with a minus sign.
Click the minus sign to collapse the group and hide the columns. Click the plus sign to expand and show them again. This is much faster than right-clicking and unhiding every time, especially for monthly dashboards or project tracking sheets.
Quick Reference
| Situation | Use this | Why |
|---|---|---|
| Hide one or more columns fast | Select columns, press Ctrl + 0 | Fastest method once memorised |
| Hide columns without shortcuts | Right-click selected columns, choose Hide | Visible and works in all Excel versions |
| Unhide everything at once | Select whole sheet, right-click, choose Unhide | Reveals all hidden columns in one step |
| Toggle columns regularly | Group columns with Shift + Alt + Right Arrow | One click to hide or show the group |
| Accidentally hid the wrong column | Press Ctrl + Z immediately | Undo reverses the hide action instantly |
Common Problems When You Hide Columns in Excel
Column Will Not Hide
If you select a column and press Ctrl + 0 but nothing happens, check whether your worksheet is protected. When a worksheet is protected, Excel blocks many actions, including hiding columns. Go to the Review tab and click Unprotect Sheet if you know the password, or ask the person who set up the file.
Another reason could be that the column is part of a table. Excel tables do not always allow hiding columns via the shortcut. Try right-clicking instead, or convert the table back to a normal range by right-clicking and choosing Table, then Convert to Range.
Hidden Columns Still Show in a Chart or Formula
Hidden columns do not disappear from formulas. If your spreadsheet calculates totals or averages, hidden columns still contribute to those numbers. This surprises many people, especially when they hide a column to remove it from a report. The data is still being used behind the scenes.
If you want the data to be completely ignored, you must either delete it or use a filter instead. Filters exclude data from calculations, while hiding columns simply hides the view.
Cannot Find the Unhide Option
Sometimes you right-click and the Unhide option is greyed out. This usually means you did not select a range that surrounds the hidden columns. You must highlight columns on both sides of the hidden gap before the Unhide option becomes clickable.
If you only selected one column, or if you selected columns all on one side of the gap, the option stays greyed out. Select the full range that includes both neighbouring columns, then right-click again.
Hidden Columns Reappear When You Save and Reopen
Excel normally remembers your hidden columns when you save the file. If they reappear, check whether someone else has edited the file in the meantime, or whether the file is stored in a shared location where another person unhid them.
If you are using Excel Online in a browser, hidden columns sometimes reset after a refresh. Save a local copy on your computer if you need the hidden columns to stay hidden reliably.
Advanced Tips for Hiding Columns in Excel
Use Filters Instead of Hiding Columns
If you want to temporarily focus on a few columns without hiding the others, Excel's filter feature is a better choice. Select your data, go to the Data tab, and click Filter. Small dropdown arrows appear in each column header. Click one and untick the columns you want to hide from view.
Filters hide entire rows of data based on your chosen criteria, but they also allow you to sort and reorder. This is more powerful than hiding columns, but it works differently — filters remove rows, while hiding columns removes columns.
Lock Hidden Columns to Keep Them Secret
Hiding columns is not a security feature. Anyone who knows the unhide shortcut can bring them back. If you need to keep certain data private, you must protect the worksheet. Go to the Review tab and click Protect Sheet. Tick the option that says Format Columns and unselect it, so people cannot unhide columns.
This does not encrypt your data. A knowledgeable person can still copy the file and remove protection. But it prevents accidental changes and stops casual viewers from seeing hidden columns.
Use a Macro to Hide Multiple Columns Quickly
If you regularly hide the same set of columns in different files, you can record a macro. Click View, then Macros, and choose Record Macro. Perform your usual hide actions, then stop recording. Assign the macro to a button or keyboard shortcut for one-click hiding in the future.
Macros are powerful but require a saved file format that supports them, such as .xlsm. Save your file accordingly if you plan to use macros regularly.
Hide Columns in a Pivot Table
Pivot tables have their own hide features. Right-click on a field inside the pivot table and choose Collapse to hide subcategories, or use the field list to uncheck items you do not want displayed. This hides data within the pivot table without affecting the source spreadsheet.
This is useful for dashboards where you want to show only the top categories while keeping the full data available for future analysis.
How To Hide Columns In Excel FAQ
Common Issues
If the result is not working as expected, return to the previous step, check the material or setting involved, and make one adjustment at a time for how to hide columns in excel.
Does hiding columns delete the data?
No. Hidden columns are simply removed from view. The data stays in the spreadsheet, and any formulas that reference those cells continue to work normally.
Can I hide columns without selecting them first?
No, you must always select the columns before hiding them. The selection tells Excel which columns to hide. You can select as few as one column or as many as the entire spreadsheet.
Why is my Unhide option greyed out?
The Unhide option only becomes active when your selection spans both sides of the hidden column gap. Highlight columns on both sides of the hidden columns, then try again.
Do hidden columns print?
No. Anything that is hidden does not appear in your printed output. If you need to print hidden columns, unhide them first, print, then hide them again.
How do I hide columns in Excel on a Mac?
The process is identical to Windows, except the keyboard shortcuts use the Command key instead of Ctrl. Right-clicking still works exactly the same way.
Can I hide columns in Excel Online?
Yes. Excel Online in your web browser supports hiding columns using the right-click menu and the ribbon. Keyboard shortcuts also work in most browsers, though some may conflict with browser shortcuts.
Final Checklist for Hiding Columns in Excel
- Selected the correct columns before hiding — check the letter labels.
- Used Ctrl + 0 for a fast hide, or right-click for a visible option.
- Remembered that hidden columns still affect formulas and charts.
- Unhidden columns correctly by selecting both surrounding columns.
- Saved your file to keep the hidden columns in place.
- Protected the worksheet if you need to prevent others from unhiding columns.
- Considered grouping or filters if you hide the same columns regularly.
