Guides › Find hidden sheets and data in Excel

How to find hidden sheets, rows and data in an Excel file

Updated 20 October 2026

Not sure what's hiding in your document? Check it free. It runs in your browser, so the file never leaves your computer.

An Excel file can look tidy on screen and still carry a lot you can't see: sheets someone hid, rows of workings, cells formatted to show nothing, and full copies of source data kept inside pivot tables. If you send the workbook, all of it goes too.

Hidden sheets

Right-click any sheet tab at the bottom and choose Unhide. If it's greyed out, there are no ordinary hidden sheets.
Select each sheet in the list to show it.

“Very hidden” sheets don't appear in that list at all. To find them on Windows, press Alt+F11 to open the Visual Basic editor, look at the list of sheets on the left, select one and check its Visible setting in the Properties panel (F4). 2 - xlSheetVeryHidden means it's very hidden; change it to -1 - xlSheetVisible. On a Mac, open the editor from Tools › Macro › Visual Basic Editor.

Hidden rows and columns

On each sheet, click the triangle at the top-left corner to select everything.
Right-click a row number and choose Unhide, then right-click a column letter and choose Unhide.
Look for rows that are squashed very short, too. They're not hidden, but you won't see them.

Cells that show nothing

The ;;; format: a cell with the custom number format ;;; holds a value but displays nothing. Click a blank-looking cell and check the formula bar.
White text: select everything and set the font colour to black for a moment to reveal it.
Formulas: press Ctrl+` to show formulas instead of results. They can reveal how figures were worked out and point to other sheets or files.

Pivot tables, comments and links

Pivot table caches keep a full copy of the source data inside the file, even if you delete the source sheet. In PivotTable Options › Data, untick Save source data with file, or paste the pivot as values before sending.
Comments and notes: open the Review tab and use Show Comments and Notes › Show All Notes.
Links to other workbooks: Data › Edit Links lists them. They can reveal file names and folders on your network.

Remove it in one go (Windows)

File › Info › Check for Issues › Inspect Document finds and removes comments, document properties, hidden rows, columns and sheets, and more. Inspect a copy, because removing hidden sheets can break formulas that depend on them.

Or check it in seconds

Drop the file into the free Clean Retype check and it lists what's hiding inside: author names, comments, hidden sheets and rows, speaker notes, earlier versions, and text still sitting under black boxes.

Check a file free No sign-up

It runs in your browser, so the file never leaves your computer. Works with Word, Excel, PowerPoint and PDF files.