Unhide Columns in Excel Using the Keyboard

How-to basics · Updated November 20, 2026

In Excel for Microsoft 365 on Windows, select the columns on both sides of the hidden area, then press Alt, H, O, U, L in sequence to unhide the columns. You can also try Ctrl+Shift+0, but that shortcut may be disabled by Windows settings. You do not need to change the workbook’s data; you only need a selection that includes the hidden columns.

This guide covers a single hidden column, a group of columns, and columns hidden at the far left of a sheet. The steps assume Excel for Microsoft 365 on Windows. Mac and web differences are noted where relevant.

What You’ll Need

  • A workbook open in Excel, with the worksheet containing the hidden columns active.
  • A keyboard. A mouse is optional; you can select columns with Go To and type a cell or range reference.
  • Permission to edit the worksheet. If the sheet is protected, you may need its password or the workbook owner’s help before you can change column visibility.

Step-by-Step

  1. Locate the hidden column or gap. Look at the column letters at the top of the worksheet. If the letters jump from, for example, B to E, columns C and D are likely hidden. A small double line between two column headers can also indicate a hidden column. Keep in mind that a very narrow column can look hidden, so check for the boundary rather than relying on the missing letters alone.

  2. Select a range that includes the hidden columns. For a hidden block between visible columns, select the visible column immediately before it and the visible column immediately after it. For example, if C and D are hidden, select B through E. To do this without a mouse, press Ctrl+G to open Go To, type B:E, and press Enter. Replace B:E with the appropriate range for your sheet. Selecting only the visible column on one side usually is not enough; the selection needs to cover the hidden columns.

  3. Open Excel’s Unhide Columns command with access keys. With the relevant range selected, press and release Alt, then press H, O, U, and L, one key at a time. Do not hold all the keys down together. This sequence follows the Windows ribbon path Home > Format > Hide & Unhide > Unhide Columns. Excel should restore the selected hidden columns to their previous widths.

  4. Check the result and adjust the selection if needed. The column letters should now appear in order, and the data in the restored columns should be visible. If nothing changes, repeat the command after selecting a wider range that includes a visible column on each side of the gap. You can use Ctrl+G again and enter a larger reference, such as A:G, if you are unsure which columns are hidden.

  5. Try the direct shortcut if you prefer. Select the columns around the hidden area and press Ctrl+Shift+0. On some Windows computers this shortcut does not work because the operating system or keyboard-language settings intercept it. If it fails, use the Alt access-key sequence in Step 3; that is the dependable keyboard route in Excel for Windows. The shortcut may also behave differently depending on your keyboard layout.

  6. Unhide the first column when there is no column to its left. If column A is hidden, you cannot select a visible column on both sides of it. Press Ctrl+G, type A1, and press Enter to select a cell in the hidden column. Then press Alt, H, O, U, L. This targets the first column even though its header cannot be selected normally. If the first several columns are hidden, enter a cell reference within the hidden range, such as C1, instead.

  7. Unhide every column on the worksheet if you do not know which ones are hidden. Press Ctrl+G, type A:XFD, and press Enter to select all worksheet columns in current versions of Excel. Then use Alt, H, O, U, L. This affects column visibility across the active worksheet, not just the visible area. It does not unhide rows. If you only need one section, select a smaller range to avoid changing other hidden columns.

  8. Use the ribbon path if the access keys are unfamiliar. With the range selected, press Alt and follow the letters Excel displays on screen, or navigate to Home > Format > Hide & Unhide > Unhide Columns. On Excel for Mac, access-key sequences differ; use the Home tab’s Format menu and choose the column unhide command, or use the Mac menu path Format > Column > Unhide when available. In Excel for the web, ribbon access keys can differ by browser, so use the Home tab’s Format controls if the Windows sequence does not match.

Common Mistakes

Selecting only one neighboring column. If C is hidden and you select only B, Excel may not include C in the command. Select both visible boundaries around the hidden area, such as B:D for a single hidden C, or use Go To to select a wider column range.

Holding down the access keys together. Alt, H, O, U, L is a sequence, not a simultaneous shortcut. Press and release each key in order. If you press the wrong letter, press Esc and start again.

Assuming a narrow column is hidden. A column may simply have a very small width. If the column letter is still present, select that column and use Home > Format > Column Width to set a usable width, or use the keyboard to reach the width command. Unhide Columns is intended for columns whose width is hidden, not for ordinary narrow columns.

