Hide and Unhide Columns in Excel: Shortcuts

How-to basics · Updated November 3, 2026

In Excel for Microsoft 365 on Windows, select a column or any cell in it and press Ctrl+0 to hide the column; select the columns around a hidden one and press Ctrl+Shift+0 to unhide it. If the unhide shortcut does nothing, use Home > Format > Hide & Unhide > Unhide Columns, or the selection methods below.

The Excel column shortcuts at a glance

The quickest way to hide a column is to select it and press Ctrl+0 (zero, not the letter O). To select a whole column, click its letter at the top of the worksheet. You can also select several neighboring column headers by dragging across them, or select a range of column letters with Shift-click.

  • Hide selected column or columns: Ctrl+0
  • Unhide selected hidden column or columns: Ctrl+Shift+0

These shortcuts change whether the columns are displayed; they do not remove the data. Hiding is useful when a sheet has supporting calculations or secondary fields that readers do not need to see all the time. The cells remain part of the worksheet, and formulas can continue to refer to them.

For example, if a report shows columns A through H and column D contains an internal note, select the D column header and press Ctrl+0. To bring it back, select columns C and E together, then press Ctrl+Shift+0. Because D is between the selected columns, Excel can identify and reveal it.

How to hide one or several columns

You do not have to select an entire column before hiding it. Selecting a cell in the column and using Ctrl+0 hides that cell’s whole column. Selecting a range that spans multiple columns hides every column in that range. This is convenient when the data is already selected, but selecting the column headers first makes it easier to see exactly what will disappear.

  1. Click a column letter, such as D, to select the whole column. For multiple adjacent columns, drag across the letters or click the first letter and Shift-click the last.
  2. Press Ctrl+0.
  3. Check the column headings: a small gap or altered boundary between letters indicates that one or more columns are hidden.

To hide nonadjacent columns, select the first column, then hold Ctrl while selecting the other column headers. Press Ctrl+0 after the selections are made. If selecting nonadjacent areas is awkward, hide each column separately; the result is the same. On a worksheet with frozen panes or a very wide layout, scroll to each column as needed before selecting it.

How to unhide columns correctly

The unhide shortcut works when your selection includes the hidden column. For a hidden column between two visible ones, select the visible column on each side. For example, if F is hidden, select E and G together, then press Ctrl+Shift+0. You can select the boundary columns by dragging across their headings or by clicking one and Shift-clicking the other.

To reveal a group of hidden columns, select visible columns on both outer sides of that group. If D, E, and F are hidden, select C and G, then use the shortcut. You can also select a wider range of column headings that spans the hidden area. Excel will unhide the hidden columns within the selection.

A hidden column at the edge of the sheet needs a different selection because there is no visible column on one side. If column A is hidden, select column B and use the ribbon command, or use the Name Box to select A:A and then choose Unhide Columns. The Name Box is the small field to the left of the formula bar; enter the column reference and press Enter. The same idea applies to the final column, XFD: use the Name Box to select it if you need to reveal it.

To unhide all columns at once, select the whole worksheet by clicking the small triangle at the top-left corner where the row numbers and column letters meet. Then choose Home > Format > Hide & Unhide > Unhide Columns. This is a useful reset when you do not know which columns are hidden. It does not change column widths or reveal rows that are hidden.

Ribbon alternatives when a shortcut fails

In Excel for Microsoft 365 on Windows, the ribbon provides commands that do not depend on the Ctrl+Shift+0 shortcut being available:

  • Hide: select the column or columns, then choose Home > Format > Hide & Unhide > Hide Columns.
  • Unhide: select the columns around the hidden area, then choose Home > Format > Hide & Unhide > Unhide Columns.

You can also use Excel’s ribbon Key Tips: press Alt, then press H, O, and C in sequence to hide columns, or Alt, H, O, and L to unhide columns. These are sequential presses, not a combination held down together. Key Tips depend on the ribbon interface and may differ in other Excel versions or configurations, so the visible Format menu is the dependable alternative if a sequence does not match your screen.

