Hide and Unhide Columns
Unhide never acts on the hidden column itself — it reveals whatever falls inside the selection you make first. That one detail explains every awkward case in this topic. Column A has nothing on its left to anchor a selection against, so the Name Box is the only door into it; "unhide everything" is really Ctrl+A followed by the ordinary menu command; and if the heading letters run unbroken while a column is a sliver wide, nothing is hidden at all and Unhide will never do anything, because there is no gap for a selection to span.
The formula
heading letters skip (B then E) genuinely hidden — a selection can span the gap
heading letters unbroken not hidden, only narrow — Unhide has nothing to act on
no heading to the left (column A) no span is possible — the Name Box is the only way in
whole sheet selected (Ctrl+A) the span is everything, so every hidden column returns
an outline bracket above the headings grouped and collapsed, not hidden — click the +A worked example
One report opens with its headings reading A, B, F, G. Another opens with A, B, C, D, E all present, but column C is a hairline.
Ask which of the two you have before choosing a command.
The first has columns C to E hidden, and a selection spanning B to F reveals them in one right-click. The second has nothing hidden — column C simply has a width close to zero, Unhide is inert on it, and the fix is a width rather than a reveal. Running the wrong one of those two is why this topic feels unreliable.
Which one do I need?
| If you want to… | Use |
|---|---|
| The heading letters skip and there is a column either side of the gap | Select those two headings, right-click, Unhide — the ordinary case, and the only one the standard trick covers |
| Column A is the missing one | No selection can span it, so land on the cell via the Name Box and unhide from Home > Format > Hide & Unhide |
| You do not know how many are hidden or where | Ctrl+A makes the whole sheet the span, so one Unhide Columns brings back every one of them |
| Ctrl+Shift+0 does nothing on your machine | Windows claims that combination for switching keyboard layout, so Excel never receives it — use the ribbon, or free the hotkey in Windows language settings |
| Every letter is present but one column is a hairline | It is narrow, not hidden. Unhide cannot help; set a width instead |
| There is a bracket and a + above the headings | They are collapsed into an outline group rather than hidden, and the + reopens them |
| Rows are missing rather than columns | Rows have three further ways of going missing that columns do not |
| A whole sheet tab has disappeared | Right-click any tab and choose Unhide, which lists what is hidden |
Frequently asked questions
Why is Ctrl+Shift+0 not unhiding my columns?
Windows reserves that combination as the "switch keyboard layout" hotkey, so Excel never receives the keystroke and nothing at all happens. The workbook is fine. Either use the ribbon command instead, or reassign the layout hotkey under Windows Settings > Time & language > Typing > Advanced keyboard settings > Input language hot keys. Ctrl+0 for hiding is untouched and still works.
How can I tell whether a column is hidden or just extremely narrow?
Read the heading letters. If they skip — B then E — the columns between really are hidden, and a selection spanning the gap reveals them. If every letter is present and one column is a hairline, its width is small rather than zero, Excel does not regard it as hidden, and no Unhide command will change anything. Widen it by dragging its right border or by setting a Column Width.
Do charts and formulas ignore a hidden column?
Formulas do not — every value keeps calculating exactly as before, which is what makes hiding safe. Charts are the exception: by default a chart drops any series or category sitting in a hidden row or column, so hiding a helper column can empty part of a chart with no warning. Select the chart, then Chart Design > Select Data > Hidden and Empty Cells, and tick "Show data in hidden rows and columns".
Can I stop other people unhiding a column?
Partly. Review > Protect Sheet with "Format columns" left unticked greys out the Unhide command for anyone without the password. Treat that as tidiness rather than security: the values remain in the file, any formula on another sheet still reads them, and a CSV export writes them out in full. Encrypting the workbook is the only measure that actually keeps the contents from being read.
New guides and tools, once a month
DE + EN · double opt-in · no spam