How to Unhide Columns in Excel: Shortcut Key Guide

How-to basics · Updated November 20, 2026

To unhide columns in Excel for Microsoft 365 on Windows, select the column headers on both sides of the hidden column, then press Ctrl+Shift+0. If that shortcut is blocked on your computer, use the ribbon sequence Alt, H, O, U, L (press the keys one after another). Both methods reveal the selected hidden columns; you do not need to change the data in them.

What You’ll Need

  • An Excel workbook with hidden columns, open in the desktop version of Excel for Microsoft 365 on Windows.
  • Permission to edit the worksheet. A protected sheet may prevent you from changing column visibility.
  • To use the direct shortcut, a keyboard that sends Ctrl+Shift+0 to Excel. Some Windows configurations intercept this combination, so the ribbon sequence is a useful alternative.

You do not need to install an add-in or know the hidden column’s contents. If you only know where the column is, identifying the letters immediately before and after it is enough. For example, a hidden column C sits between visible columns B and D.

Step-by-Step

  1. Open the worksheet and check the column letters. Look across the headers at the top of the sheet. A missing letter, such as B followed directly by D, usually indicates that C is hidden. The boundary between the visible headers may also appear as a thicker line or a pair of close vertical marks. Make sure you are looking at column headers, not row numbers.
  2. Select the columns around the hidden one. Click the header for the column immediately before the hidden column, then drag across the header for the column immediately after it. For hidden C, select B through D. The selection includes the hidden column even though its header is not visible. You can also click the Name Box, which is to the left of the formula bar, type B:D, and press Enter to select those whole columns. For several hidden columns together, select the visible headers on either side of the entire hidden block.
  3. Try the direct Windows shortcut. With the relevant column headers selected, hold Ctrl and Shift, press 0 (zero), and release the keys. Do not use the letter O. If the shortcut is available, the hidden columns should appear immediately. Check the column letters to confirm that the gap is gone.
  4. Use the ribbon shortcut if the direct combination does nothing. Press and release Alt, then press H, O, U, and L in sequence. This opens the Home tab’s Format menu and chooses Hide & Unhide, then Unhide Columns. Keep the selected columns active while using the sequence. Ribbon Key Tips can vary slightly by Excel build or language; if the letters shown on screen differ, follow the displayed Key Tips instead.
  5. Or use the ribbon with the mouse. Select the columns around the hidden one, then choose Home > Format > Hide & Unhide > Unhide Columns. This is the same command as the keyboard sequence and is often easiest if you are unfamiliar with Key Tips. The menu is on the Home tab, in the Cells group.
  6. Reveal every hidden column when you do not know where they are. Click the Select All button at the top-left corner of the worksheet, where the row and column headers meet. Then press Ctrl+Shift+0, or choose Home > Format > Hide & Unhide > Unhide Columns. This applies the command across the whole sheet, including a hidden first column. If the Select All button is hard to spot, press Ctrl+A; when Excel first selects only a data region, press it again to select the entire worksheet.
  7. Check the result and save if appropriate. Confirm that the missing column letters are visible and that the newly revealed column has a usable width. Unhiding does not alter cell contents or formulas, but it can expose information that was intentionally kept out of view. Save the workbook only if you want to keep the visibility change.

On Mac: Excel for Mac may support Command+Shift+0 for unhiding columns, but the shortcut can be affected by macOS settings and keyboard layout. Select the surrounding column headers first. If the shortcut is unavailable, use Home > Format > Hide & Unhide > Unhide Columns where that command is shown, or use the Format menu options for columns. Excel for the web also supports the ribbon command; browser shortcuts and keyboard layouts can interfere with key combinations, so use the menu if the shortcut is intercepted.

Common Mistakes

  • Selecting just one neighboring column. If C is hidden and you select only B, Excel may not know which hidden column you mean. Select both B and D, or select the full range B:D. Selecting the whole sheet is a dependable choice when you want to reveal all columns.
  • Pressing the letter O instead of zero. The Windows combination ends in the number zero: Ctrl+Shift+0. It is easy to mistake it for an O, particularly on a compact keyboard.
  • Assuming the shortcut is broken after no visible change. Windows regional settings or keyboard configuration can reserve or disable Ctrl+Shift+0. Try the ribbon sequence or click the Unhide Columns command instead of repeatedly pressing the same shortcut.
  • Looking for the column without checking the letters. A very narrow column can look hidden, while a filtered table hides rows rather than columns. Compare the column letters and boundaries before deciding which issue you have.
  • Expecting unhide to undo grouping or protection. A collapsed outline is expanded with its outline controls, and a protected worksheet may block changes. The Unhide Columns command does not remove protection or expand a collapsed group.

