Home › Guides › How to Unhide Rows, Columns & Sheets in Excel

How to Unhide Rows, Columns & Sheets in Excel

Published October 18, 2026 · By Ahmad Parvez

Whether you searched "unhide all", "unhide everything", or just "unhide in Excel", it comes down to the same idea: hidden things in Excel are never gone — they're just collapsed out of view. This guide covers unhiding (and hiding) rows, columns, sheets, and even whole workbooks, in both desktop Excel and Excel for the web, including the traps that catch everyone: hidden column A, hidden row 1, filters that pretend to be hidden rows, and the shortcut that silently doesn't work on some computers.

How to unhide rows in Excel

First, spot where rows are hidden: the row numbers will skip (for example, 3 then 6), with a slightly thicker border where the hidden rows sit. Then:

1. Click the row number above the hidden rows, hold, and drag down across the row number below them — so you have selected the visible rows on both sides of the gap.
2. Right-click any of the selected row numbers and choose Unhide.

The same steps unhide multiple rows at once — any hidden rows inside your selection all reappear together. Two alternatives: the ribbon path Home → Format → Hide & Unhide → Unhide Rows, or type the hidden row range (for example 5:5) into the Name Box left of the formula bar, press Enter, then right-click and choose Unhide. From the keyboard: select the surrounding rows and press Ctrl+Shift+9.

How to unhide all rows in Excel

When rows are hidden in several places — or you can't tell where — don't hunt for gaps. Select everything and unhide in one move:

