A hidden column comes back when you select the columns on both sides of it, right-click either selected header, and choose Unhide. That works in every Excel version from 2007 through Microsoft 365. The catch is that this only fixes columns someone hid. If Excel shows no hidden column marker, your data is filtered, grouped, or squeezed to zero width, and each of those needs a different repair. Find out which one you have before you click anything.

A hidden column removes the column from view but keeps its data, formulas, and formatting intact. The header letters around it jump, so D sits next to F with no E between them. That gap in the letter sequence is your diagnosis. Excel also draws a thicker double line at the boundary of a hidden column, which is easy to miss on a busy sheet.

Because the data never leaves the sheet, unhiding is safe. Nothing recalculates, no references break, and no formatting is lost. The risk runs the other way: a column hiding behind a filter is invisible until you clear the filter, and people often widen columns for ten minutes before realizing a filter is the culprit.

The methods below apply to Excel for Windows and Mac, plus Excel for the web. They assume the default Excel options and no protected sheet. Protected sheets behave differently, and that case gets its own section. Work through the methods in the order listed, since the cheap checks come first.

Why the Column Letters Sometimes Spell Out the Cause

Excel gives you a free diagnostic before you touch a menu. Look at the column letters in the header row. If they run A, B, D, E, column C is hidden. If they run A, B, C and the sheet simply looks wrong, nothing is hidden. That single check prevents most wasted troubleshooting.

The second tell is the divider line. Excel draws a slightly heavier line between two visible columns when the column between them is hidden. Zoom in to 100% or higher, because at 60% zoom the difference between a hidden-column divider and a normal gridline is nearly invisible.

The third tell is the row of filter buttons. A funnel icon on any header cell means filter mode is active. While a filter hides rows, it doesn't hide columns, but people routinely mistake the two, and Excel's filter dropdowns can make a whole region look truncated. Column hiding and row hiding use the same Unhide command, which is where much of the confusion starts.

If the letter gap and the thick divider are both absent, stop reading the hidden-column methods and jump to the filter, grouping, and width sections. You'll save the most time by testing the right cause first.

The Standard Unhide Route, Step by Step

Select the columns that straddle the gap. If C is hidden, drag across the headers for B and D. The selection must include at least one column on each side of the hidden one, and the hidden column's letter will appear highlighted even though its cells don't show.

1: Click the header letter for the visible column immediately left of the gap and drag right to the visible column on the other side. For column C, that means selecting B through D. 2: Right-click either selected header letter. On a Mac with a trackpad, use a two-finger click. 3: Choose Unhide from the context menu. The command sits near the bottom of the list and only appears when your selection spans a hidden column. 4: Confirm the return. The letter sequence should run continuously again, and the divider line should become a normal gridline. 5: Check the contents before you save. The column returns with whatever formatting and formulas it had, including any conditional formatting rules.

If Unhide is grayed out, your selection didn't include a hidden column or the sheet is protected. Select the whole sheet with the box at the top-left corner where the row and column headers meet, then try Unhide again. That corner box is the fastest reset for a puzzle selection.

Whole-sheet selection has one trap worth knowing. If the worksheet contains an outline with grouped columns, selecting everything and choosing Unhide will also expand every group in the sheet, which can make a carefully collapsed report suddenly enormous. Hit Undo if that happens; nothing is lost.

Right-Click, Keyboard, and Format Menu: Three Ways to the Same Command

The right-click menu is the fastest route, but it isn't the only one, and knowing the alternates helps when a menu doesn't behave. Excel's own help documentation lists all three paths to the same Unhide command, and they produce identical results.

Method Where to find it Steps needed Best for
Right-click Context menu on selected headers 2 (select, click Unhide) Everyday use
Keyboard Alt, then H, O, U on Windows 4 keystrokes Repeated unhiding
Format menu Home tab, Format, Hide & Unhide 3 clicks Users who prefer menus
Column header drag Double-click the divider 1 action, only if width is the issue Zero-width columns

The keyboard route is Alt, H, O, U in sequence on Windows, with no held keys. On Excel for Mac, the ribbon shortcuts differ by version, so the safer Mac path is the Format menu under the Home tab. Both lead to the same Hide & Unhide submenu, where Unhide Columns sits.

