Excel Column Hide Shortcut Key: Windows and Mac

In Excel for Microsoft 365 on Windows, select the column or columns you want to hide and press Ctrl+0 (zero). On a Mac, the equivalent is Command+0; to show hidden columns again, use Ctrl+Shift+0 on Windows or Command+Shift+0 on Mac.

The Windows shortcut and what it does

Ctrl+0 hides the selected column or columns from view. The columns are not deleted: their data, formulas, formatting, and references remain in the workbook. Excel simply makes the selected column widths zero, so the column letters skip over them. For example, if column C is hidden, the headers may appear as A, B, D, E while the values in D remain in column D.

You can press the shortcut while a cell in a column is active, or after selecting one or more whole columns. If the active cell is in column C, Ctrl+0 hides column C. If columns C through E are selected, the shortcut hides all three. The zero is the number zero, not the letter O.

This is useful when a sheet contains helper calculations, reference data, or details that are not needed in a particular view. It is a display change, not a security feature: someone with access to the workbook can unhide the columns and inspect their contents.

How to select columns before hiding them

Click a column letter at the top of the worksheet to select that entire column. Then press Ctrl+0. To select a continuous range, click its first column letter, hold Shift, and click the last one. For instance, selecting the headers D and then G with Shift selects D, E, F, and G, which the shortcut hides together.

To choose columns that are not next to each other, select one column header, then hold Ctrl while clicking each additional header on Windows. On a Mac, use Command while clicking additional column headers. Press the relevant hide shortcut after making the selection. When working with a large range, selecting column letters is often clearer than selecting cells, because it makes it obvious that the full columns—not just a few cells—are intended to be hidden.

You can also select a column from a cell without using the mouse: press Ctrl+Space on Windows to select the active cell’s column, then press Ctrl+0. On Mac, Control+Space can select the column in Excel, though macOS keyboard settings or input-source shortcuts may interfere. If a key combination does not behave as expected, select the column header directly and use the ribbon command instead.

How to unhide columns

Use Ctrl+Shift+0 on Windows to unhide selected columns, or Command+Shift+0 on Mac. The selection needs to include the hidden column or columns. If column C is hidden, for example, select the visible headers B and D and invoke the unhide shortcut. Selecting only B will not give Excel the boundary around the hidden column.

For a hidden block, select the visible column headers immediately on both sides of it. If C through E are hidden, select B and F, then use the unhide command. You can also select a wider range that includes the hidden columns. To reveal every hidden column on a worksheet, click the small triangle at the top-left corner of the grid, where the row numbers and column letters meet, to select the sheet; then choose the unhide command. Be aware that this may reveal columns you meant to keep hidden.

If the shortcut fails, the ribbon gives a dependable alternative: go to Home > Cells > Format > Hide & Unhide > Unhide Columns. For a specific hidden column, selecting the visible headers on either side first helps Excel identify the range you want to restore.

Use the ribbon or right-click menu

Shortcuts are fast, but the commands are also available in Excel’s interface. To hide columns, select their headers and choose Home > Cells > Format > Hide & Unhide > Hide Columns. This path is useful when you cannot remember the key combination, when a keyboard layout intercepts it, or when you are explaining the action to another workbook user.

Another option is to right-click a selected column header and choose Hide. To unhide, select the neighboring visible column headers, right-click, and choose Unhide. These menu options make the operation explicit and are convenient when working with a mouse. If you do not see the expected result, check that you selected column headers and not just cells within the columns.

Mac and Excel for the web differences

In Excel for Microsoft 365 on Mac, use Command+0 to hide selected columns and Command+Shift+0 to unhide them. The command key replaces Ctrl for these shortcuts. Mac keyboard settings can affect certain combinations, so the ribbon route—Home > Format > Hide & Unhide—is a practical fallback if a shortcut is captured by macOS or does not work with your keyboard setup.

Excel for the web runs inside a browser, where some key combinations may be handled by the browser or operating system. Shortcut behavior can also depend on the browser and Excel’s keyboard settings. If Ctrl+0 does not hide the selected columns in the web app, use the ribbon or right-click a selected column header and choose Hide. The desktop shortcut instructions above are for the Windows desktop version of Excel.

Common reasons the shortcut seems not to work

The wrong key was pressed: use the number zero, not O. On most keyboards, the zero in the top number row is the straightforward choice.
The selection is not what you intended: Ctrl+0 acts on the active column or selected columns. Click the column letters first to make the target clear.
You are trying to unhide without selecting the hidden boundary: include the visible columns on both sides of the hidden range, then use the unhide shortcut.
The unhide shortcut is intercepted: Ctrl+Shift+0 may conflict with Windows keyboard or input-language settings in some configurations. Use the ribbon command if changing those settings is not appropriate.
The worksheet is protected: protection settings may prevent column formatting changes. If you are authorized to edit the sheet, check Review > Unprotect Sheet or ask the workbook owner about the protection settings.
The columns are very narrow rather than hidden: a tiny width can look like a hidden column. Select the affected column range and use Home > Format > Column Width to set a visible width, or use AutoFit Column Width.

Excel may also prevent changes if the workbook or sheet is in a restricted state. If the command is unavailable, consider whether the file is read-only, the worksheet is protected, or your permissions limit editing. Do not assume that a shortcut has deleted data: hiding columns changes what is displayed, while deleting columns is a separate action with different effects on formulas and layout.

When hiding columns is useful—and when it is not

Hiding columns can simplify a report without removing source information. A worksheet used for monthly sales might keep product codes, internal notes, or intermediate calculations in columns that most viewers do not need. You can hide those columns for a cleaner presentation and unhide them later when reviewing the underlying details.

For a temporary view, hiding is convenient. For a workbook that other people will use, consider adding a note or using a clearly labeled section so they understand where supporting information went. If the goal is to stop people from seeing sensitive data, hiding alone is not enough; use appropriate file access controls and do not place confidential information in a workbook that unauthorized people can open.

There are alternatives when hiding is not the best fit. Grouping columns with Excel’s outline tools lets a reader expand or collapse a section using the outline controls. Filtering is more suitable for showing only rows that meet conditions; it does not hide columns. Changing column width can make a column narrower, but unlike hiding it, it may leave a visible sliver. Choose the method based on whether you need a clean view, an expandable section, or a data-based filter.

Frequently Asked Questions

What is the shortcut to hide a column in Excel?
In Excel for Microsoft 365 on Windows, select the column and press Ctrl+0. On Mac, press Command+0. Selecting the column letter first is the clearest way to ensure the whole column is hidden.

How do I unhide a column in Excel with the keyboard?
On Windows, select the visible columns around the hidden one and press Ctrl+Shift+0. On Mac, use Command+Shift+0. If the Windows shortcut is intercepted, use Home > Cells > Format > Hide & Unhide > Unhide Columns.

Does Ctrl+0 delete a column?
No. It hides the selected column from view but keeps its contents and position in the worksheet. To delete a column, use Excel’s delete command instead; hiding and deleting are different operations.

Why does Ctrl+Shift+0 not unhide columns?
Some Windows keyboard or input-language configurations can intercept the combination. You can unhide with the ribbon command, or adjust the relevant Windows keyboard shortcut settings if appropriate. Also make sure your selection includes the visible columns on both sides of the hidden range.

Can I hide several columns at once?
Yes. Select a continuous range by clicking its first header and Shift-clicking its last, or select nonadjacent headers using Ctrl-click on Windows or Command-click on Mac. Then press the hide shortcut for your platform.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.