Hidden cells, sheets, and workbooks in Excel aren't lost — they're just out of sight. Whether you accidentally clicked the wrong context menu, inherited a spreadsheet from a colleague who liked to tuck things away, or you're hunting for a Personal Macro Workbook that vanished, the unhide commands you need are tucked into menus you may never have opened. This guide walks through every scenario: rows and columns, individual worksheets, the entire hidden workbook layer, plus the stubborn xlVeryHidden sheets that ignore the regular Unhide menu altogether.
Here's the thing — Excel actually offers three completely separate unhide systems, and most users only know one of them. You might be a wizard at right-clicking column headers, yet stare blankly at a "Workbook is hidden" message. Or maybe you can resurrect a worksheet in your sleep, but the Name Box trick for revealing column A leaves you cold. By the time you finish reading, you'll know all of them. We'll cover the menu paths, the keyboard accelerators, the multi-select tricks in Excel 365, and the one-line VBA workaround for sheets that refuse to budge.
Practitioners working in finance, operations, audit, and research all run into hidden data daily. A model handed off between teams often has columns hidden to protect intermediate calculations, or rows collapsed because someone wanted a cleaner print preview. Knowing how to surface those quickly — without breaking formulas or accidentally deleting structure — is a small skill with outsized payoff. So let's dig in.
Hiding isn't a bug — it's deliberate. People hide rows and columns to declutter wide spreadsheets, conceal helper calculations, or restrict what colleagues can casually edit. Worksheets get hidden to keep raw data tabs away from a polished dashboard. Whole workbooks (yes, entire workbooks) can be hidden so they load silently in the background — the classic example being the Personal Macro Workbook, which keeps your reusable macros available without cluttering your workspace.
You'll also encounter hidden content from third parties: a budget template you downloaded, a quarterly report from accounting, or a vendor file with embedded macros. Sometimes the hiding is protective; sometimes it's just clutter. Either way, knowing how to reveal what's there gives you control. And if you ever need to re-hide things after auditing them, the same menus work in reverse.
One thing to keep in mind before you start unhiding: don't just unhide everything reflexively. Hidden columns often contain intermediate formulas the sheet relies on. Unhiding them doesn't break anything (the formulas still calculate), but if you then start editing values in those cells, you can wreck downstream results. Look first, then decide.
Use this to figure out which method you need:
This is what most people mean when they ask how to unhide in Excel. A column is missing — you can see B, then D, but C has slipped out of view. The fix is simple, but there are three slightly different routes depending on what's hidden and where.
Click the header letter to the left of the hidden column (so B in our example), hold Shift, then click the header to the right (D). Both columns highlight blue. Now right-click anywhere in that selection and choose Unhide. Column C reappears. The same procedure works for rows — select the row numbers above and below the gap, right-click, Unhide.
Some keyboards make right-clicking awkward, or you might prefer the discoverable menu route. Select the rows or columns around the hidden ones, then go to Home > Format (in the Cells group) > Hide & Unhide > Unhide Columns (or Rows). Same result, slower path, but it's worth knowing for training other people.
What if the hidden column is column A — the very first one? You can't select B and "something to the left of A," because nothing exists there. Here's the workaround: click the Name Box (the little reference box in the top-left, beside the formula bar). Type A1 and press Enter. The invisible cell A1 is now active. Then go to Home > Format > Hide & Unhide > Unhide Columns. Column A pops back into view. Same trick works for row 1 with Unhide Rows.
Hides cell ranges within a single sheet. Unhide via right-click on adjacent headers or Home > Format > Hide & Unhide. Most common scenario, easiest to fix.
Hides entire sheet tabs at the bottom. Unhide via right-click on any visible tab > Unhide. In Excel 365, you can select multiple sheets in the dialog and unhide them at once.
Hides entire Excel windows. Use View tab > Unhide Window. Personal Macro Workbook is the classic example — it loads on startup but stays hidden.
Set via VBA: Worksheet.Visible = xlVeryHidden. The standard Unhide dialog won't show these. Only VBA or Visual Basic Editor can reveal them.
Open a workbook, glance at the tab strip along the bottom, and something feels off. The Summary sheet should be there, but it's gone. Or maybe a colleague mentioned a "Raw Data" tab you've never seen. Chances are someone hid those sheets. Bringing them back takes two clicks.
Right-click on any visible sheet tab. In the context menu, choose Unhide. A dialog box appears listing every hidden sheet in the workbook. Pick the one you want and click OK. Done.
If Unhide is greyed out in that menu, it means there are no normally-hidden sheets to reveal. But that doesn't mean none exist — there might be very hidden sheets lurking. We'll get to those.
Older versions of Excel forced you to unhide one sheet at a time from the dialog, which was tedious if someone had hidden a dozen. Excel 365 fixed this: in the Unhide dialog, hold Ctrl and click multiple sheets to select them. Click OK and they all reappear. If you're on Excel 2019 or earlier and need to mass-unhide, you'll need a tiny VBA loop (covered below).
Like rows and columns, sheets can also be unhidden via the ribbon: Home > Format > Hide & Unhide > Unhide Sheet. Identical result. Some keyboard-heavy users prefer this because it's reachable via Alt + H + O + U + H.
Right-click: Select adjacent row numbers or column letters, right-click, choose Unhide.
Ribbon: Home > Format > Hide & Unhide > Unhide Rows or Unhide Columns.
Edge case: For column A or row 1, type A1 in the Name Box first, then use the ribbon path.
Shortcut: Ctrl+Shift+9 unhides selected rows. Ctrl+Shift+0 unhides columns (may be blocked by your OS regional keyboard settings).
Right-click tab: Right-click any visible sheet tab, choose Unhide, pick the sheet from the list.
Ribbon: Home > Format > Hide & Unhide > Unhide Sheet.
Multi-select: Excel 365 lets you Ctrl-click multiple sheets in the Unhide dialog.
If greyed out: No standard hidden sheets exist, but very hidden sheets might. Open the VBA editor with Alt + F11 to check.
View tab path: View > Unhide (in the Window group). A dialog lists all currently hidden workbook windows.
Typical use: Bringing back the Personal Macro Workbook (PERSONAL.XLSB) after it's been hidden via View > Hide.
If Unhide is greyed: No hidden workbooks are currently open. The file might not even be loaded — open it manually first.
Open VBA editor: Press Alt + F11. In the Project Explorer, find the sheet under VBAProject > Microsoft Excel Objects.
Properties pane: Press F4 to open Properties. Locate the Visible property and change xlSheetVeryHidden (-1) to xlSheetVisible (-1... wait, that's the same number — actually xlSheetVisible is -1, xlSheetHidden is 0, xlSheetVeryHidden is 2). Set it to -1.
Quicker VBA: In the Immediate window (Ctrl + G), type Sheets("SheetName").Visible = -1 and press Enter.
This one trips everyone up the first time they see it. You double-click an Excel file, the app launches, you see the ribbon, you see your toolbars — but no spreadsheet. Where did it go? Almost certainly the workbook window itself is hidden.
To check, go to the View tab in the ribbon. In the Window group, click Unhide. If Excel finds a hidden workbook in your current session, a dialog appears listing it. Select the workbook and click OK. The window reappears, your data visible again.
The most common situation where this happens involves the Personal Macro Workbook. When you record your first macro and tell Excel to save it to "Personal Macro Workbook," Excel creates PERSONAL.XLSB in your XLSTART folder. From then on, that file opens automatically every time Excel launches — but it's hidden by default, so it doesn't clutter your view. If you ever need to edit the macros directly, you have to View > Unhide first.
There's also a less common scenario: someone manually hid a workbook via View > Hide and then saved it, so it stays hidden across sessions. You'll need to reopen the file (it should still appear in your recent files) and immediately go View > Unhide.
Two possibilities. First, no workbook is currently hidden — the menu simply has nothing to act on. Second, the file you're looking for isn't open yet. Excel can only unhide windows it has in memory. Open the file from File > Open or your recent list, and the Unhide command should activate.
If you live in Excel all day, the right-click menu starts to feel slow. Memorise a handful of shortcuts and you'll save real time.
Hit Alt once to reveal ribbon shortcuts. Then H for Home, O for Format, U for Hide & Unhide, then R, C, or S for Unhide Rows / Columns / Sheet. The full sequence is Alt + H + O + U + R (for rows) or Alt + H + O + U + S (for sheets). It takes a couple of seconds, but it's hands-on-keyboard the whole way.
For sheets stuck on xlVeryHidden, the fastest fix is the VBA Immediate window. Press Alt + F11, then Ctrl + G. Type:
Sheets("YourSheetName").Visible = True
and press Enter. The sheet becomes visible immediately, no dialog needed. To unhide every sheet in the workbook at once, paste this loop into a code module and run it:
For Each ws In ThisWorkbook.Worksheets: ws.Visible = xlSheetVisible: Next ws
Unhiding usually works on the first try. But sometimes nothing happens, or the result looks wrong, and the cause isn't obvious. Here are the snags people hit most often.
For rows or columns: your selection probably doesn't span the hidden range. Click the row or column letter directly to the left and right of the gap (not just nearby cells), then try again. For sheet tabs: either no hidden sheets exist, or they're all very hidden — open the VBA editor to confirm.
The column might have its width set to a value just above zero, like 0.08. Excel considers that "visible," but you'd never see it. Select the column header, right-click, Column Width, and set it to something usable like 10 or 12.
An active filter can hide rows independently of the hide/unhide mechanism. Look for the funnel icon on your column headers. Clear the filter via Data > Clear, or toggle the Filter button off entirely, and the rows reappear.
If the workbook is protected with "Structure" enabled, you can't add, remove, hide, or unhide sheets. The right-click Unhide option is greyed out as a result. Go to Review > Unprotect Workbook, enter the password if there is one, and the menu unlocks.
You're looking at the wrong Excel instance. If you have multiple Excel windows open as separate processes (rare, but possible with older versions or specific compatibility modes), each has its own Unhide list. Close other instances or check the Windows Task Manager for stray excel.exe processes.
Sometimes you're not just unhiding one column — you're inheriting a sprawling workbook from a former colleague, and you want to understand its full structure before touching anything. In that case, treat unhiding as a discovery phase, not a fix.
Start by listing every sheet. In the VBA Immediate window, type For Each s In Sheets: Debug.Print s.Name, s.Visible: Next s and press Enter. You'll get a printout of every sheet name with its current visibility status. Now you know exactly what's hidden, what's very hidden, and what's already visible — no guessing.
Next, scan for hidden columns and rows in the active sheet. A quick visual check: select all (Ctrl + A), then Home > Format > Row Height. If the dialog shows a value, all rows are uniform. If it's blank, heights vary — meaning some rows are likely hidden or have custom sizes. Same idea for Column Width. To force everything visible, select all, then Format > Hide & Unhide > Unhide Rows, then again Unhide Columns.
Once everything is exposed, walk the model from inputs to outputs. Look at Formula Auditing > Trace Dependents on key cells. Now you can see why columns were hidden in the first place — usually intermediate calculations that the author didn't want users editing — and you can decide whether to leave them visible, re-hide them, or delete them entirely if they're truly redundant.
If you're going to maintain this workbook long-term, add a "ReadMe" sheet at the front. Note which sheets were originally hidden and why, which columns/rows are intermediate calculations, and any VBA modules you discovered. Future-you will thank present-you. This is especially valuable for compliance-heavy workplaces where audit trails matter.
Three menus, one keyboard shortcut combo, and one VBA escape hatch — that's everything you need to unhide anything in Excel. Most days you'll only use the right-click route for columns or sheet tabs. But the moment a workbook opens with no visible spreadsheet, or a colleague hands you a file with a missing tab that doesn't appear in the Unhide dialog, you'll know exactly where to go.
The bigger lesson, honestly, is that Excel rewards curiosity about its plumbing. Hiding is everywhere — in column headers, sheet tabs, window frames, and the deep VBA visibility property. Once you've poked into all four scopes, the spreadsheet feels less like a fixed grid and more like a layered document where you control what's visible at every level. That's a small mindset shift, but it pays off every time you crack open a file someone else built.
Keep this guide bookmarked. The next time something disappears, you'll know whether to right-click, hit the View tab, or jump straight to Alt + F11 — and you'll get on with your day instead of wondering where your data went.