Select the columns on both sides of the hidden ones, or the whole sheet with Ctrl + A (press A a second time if the first press stops at your data), then press Alt, H, O, U, L. That runs Home → Format → Hide & Unhide → Unhide Columns.
The older menu sequence Alt, O, C, U (Format → Column → Unhide) still works in many versions and is shorter. To select a block of columns from the keyboard, press Ctrl + Space, then Shift + Right Arrow across the hidden ones.
The direct shortcut is Ctrl + Shift + 0, but on many Windows PCs it does nothing because a Windows input-language hot key takes it first. Changing that hot key in Windows’ keyboard settings, not in Excel, usually brings it back.
If column A is hidden, there is no column to its left to select. Type A1 in the Name Box, press Enter, then press Alt, H, O, U, L.
If Unhide changes nothing, the column may be a sliver rather than hidden: set a width with Alt, H, O, W. If the command is greyed out, the sheet is probably protected; unprotect it first with Review → Unprotect Sheet.
Latest Video Tutorial – 10 Excel Keyboard Shortcuts (Probably YOU are NOT Using)
In Excel, sometimes users hide some columns while working with data and forget to unhide them before sharing the file, or they hide the columns that they assume are not relevant to the receiver, so the receiver gets the file with hidden columns.
But many times, you want to review the hidden columns, and for this, you don’t need to worry, as Excel has multiple ways to unhide the columns manually or using keyboard shortcuts.
In this tutorial, we have explained shortcut keys to unhide the columns.
Keyboard Shortcut to Unhide Columns in Excel
There are multiple keyboard shortcuts to unhide the columns, but some of them don’t work for everyone and need a change in the Windows settings (see the Ctrl + Shift + 0 section below). Here we have captured only the shortcuts that work for everyone.
Alt → H → O → U → L
Steps to Unhide Columns Using Keyboard Shortcuts
- First, press Ctrl + A + A (press A twice while holding Ctrl when the active cell is inside your data) to select the entire sheet, so you can unhide all the hidden columns of the whole sheet.
- Or select only a specific range of columns using Ctrl + Space and then Shift + Left or Right Arrow keys, if you want to unhide columns only within that range and not in the entire sheet. Make sure the selection covers the columns on both sides of the hidden ones.
- Once the entire sheet or specific columns range gets selected, just press the Alt → O → C → U or Alt → H → O → U → L shortcut keys, and the hidden columns will become visible.
Why Ctrl + Shift + 0 Doesn’t Work
Ctrl + Shift + 0 is Excel’s own shortcut to unhide columns, but on many Windows computers, the same keys are used to switch the keyboard input language, so Excel never gets them. To make it work, open Windows Settings ➜ Time & Language ➜ Typing ➜ Advanced keyboard settings ➜ Input language hot keys, select “Between input languages”, click Change Key Sequence, and set the keyboard layout option to Not Assigned.
Related shortcuts: Ctrl + 0 hides the selected columns, Ctrl + 9 hides the selected rows, and Ctrl + Shift + 9 unhides rows.
Unhide Columns on a Mac
In Excel for Mac, select the columns around the hidden ones and press Command + Shift + 0, or go to Format ➜ Column ➜ Unhide in the menu bar.
Frequently Asked Questions
How do I unhide column A?
Column A has no column to its left, so you can’t select around it. Type A1 in the Name Box and press Enter, and then use Alt → H → O → U → L to unhide it.
Why can’t I unhide the columns?
The sheet may be protected, or the column width may be set very small instead of hidden. Unprotect the sheet (Review ➜ Unprotect Sheet), or select the columns and set a column width with Alt → H → O → W.
How do I unhide all columns at once?
Select the whole sheet with Ctrl + A (or the Select All button at the top-left corner of the sheet) and then use Alt → H → O → U → L.