How to Unhide Columns in Excel: 5 Methods That Actually Work

You opened the spreadsheet, scanned across the headers, and column B is gone. Or maybe column A. Or columns D through G all at once. The data is still there — Excel just decided to tuck it away. Hidden columns happen for a hundred reasons: someone formatted a worksheet for a meeting, an old VBA macro fired on open, or you clicked the wrong menu while juggling six things. Whatever the cause, you need that data back.

The fastest answer? Select the two columns that sit on either side of the missing one, right-click on a column header, and choose Unhide. Done. But that quick fix breaks down in a few common situations — column A on its own, columns with width set to zero, sheets locked behind frozen panes, or grouped outlines that look hidden but aren't. So this guide walks through five complete methods, covers the keyboard shortcut everyone Googles (Ctrl+Shift+0 — yes, it really is broken by default on Windows), and finishes with troubleshooting for when nothing seems to work.

You'll also pick up the hide/unhide tricks for rows, individual sheets, and entire workbooks. By the end, the only mystery left will be why Microsoft built so many ways to do the same thing.

Method 1: Select Adjacent Columns Then Right-Click Unhide

This is the method 90% of Excel users reach for, and there's a reason — it works on every version going back to Excel 2003. The logic is simple: Excel needs to know which columns to bring back. You give it that information by selecting the columns on either side of the missing range.

Say column B is hidden. Click the header for column A. Hold down Shift. Click the header for column C. You'll see both columns highlighted in light blue, with a thin line between them where B used to live. Now move your mouse over either highlighted header, right-click, and a context menu appears. Scroll down. Unhide sits near the bottom of the list, between Hide and Column Width. Click it. Column B reappears, with all the data exactly where you left it.

The same logic extends to multiple hidden columns. If columns D, E, and F are all hidden, select column C, hold Shift, click column G, right-click, Unhide. All three come back at once. You don't need to know exactly how many are hidden — Excel figures it out from the gap.

One subtle gotcha: the selection has to fully bracket the hidden range. Selecting only column A when B is hidden won't work, because Excel has no right boundary. Same problem if you select only the column after the gap. The little detail matters.

Method 2: Select All Columns Then Unhide Everything

What if you don't know which columns are hidden? Or maybe a colleague hid a dozen of them across different parts of a 50-column report. Hunting for each gap is a waste of time. Select All handles it in two clicks.

Look at the very top-left of your worksheet, just above row 1 and to the left of column A. There's a small triangle inside a gray box — sometimes called the "Select All" button or the "corner button." Click it once. Every cell on the sheet highlights. Now right-click on any column header letter (any visible one will do), and choose Unhide from the context menu. Every hidden column on the sheet reappears at once.

Faster keyboard option: Ctrl+A selects the current data region. Press Ctrl+A a second time to extend to the entire sheet. Then right-click and unhide as above. Works in every desktop version of Excel.

The same trick works for rows — Select All, right-click on a row number, choose Unhide. One pass, every hidden row back.

Method 3: Home Tab Ribbon Format Dropdown

Some people prefer the ribbon over right-click menus, and Excel accommodates them with a dedicated Format menu. Click the Home tab. In the Cells group (third from the right), find the Format dropdown. Click it and a long menu appears with options for cell size, visibility, organizing sheets, and protection.

Hover over Hide & Unhide. A submenu fans out with six items: Hide Rows, Hide Columns, Hide Sheet, Unhide Rows, Unhide Columns, Unhide Sheet. Click Unhide Columns, and Excel applies the unhide to whatever you currently have selected. So before clicking the dropdown, select a range that brackets your hidden columns (or use Select All for a full-sheet unhide).

This method is the slowest of the bunch — three clicks plus a hover — but it's discoverable. If you've never used the right-click menu and you're hunting through ribbons, you'll find it here. For Excel for Mac, the path is identical: Home tab, Format, Hide & Unhide, Unhide Columns.