Why Ctrl+Shift+0 may not work

A frequent point of confusion is that Ctrl+0 hides a column, while the unhide command adds Shift. On some Windows installations, Ctrl+Shift+0 may be intercepted by Windows or by keyboard-language and input settings rather than reaching Excel. The shortcut can therefore appear unreliable even when the workbook and selection are fine.

Try these checks before troubleshooting the worksheet itself:

  • Confirm you are pressing the number-row zero key, not the letter O.
  • Select the hidden column’s neighboring visible headers; selecting an unrelated cell may not include the column to reveal.
  • Use Home > Format > Hide & Unhide > Unhide Columns to bypass the keyboard shortcut.
  • If you use a different keyboard layout or custom shortcuts, check whether another system-level command is taking precedence.

If the ribbon command is unavailable or seems to have no effect, check whether the worksheet is protected. Sheet protection can restrict formatting actions, including changing column visibility, depending on the protection settings. If you have permission to do so, review the options under Review > Unprotect Sheet. Do not remove protection unless you are authorized and know the password or workbook policy allows it.

Excel for Mac and Excel for the web

On Excel for Mac, the usual column shortcuts are Command+0 to hide and Command+Shift+0 to unhide. As on Windows, the unhide action requires the hidden column to be included in the selection, and keyboard settings can affect whether a shortcut is available. The ribbon or context-menu commands are alternatives if a key combination does not work on a particular Mac setup.

Excel for the web runs in a browser, where keyboard shortcuts can vary with the browser and operating system and may be intercepted before Excel receives them. If a shortcut conflicts or is unsupported, select the column headings and use the Home tab’s Format options to hide or unhide columns. The exact controls can vary as Microsoft updates the web interface, but the underlying action remains selecting the target columns and choosing the corresponding visibility command.

Hidden columns, formulas, and workbook safety

Hiding a column is a display choice, not a way to erase or secure its contents. A formula such as a total can still include values from hidden columns, and unhiding the columns makes their contents visible again. For example, hiding a cost column does not remove those costs from a total formula that refers to the column.

That distinction matters when sharing a workbook. A recipient may be able to unhide columns, inspect formulas, or find the underlying data in other ways. If information must not be shared, remove it from the shared copy or use an appropriate access-control approach rather than relying on hidden columns. Consider making a separate presentation copy if the original workbook contains confidential or internal-only data.

Hide columns or use grouping?

Hide and unhide shortcuts are best for a quick, straightforward change to the worksheet view. If readers will repeatedly switch between detailed and summary views, Excel’s grouping feature may be more convenient. Select the columns to group and choose Data > Group; Excel adds an outline control that can collapse or expand the group. Grouping is not the same as hiding: it provides a visible control for managing detail and is useful in structured reports.

For a one-time cleanup, use Ctrl+0 and the unhide command. For a worksheet that users regularly navigate at different levels of detail, grouping can make the choice more discoverable. Neither method deletes data or provides confidentiality, so choose based on how people need to work with the sheet rather than on security expectations.

Frequently Asked Questions

What is the shortcut to hide a column in Excel?
On Windows, select a cell or column and press Ctrl+0. On Mac, the usual shortcut is Command+0.

What is the shortcut to unhide a column in Excel?
On Windows, select the columns around the hidden column and press Ctrl+Shift+0. If it does not work, use Home > Format > Hide & Unhide > Unhide Columns.

How do I unhide column A?
Select column B, then use the Unhide Columns ribbon command. Alternatively, enter A:A in the Name Box and choose Home > Format > Hide & Unhide > Unhide Columns.

Does hiding a column remove its data from formulas?
No. The cells remain in the worksheet, and formulas that refer to them generally continue to calculate. Hiding changes what is displayed, not the underlying values.

Can I unhide every column in a worksheet at once?
Yes. Select the entire worksheet using the top-left corner triangle, then choose Home > Format > Hide & Unhide > Unhide Columns.

Related

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.