The menu method adds a step but shows the command's name in full, which is useful when a context menu appears cut off on a small screen. A right-click menu that opens off-screen on a laptop with display scaling problems is a real annoyance; the ribbon never has that problem.

Whichever route you use, select the flanking columns first. All three methods gray out without that selection, and none of them has a "find hidden columns for me" option. Excel expects you to know where the gap is.

Unhide Everything at Once, and the Cost of Doing It

Select the entire sheet, then run Unhide once. Every hidden column and hidden row in that worksheet returns in a single command. Excel's documentation confirms the command works on the whole selection, but the side effects deserve a warning.

Row heights reset to default for any rows that were hidden with custom heights. Column widths of hidden columns come back at whatever width they had when hidden, which is correct, but any row you hid deliberately for a dashboard layout will now be visible. On a shared report, that can expose working rows you meant to keep out of sight.

Use the whole-sheet method when you've inherited a file from a colleague who is no longer around to ask. Skip it when the sheet is a finished template, because the unhide sweep is all-or-nothing and Undo is your only recovery.

Two commands exist for the judgment call. Unhide restores everything in the selection. Hiding again is easy for the columns you didn't want; just reselect and choose Hide. There's no command that lists hidden columns, which is why a letter-gap scan remains the practical first step on unfamiliar workbooks.

For a workbook with dozens of hidden columns across several sheets, unhide them sheet by sheet rather than trusting a single sweep. The sheet tabs are where the hiding often repeats, and a sweep on Sheet1 tells you nothing about Sheet2.

Excel for the Web: Where the Menu Moves

The browser version of Excel keeps the same logic but moves the controls. Select the flanking column headers, right-click, and choose Unhide Columns. If the browser menu doesn't offer it, use the Home tab, then Format, then Hide & Unhide in the Cells group.

The web version has one genuine limitation: some older workbooks saved in legacy formats open in read-only or compatibility mode in the browser, and the Hide & Unhide commands are unavailable there. If the Format menu is grayed out, the file is the problem, not your selection. Open it in the desktop app to make the change, then return to the browser.

Shared workbooks in OneDrive or SharePoint add a second wrinkle. If a co-author has the file open for editing, your Unhide command may be queued or rejected. Check for a lock icon or a "someone else is editing" notice near the filename before troubleshooting your selection.

The web version is fine for a quick unhide in a shared sheet, but anything involving grouped outlines or complex filters is smoother in the desktop app. That's a workflow note, not a bug.

Hidden by a Filter or Group: Two Different Problems

Columns can look hidden without being hidden. A filter hides rows, but a filtered range can make columns look truncated because the visible rows change. Clear the filter first by clicking the funnel button on the header and choosing Clear Filter from the dropdown menu. If the columns snap back, you never had a hidden column at all.

Column groups are a separate mechanism. If the header row shows small plus and minus buttons above the letters, the sheet uses outline grouping. Click the plus sign at the top of the group to expand it. Grouping is common in financial models and reports built by anyone who uses Excel's Subtotal feature, because Subtotal creates an outline automatically.

If both a filter and hidden columns exist on the same sheet, clear the filter first. A hidden column inside a filtered range can interact with the filter in ways that make the gap look permanent. Clearing the filter resets the view, and then the Unhide command behaves predictably.

Columns at Zero Width and Other No-Hidden-Column Impostors

The trickiest case is a column that is technically visible but squeezed to nothing. Someone dragged its right border to the left edge, or a macro set the width to zero. There's no letter gap, no thick divider, and no Unhide command to run, because nothing is hidden.

Double-click the divider to the right of the column's header. Excel auto-fits the column to its contents. If the column contains only a header and the header is narrow, the column returns thin but visible, and you can drag it wider from there.

For a precise fix, right-click the header, choose Column Width, and type a number. Excel's default is 8.43 characters for the Calibri 11 font, so setting 8.43 restores the standard width. The Format menu's AutoFit Column Width option does the same job as the double-click.