Expecting the command to unhide rows. The access-key sequence ending in L is for columns. To unhide rows, select the rows above and below the hidden rows, then use Home > Format > Hide & Unhide > Unhide Rows. Do not mistake row numbers on the left for column letters across the top.

Tips

  • Use Go To for precise keyboard selection. Ctrl+G accepts references such as B:E for whole columns or A1 for a cell. After typing the reference, press Enter to return to the sheet with that range selected. This is especially useful when the hidden area is far from the active cell.

  • Start with a small selection. If you know the hidden columns, select just the neighboring visible columns and the hidden span. This keeps unrelated hidden columns elsewhere on the sheet unchanged. Choose the all-columns selection only when you intend to reveal every hidden column on that worksheet.

  • Remember that hidden is not deleted. Unhiding changes what is displayed; it does not remove, edit, or recalculate the contents of the columns. If the columns contain sensitive information, revealing them may expose that information to anyone who can view the sheet.

  • Save after confirming the layout. Once the correct columns are visible, save the workbook with Ctrl+S. If you are working in a shared file, allow the save or sync to finish before closing it.

  • Expect platform differences. On a Mac, use the Excel ribbon or the Format menu rather than assuming Windows Alt access keys will work. In a browser, keyboard access keys may be affected by browser shortcuts. The Go To selection method is still useful, but use the on-screen ribbon labels to finish the command if the key sequence differs.

Troubleshooting

Nothing happens after Ctrl+Shift+0. This shortcut is unavailable on some Windows setups. Use the selection method and press Alt, H, O, U, L instead. If you are using a nonstandard keyboard layout, the keys may not map as expected; following the access-key prompts shown by Excel can help.

The access-key sequence opens the wrong command or does nothing. Confirm that Excel is the active window and that you are pressing each key separately. Start with Alt and look for the letters displayed on the ribbon. If they differ, follow the displayed prompts rather than guessing. Also confirm that the Home tab is available; in a simplified or customized ribbon, use the visible Format menu to locate Hide & Unhide.

The columns still do not appear. Expand the selected range. For a hidden block, include the visible columns on both sides, then run Unhide Columns again. For column A, use Go To and enter A1. If the selected range is correct but the command is unavailable, the worksheet may be protected. Check the Review tab for Unprotect Sheet; if a password is required, ask the workbook owner rather than trying to bypass protection.

The column is visible but its contents are still hard to read. The column may have a very small width, or its contents may be formatted in a way that makes them hard to see. Select the column using Go To, then use Home > Format > Column Width or AutoFit Column Width to restore a useful display. Unhide the column first only if its header was missing.

The command reveals some columns but not the ones expected. Check that you are on the correct worksheet and that the hidden columns are within your selected range. A workbook can contain multiple sheets with different layouts. Click or navigate to the intended sheet, make the selection again, and repeat the command. If a filter or outline is involved, note that those features can hide rows or collapse grouped data; they are not necessarily hidden columns.

Frequently Asked Questions

What is the keyboard shortcut to unhide columns in Excel?
On Windows, select a range that includes the hidden columns and press Ctrl+Shift+0. Because Windows settings can intercept that shortcut, the ribbon access-key sequence Alt, H, O, U, L is a useful alternative.

Can I unhide columns without using a mouse?
Yes. Press Ctrl+G, enter a range such as B:E, and press Enter. Then run the Unhide Columns access-key sequence. For the first column, use a cell reference such as A1 instead of trying to select a header that is not visible.

How do I unhide all columns at once?
In Excel for Windows, open Go To with Ctrl+G, enter A:XFD, press Enter, and run Unhide Columns. This applies to the active worksheet. It does not unhide rows or change other worksheets.

Why can’t I unhide a column when it is selected?
The selection may not include the hidden column, or the sheet may be protected. Select the visible columns on either side of the gap, or use Go To to select a wider range. If protection is the issue, you will need permission to unprotect the worksheet.

Does this keyboard method work in Excel for Mac?
The Windows Alt access-key sequence is not a reliable Mac shortcut. Use the Home tab’s Format controls or, where available, Format > Column > Unhide. Mac keyboard shortcuts and menu access can vary by Excel version and keyboard settings.

Does unhiding restore the original column width?
Usually, yes: Unhide Columns restores the hidden column at its existing width. If the column was merely made narrow rather than hidden, set its width or use AutoFit Column Width instead.

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.