1. Click the Select All triangle — the small triangle in the top-left corner, above row 1 and left of column A — or press Ctrl+A.
2. Right-click any row number (not a cell — right-clicking inside the grid won't show the Unhide option) and choose Unhide.

This reveals every hidden row in the sheet at once, no matter where the gaps were — a true mass unhide of all rows. The same "select all, then Unhide" move works for showing all hidden rows after a big cleanup, and it's the fastest answer when someone asks how to unhide all rows in Excel at once.

How to unhide columns in Excel

Columns work exactly like rows, sideways. To find hidden columns, spot the gap: the column letters will skip (B, C, then E), with a thicker border marking the hidden column. Then:

1. Click the column letter to the left of the hidden column, hold, and drag across the column letter to its right.
2. Right-click either selected column letter and choose Unhide.

This covers a single hidden column, multiple adjacent hidden columns, and non-adjacent hidden columns alike — just make your selection span every gap you want to restore. Alternatives: Home → Format → Hide & Unhide → Unhide Columns, or the Name Box (type the hidden column's range, like D:D, press Enter, then Unhide). From the keyboard: select the surrounding columns and press Ctrl+Shift+0 (zero).

How to unhide all columns in Excel

Same idea as unhiding all rows, rotated 90 degrees:

1. Click the Select All triangle in the top-left corner, or press Ctrl+A.
2. Right-click any column letter and choose Unhide.

Every hidden column in the sheet reappears at once. If you want to unhide everything in Excel in the fullest sense — all rows and all columns — select all, then run Unhide once from a row number and once from a column letter (see the combo section below).

How to unhide column A in Excel (the special case)

Here's the trap: the standard trick requires selecting the columns on both sides of the hidden one — but there is no column to the left of column A. The drag-across method physically cannot work, which is why "how to unhide column A in Excel" is its own heavily searched question. Use one of these instead:

1. The Name Box method (desktop): click the Name Box — the small field left of the formula bar — type A1, and press Enter. Excel selects the hidden cell. Then go to Home → Format → Hide & Unhide → Unhide Columns. (The Go To dialog, Ctrl+G, then typing A1, does the same thing.)
2. The select-all method (works everywhere): click the Select All triangle or press Ctrl+A, right-click any column letter, and choose Unhide. Column A comes back along with any other hidden columns.
3. In Excel for the web: right-click the column B header and choose Unhide Columns — Microsoft's own documented fix for the web, since the web version has no Name Box.

The same logic applies to unhiding columns A and B together, or unhiding the first column in general: Name Box (desktop) or select-all (everywhere). And one more gotcha — if a column still won't appear after unhiding, its width may have been set to zero rather than hidden. Select it and go to Home → Format → Column Width and type 8.43 (the default).

How to unhide sheets in Excel

People often say "tabs" when they mean sheets — hiding tabs, unhiding tabs, showing hidden tabs: it's all the same sheet-tab bar at the bottom of the Excel window. If a tab is missing from that bar, its sheet is hidden. (Wondering how to find hidden sheets or tabs? The missing tab is the sign — there's no separate "hidden sheets" list to hunt through; the Unhide dialog below shows them all.) To bring hidden sheets or worksheets back:

1. Right-click any visible sheet tab at the bottom of the window.
2. Choose Unhide…
3. Pick the sheet from the list and click OK.

If Unhide… is grayed out, there are no hidden sheets in the workbook. The same right-click menu works in Excel for the web. To hide a sheet (or worksheet) in the first place: right-click its tab and choose Hide. And if you want the entire tab bar gone rather than individual sheets, that's File → Options → Advanced → Display options for this workbook → uncheck "Show sheet tabs" — note this hides all tabs; you can't hide just one tab.

How to hide rows in Excel

Hiding is the mirror image of unhiding:

1. Select the row numbers you want to hide — drag across several, or Ctrl+click for non-adjacent rows.
2. Right-click any selected row number and choose Hide.

From the keyboard: Ctrl+9. From the ribbon: Home → Format → Hide & Unhide → Hide Rows. The data is still there — hidden rows keep their values and still count in most formulas (more on that below). If you actually want the rows gone rather than hidden, unhide them first, then select the rows, right-click, and choose Delete — deleting a hidden row directly is unreliable, so revealing it first is the safe move.

How to hide columns in Excel

1. Select the column letters you want to hide — drag across several, or Ctrl+click for non-adjacent columns.
2. Right-click any selected column letter and choose Hide.

The shortcut for hiding columns in Excel is Ctrl+0 (zero); the ribbon path is Home → Format → Hide & Unhide → Hide Columns. Remember that hiding and unhiding columns in Excel is one pair — everything in the unhide sections above reverses what this section does.

Hide and unhide keyboard shortcuts

Two caveats: on Windows, Ctrl+Shift+0 can be intercepted by the system's keyboard-layout switcher and do nothing in Excel — right-click → Unhide is the reliable fallback. In Excel for the web, any shortcut the browser claims can be handed back to Excel via Help → Keyboard Shortcuts → Override browser shortcuts. (Mac shortcuts vary by Excel version; if in doubt, use the ribbon.)

How to unhide all rows and columns in Excel at once

The one-sitting reset for a messy sheet:

1. Press Ctrl+A (press it twice if your cursor is inside a formatted table, since the first press selects just the table).
2. Right-click any row number → Unhide.
3. Right-click any column letter → Unhide.

Two clicks and the sheet is fully expanded — every hidden row and column, revealed.

How to hide gridlines in Excel

Gridlines are the faint lines between cells. To hide them, go to the View tab and uncheck Gridlines. That's it — the same toggle lives under Page Layout → Sheet Options → Gridlines → View.

This is view-only: hiding gridlines deletes nothing and changes no values. If you also want them gone from the printed page, that's a separate checkbox — Page Layout → Sheet Options → Gridlines → Print — uncheck it to print without gridlines. To get the lines back, just re-check the View box.

Hidden rows and your formulas: what SUM really counts

This surprises people: SUM, AVERAGE, and COUNT include hidden rows in their totals — both manually hidden rows and rows hidden by a filter. Hiding is a display change, not a data change, so your totals don't move when you hide rows.

If you want a total that excludes hidden rows, use SUBTOTAL instead: function numbers 101–111 (for example =SUBTOTAL(109, A2:A100) for a sum) skip manually hidden rows as well as filtered-out rows, while 1–11 skip only filtered-out rows. AGGREGATE offers similar options. If you're building one of these and want it generated correctly, our Excel Formula Builder writes the exact SUBTOTAL formula for your ranges.

"I clicked Unhide and nothing appeared" — the usual culprits

If the Unhide command runs but your data still won't show, the problem usually isn't hiding at all. Work through these:

1. It's a filter, not hidden rows

Filters hide rows too — and Unhide does not restore filtered-out rows. Look for funnel icons on your header row: if any are active, go to the Data tab and click Clear (in the Sort & Filter group), or click each funnel and choose "Select All". Your rows will come back immediately.

2. The sheet is protected

On a protected sheet, the Hide & Unhide commands are grayed out or silently refuse. Go to the Review tab and click Unprotect Sheet (you may need the password from whoever protected it). For more on locking things down properly, see our guide to locking and protecting Excel sheets.

3. Freeze Panes is confusing the view

If row 1 is hidden and panes are frozen, the top of the sheet can look wrong even after unhiding. Go to View → Freeze Panes → Unfreeze Panes, fix the hidden rows, then re-freeze if you need to.

4. The column width is zero (not hidden)

A column with its width set to 0 looks hidden but isn't — Unhide won't fix it. Select the column and go to Home → Format → Column Width and type 8.43.

5. It's an outline group, not a hide

The + and − buttons in the margin come from Data → Group, not from hiding. Click + to expand a collapsed group; Unhide has no effect on groups. (See the FAQ below for the full story.)

6. A chart disappeared

A chart can vanish because the rows or columns underneath it are hidden — unhide those first. Or the workbook may be set to hide all objects: File → Options → Advanced → Display options for this worksheet → "For objects, show" must be set to All (if it's "Nothing (hide objects)", no chart will display). To simply remove a chart title, click it and press Delete — our charts and graphs guide covers rebuilding chart elements.

7. Text is cut off inside a visible cell

If the cell itself is visible but its text won't all show, nothing is hidden — the row is just too short or the column too narrow. Select the cell and click Wrap Text on the Home tab, or double-click the boundary below the row number to AutoFit the row height.

Frequently asked questions

Keep learning

More Excel guides from ToolVaultly: