Unhide Sheets in Excel
Unhide every hidden and very hidden sheet in a workbook at once, and the hidden rows and columns inside them. Runs in your browser - nothing is uploaded.
Drop your file here or choose a fileTap to choose a file
Opened on your device - never uploaded · up to 50MB
Supports .xlsx, .xls, .xlsm, .xlsb · or paste a file from your clipboard
No file handy? · download it
Hidden, Very Hidden, and Hidden Rows
Excel hides things at two levels. A whole worksheet can be hidden - its tab disappears - or very hidden, which keeps it out of the Unhide list too. Inside a sheet, rows and columns can be hidden one by one. A workbook handed on by someone else can carry all three, and the only sign is a gap in the tab strip, a row number that skips, or a column letter that jumps.
What This Tool Does
It lists every hidden and very hidden sheet by name, makes them visible, and clears the hidden flag from every row and column, each switchable on its own. Nothing else in the file is touched: filters, grouping and protection stay as they were. Rows a filter had hidden are shown too; apply the filter again in Excel to hide them.
To look at hidden rows and columns without changing the file, open it in the Excel Viewer, which marks them instead of dropping them. To delete hidden sheets rather than show them, use the Excel Cleaner.
Frequently Asked Questions
Right-click any sheet tab and choose Unhide, then pick the sheet. Recent Microsoft 365 versions let you select several sheets in that list at once; older versions unhide one sheet at a time.
A sheet whose visibility is set to xlSheetVeryHidden, usually by a macro or an add-in. It does not appear in Excel's Unhide list at all; in Excel it can only be shown again from the VBA editor, by changing the sheet's Visible property. This tool shows very hidden sheets the same way as hidden ones and names them in the result.
Either nothing is hidden, or the workbook structure is protected, which stops sheets being hidden, unhidden, added or renamed. This tool changes the file directly, so its sheets come out visible either way; to remove the protection itself, use Unprotect Sheet.
For an .xlsx or .xlsm file, yes: only the hidden flags change in your own file, so formulas, charts, pivot tables, conditional formatting, macros and everything else come through unchanged. An .xls or .xlsb file is saved as a new .xlsx built from the cells, formatting and layout, and the result says so.
No. The workbook is read and rewritten in your browser.