Tips

  • Use the Name Box for exact selection. Click the box to the left of the formula bar, enter a column range such as B:D, and press Enter. You can select a specific column such as A:A this way, even if it is hidden, then use the ribbon’s Unhide Columns command. This is especially helpful when the first column is missing and there is no visible header to drag from.
  • Choose the right scope. Select adjacent headers to unhide only a particular section and avoid changing the rest of the sheet. Use Select All only when you want every hidden column on that worksheet revealed. The command applies to the active worksheet, not automatically to every sheet in the workbook.
  • Remember that hiding is not deleting. Formulas, values, and formatting remain in a hidden column. Unhiding makes the existing material visible again; it does not restore deleted data or change calculations.
  • Check for a zero-width or tiny-width column. If the column letter exists but the column is difficult to see, select it through the Name Box or surrounding headers and choose Home > Format > Column Width. Enter a sensible width, such as 10 or 12, rather than relying on Unhide if the column is merely too narrow.
  • Use the mouse path as a reliable fallback. Ribbon commands are often more predictable than keyboard shortcuts when you switch between Windows, Mac, remote desktops, or different keyboard layouts. Once you know the menu path, you can still use Key Tips on Windows to perform it without a mouse.
  • Be mindful of sensitive information. Hiding a column is only a display choice; it does not secure or encrypt its contents. Anyone with access to the workbook may be able to unhide it. If a column should not be shared, remove the information or use an appropriate access-control method before distributing the file.

Troubleshooting

The shortcut does nothing. First confirm that you selected column headers, not cells in the worksheet body. Then try Alt, H, O, U, L on Windows, or use Home > Format > Hide & Unhide > Unhide Columns. If the direct shortcut fails but the menu works, your Windows settings, keyboard layout, or another application may be intercepting the key combination. You can keep using the menu; you do not have to change system settings to unhide the columns.

Unhide Columns is unavailable or has no effect. Check whether the worksheet is protected. On the Review tab, look for Unprotect Sheet; if protection is on, you may need the password or permission from the workbook owner. Also make sure you are on the intended worksheet. If columns are hidden on several sheets, repeat the command on each sheet rather than assuming it changes the whole workbook.

The first column is hidden. You cannot select column A by clicking its header if it is not visible. Click the Name Box, enter A:A, and press Enter, then use the ribbon’s Unhide Columns command. Alternatively, click Select All at the top-left corner of the grid and unhide columns across the sheet. Selecting all is also useful if more than one hidden area is hard to locate.

The letters still appear to skip a column. Verify that the column is actually hidden and that you are reading the correct header row. If the column is present but compressed, select it and set a width using Home > Format > Column Width. If the worksheet has an outline, look for a plus sign above the columns and click it to expand the grouped section. A plus sign or outline level indicates grouping, not necessarily a hidden-column setting.

The column returns but looks blank. Unhide reveals the column’s cells, but the cells may genuinely be empty, formatted with a font color that blends into the background, or affected by another display setting. Click a cell and check the formula bar to see whether it contains a value or formula. You can also adjust the width if the column is visible but too narrow to read.

Frequently Asked Questions

What is the keyboard shortcut to unhide columns in Excel on Windows?
In Excel for Microsoft 365 on Windows, select the columns around the hidden area and press Ctrl+Shift+0. If Windows intercepts it, use the ribbon sequence Alt, H, O, U, L, or click the Unhide Columns command.

How do I unhide all columns at once?
Click the Select All button at the worksheet’s top-left corner, then use the shortcut or choose Home > Format > Hide & Unhide > Unhide Columns. This reveals hidden columns on the active sheet. Repeat on other sheets if necessary.

Can I unhide column A with a shortcut?
Yes. Select the whole worksheet and use the unhide command, or type A:A in the Name Box and choose Home > Format > Hide & Unhide > Unhide Columns. Selecting only the visible column B may not reliably identify hidden A.

Does unhiding a column change its data or formulas?
No. Unhide changes visibility, not the contents. The values and formulas remain as they were while the column was hidden. Review the revealed information before sharing the workbook.

Why does Ctrl+Shift+0 not work on my computer?
Some Windows settings, keyboard layouts, or other software can capture the shortcut before Excel receives it. Use the ribbon command or its Windows Key Tip sequence instead. On Mac or in a browser, shortcuts may differ or be intercepted, so the ribbon is a practical alternative.

What if the column is grouped rather than hidden?
Use the plus sign or outline controls above the worksheet to expand the grouped columns. The Unhide Columns command addresses hidden columns; expanding an outline is a separate action.

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.