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 file

Opened on your device - never uploaded · up to 50MB

Choose file

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

Related Tools