Method 4: Keyboard Shortcut Ctrl+Shift+0 (And Why It's Probably Broken)

Microsoft documents Ctrl+Shift+0 (that's the number zero, not the letter O) as the keyboard shortcut to unhide columns. It should be the fastest option of all — select your bracket columns, tap three keys, done. Except for most Windows users, nothing happens. The columns stay hidden. The shortcut appears to be broken.

It's not actually broken. Windows 10 and Windows 11 reserve Ctrl+Shift+0 for switching the keyboard input language. The OS grabs the key combination before Excel ever sees it. You can confirm this by pressing Ctrl+Shift+0 in any application — if you have more than one input language installed, Windows quietly switches between them.

Two ways to fix this. The clean way: turn off the conflicting hotkey in Windows Settings.

1. Open Settings (Windows key + I)
2. Go to Time & Language → Language & Region (Windows 11) or Language (Windows 10)
3. Scroll down and click Typing (Windows 11) or Advanced keyboard settings (Windows 10)
4. Open Advanced keyboard settings → Input language hot keys
5. In the Text Services dialog, highlight "Between input languages" and click Change Key Sequence
6. Set both columns to Not Assigned. Click OK

Close Excel and reopen it. Ctrl+Shift+0 now reaches Excel correctly and unhides columns. Same fix works for the row shortcut Ctrl+Shift+9, which has the same conflict on some setups.

The quick way: don't bother with the OS fix. Press Alt, H, O, U, L in sequence (Home tab, Format, Hide & Unhide, Unhide Columns). It's five keys instead of three, but every key works on every Windows install without configuration. Excel keyboard navigation through the ribbon is consistent across every modern version.

Method 5: VBA Macro for Bulk Unhiding

When you need to unhide columns across dozens of sheets, or you want a one-click button that runs the same fix every morning, a tiny VBA macro saves real time. The core code is a single line:

Columns.EntireColumn.Hidden = False

That line unhides every column on the active sheet. Drop it inside a Sub and you have a working macro. Open the VBA editor with Alt+F11, insert a new module from the Insert menu, and paste this:

Sub UnhideAllColumns()
  Columns.EntireColumn.Hidden = False
  Rows.EntireRow.Hidden = False
End Sub

Save the file as .xlsm (macro-enabled workbook). Back in Excel, press Alt+F8, select UnhideAllColumns, click Run. Every hidden column and row on the active sheet returns. Want it to run across every sheet? Loop through the Worksheets collection:

Sub UnhideEverywhere()
  Dim ws As Worksheet
  For Each ws In Worksheets
    ws.Columns.EntireColumn.Hidden = False
    ws.Rows.EntireRow.Hidden = False
  Next ws
End Sub

Bind it to a button on the ribbon or a Quick Access Toolbar icon and unhiding becomes one click. For a deeper dive into formulas you can pair with these macros, the excel functions list covers the most-used Excel functions.

Unhiding Column A (The Special Case)

Column A doesn't have a column to its left. So the standard "select columns on either side and right-click" trick collapses on the very first column. You need a workaround.

The easiest: Name Box navigation. Click into the Name Box (the white box to the left of the formula bar, usually displaying the current cell address). Type A1 and press Enter. Excel jumps to cell A1 even though the column header is hidden. Now go to Home tab → Format → Hide & Unhide → Unhide Columns. Column A returns.

Alternative: select column B by clicking its header, then drag your mouse left into the gray area above row 1, just past the column B edge. The cursor changes to a small split-arrow. Right-click in that narrow strip and choose Unhide. The same approach reveals column A by extending the selection past the left edge.

Hidden Columns vs Filtered Data (They're Different)

People confuse these two states constantly. The fix is different for each, so it pays to identify which one you're looking at.

Hidden columns were manually hidden by right-click → Hide, by a macro, by the Format menu, or by Ctrl+0. The column letters skip a number (A, C, D — B is hidden). The data exists but isn't displayed. You unhide using any of the five methods above.

Filtered data comes from the Data tab → Filter feature, which hides rows (not columns) that don't match a criterion. The row numbers turn blue and skip values (rows 1, 4, 5, 8 — 2, 3, 6, 7 are filtered out). The filter triangles appear in column headers. Unhide commands won't help. Instead, click the filter triangle in the column header and choose Select All to clear the filter, or use Data → Clear from the ribbon to remove every active filter.

A workbook can have both hidden columns and active filters at the same time. Check row numbers (blue + skipped = filtered) and column letters (skipped = hidden) to tell which is which.

When Unhide Doesn't Seem to Work

You followed the steps, right-clicked, chose Unhide, and nothing changed. Five possibilities to check:

1. Column width is zero, not hidden. Right-click the column header where you expect data to be, pick Column Width, set it to 10 or larger. Different beast — Excel sees it as visible but invisibly narrow.
2. Frozen panes blocking the view. View → Freeze Panes → Unfreeze Panes. Your view was scrolled past the data, not hiding it.
3. Worksheet protection enabled. If the sheet is protected, Unhide is grayed out. Review tab → Unprotect Sheet, enter the password if set, then unhide normally.
4. The column isn't hidden — the sheet is. Hidden sheets show no tab. Right-click any sheet tab → Unhide → pick the sheet from the list.
5. Workbook-level hide. The whole Excel window can be hidden via View → Hide. Other workbooks become invisible. View → Unhide → pick the workbook from the dialog.

If columns appear to be hidden but Column Width shows 0, both setting a width AND running Unhide may be needed depending on how the column got there. Excel treats zero-width and Hidden=True as separate states even though they look identical.

Hiding and Unhiding Rows (Same Logic, Different Direction)

Every column trick has a row equivalent. The right-click method works on rows: select the row number before the hidden range, Shift-click the row number after, right-click on a row header, choose Unhide. To hide a row, select it, right-click, Hide. Keyboard shortcut for hiding rows is Ctrl+9. For unhiding, Ctrl+Shift+9 — same Windows hotkey conflict as Ctrl+Shift+0, same fix.

The Home tab path: Format → Hide & Unhide → Unhide Rows. The VBA equivalent is Rows.EntireRow.Hidden = False. If you wanted a one-button macro that resets every hidden row and column at once, the UnhideEverywhere code from Method 5 above does exactly that. For users coming from how to unhide cells in excel, the row workflow is identical — same selection logic, same context menu.

Group + Outline: Columns That Look Hidden but Aren't

Sometimes you see a row of tiny plus or minus icons above your column headers, with brackets indicating ranges. That's the Outline feature, accessed via Data → Group. Columns or rows inside a group can be collapsed (looking hidden) or expanded (visible). Click the + icon to expand, the - icon to collapse. The numbered buttons at the top-left (1, 2, 3) jump to specific outline levels.

Why use Group over Hide? Three reasons. First, the icons make collapsed sections discoverable — anyone opening the sheet can see something's collapsed and click to expand. Second, multiple outline levels nest (Quarter rolls up to Year, Department rolls up to Region). Third, expanding and collapsing is one click instead of a full unhide sequence. For executive summaries or large datasets with drill-down sections, Group beats Hide.

To remove a group entirely: select the columns, Data → Ungroup. To clear all outline levels at once: Data → Ungroup → Clear Outline.

Workbook and Sheet-Level Hiding

Excel can hide more than columns. Entire sheets can vanish (right-click the sheet tab → Hide). Bring them back with right-click any tab → Unhide → pick the sheet from the list. Some sheets get hidden at the "very hidden" level by VBA — those don't appear in the Unhide dialog. You need the VBA editor (Alt+F11), find the sheet in the Project window, change its Visible property from xlSheetVeryHidden to xlSheetVisible in the Properties pane.

Whole workbooks can disappear too. View tab → Hide makes the current Excel window invisible while Excel keeps running. View → Unhide brings back any hidden workbook from the resulting dialog. This is useful when you're presenting and don't want to flash sensitive workbooks during a window switch. Important: a hidden workbook still saves changes if you close Excel. Don't forget to unhide before quitting if you want to verify the state visually.

Excel Online and Mobile Support

Excel for the web supports hiding and unhiding columns through the same right-click menu. Open a workbook in OneDrive or SharePoint, click a column header, right-click, choose Hide or Unhide. Keyboard shortcuts work too, including Ctrl+0 to hide and (with the language hotkey caveat) Ctrl+Shift+0 to unhide. The Home tab Format menu is present but the path is slightly different — look for Format under the Home tab's overflow menu on smaller screens.

Mobile Excel (iOS and Android) handles hide/unhide via long-press on a column header. The popover menu includes Hide. To unhide, select the columns on either side with a swipe, long-press, and choose Unhide. Performance with thousands of hidden columns is slower on mobile — for sheets that big, do the bulk unhide on desktop and sync the result.

One more trick worth knowing: the Status Bar at the bottom-right of Excel shows how many cells are in your current selection. If you select column A through column J and see a cell count that doesn't match what should be 10 full columns of data, that's a hint that some columns inside the range are hidden. The excel cheat sheet covers more status bar tricks worth memorizing. For protecting visible columns and ranges, see freeze panes in excel for the locking and freezing options.