A related impostor: frozen panes. When panes are frozen in the wrong place, columns appear to be missing because the pane divider hides them as you scroll. Check the View tab and look at the Freeze Panes button. If it says Unfreeze Panes, you have frozen panes active. Unfreezing reveals the columns that were scrolling behind the frozen band.

Protected Sheets, Shared Files, and Other Times Unhide Is Grayed Out

A grayed-out Unhide command usually has one of three causes. The sheet is protected, the workbook is protected, or the file is in a read-only state. Each has a different fix, and guessing wrong wastes the most time of any method in this guide.

Wait, I got that wrong. The third cause is selection, not file state. A file in a read-only state will refuse the save but will still let you unhide if the sheet protection allows it. The three causes are sheet protection, workbook protection, and a selection that doesn't include a hidden column. Check the selection first.

Check protection under the Review tab. The Protect Sheet button becomes Unprotect Sheet when protection is on. You'll need the password the owner set. If you don't have it, contact the owner; there is no legitimate workaround, and Excel's own support guidance says the same.

Workbook protection, set under Review and then Protect Workbook, blocks structural changes including hiding and unhiding. The same password conversation applies. In an organization, the file owner or your IT help desk is the contact, and for a OneDrive file, the co-owner listed in the sharing panel is usually the right person.

A Ten-Second Check for the Next Time It Happens

Before you save a workbook that took effort to lay out, press Ctrl+Shift+U on Windows and watch for the whole-sheet unhide to change anything. If nothing changes, nothing is hidden. Now press Ctrl+Z to undo. That test costs a few seconds and tells you the file's state before a colleague notices a working column you left visible.

For files you share, document hidden columns in a separate note or in the workbook's properties. Excel has no built-in report of which columns are hidden, which is why hiding decisions get lost between versions. A one-line note in the worksheet's header area or a comment on the sheet's first cell is enough.

Keep a copy of the workbook before unhiding a whole sheet. You can't see what a hidden column contained, and occasionally a column clinched a caseβ€”a working column with draft commentary was hidden for a reason, and making it visible in a meeting is exactly what the hiding prevented. The copy is cheap insurance.

The best prevention is a shared convention: hide columns only in a copy, and keep the working sheet intact. That one habit removes the entire class of "where did column E go" questions from your next handover.

FAQ

What's the fastest way to unhide a single column in Excel?

Select the columns on both sides of the gap, right-click either header, and pick Unhide. That's two actions and works in every current version. The hidden column's data never left the sheet, so the operation is instant and safe.

Why is Unhide grayed out even though I see a letter gap?

Your selection probably doesn't include a visible column on each side of the gap, or the sheet is protected. Select the whole sheet using the corner box and try again, then check Review and protect to rule out protection with a set password.

Can I unhide columns without a mouse?

On Windows, press Alt, release the keys, then press H, O, and U in sequence. That runs Unhide Columns on the selected flanking columns. There's no built-in command that finds hidden columns for you; the letter gap is your only locator.

What if the column letters look continuous but a column is still missing?

That's a width or pane problem, not a hidden column. Double-click the divider to the right of the header to auto-fit the width, and check View and Freeze Panes to see if panes are active. Both cases mimic hiding but have different fixes.

Does unhiding a column affect formulas or data?

No. The column's contents, references, and formatting were preserved the whole time, so unhiding only changes what the screen shows. The one thing to watch is a column you hid deliberately, such as a working column for comments; unhide it in a copy of the file if you plan to share.

How is hiding columns different from hiding rows?

It's the same Unhide command and the same principle, but the visuals and shortcuts differ: hidden rows show a thicker line between row numbers rather than a letter gap. Row heights also reset to default when a whole-sheet unhide restores hidden rows with custom heights.

Can I unhide columns in the free Excel web app?

Yes, via right-click and Unhide Columns, or Home, Format, Hide & Unhide. Legacy-format files opened in the browser go read-only and gray out the command; open them in the desktop app to make the change. Shared files being edited by a co-author may also refuse the command temporarily.

Why did my hidden column come back with different formatting?

Formatting returns as it was, but conditional formatting and number formats may look different if the sheet's rules reference the hidden column or its neighbors. Check the rules under Home and Conditional Formatting if numbers suddenly show as dates or currency.