Unhide Excel Rows, Columns & Sheets in 1 Click — Free, No Upload, Data Safe
Reveal hidden rows, columns, and sheets in any workbook — even veryHidden ones the right-click menu cannot reach. No upload, no signup, no server.
Drop .xlsx or .xlsm files here, or click to browse
Supports .xlsx and .xlsm · processed locally · never uploaded
How to Unhide Rows, Columns, and Sheets Online
- Drop one or more .xlsx or .xlsm workbooks — everything is processed locally and never uploaded.
- Click Unhide data — hidden rows, columns, and sheets are revealed automatically.
- Check the report — each file lists the counts of unhidden rows and columns, plus any sheets made visible.
- Download the result — a single file downloads directly; multiple files come back as a ZIP.
How It Works
An .xlsx or .xlsm workbook is a ZIP archive of XML parts. This tool opens that archive in your browser, walks every xl/worksheets/sheetN.xml part, and strips the hidden="1" attribute off each <row> and <col> element; in xl/workbook.xml it also clears the state="hidden" and state="veryHidden" flags from <sheet> entries — which is exactly how veryHidden sheets reappear in the tab bar. Row heights (ht), column widths (width), styles, and every cell value are left byte-for-byte untouched. The edited parts are then zipped back into a fresh .xlsx blob and downloaded — the entire pass runs locally, no byte ever leaves your device.
Your file never leaves your device — processing is 100% in-browser.
Compared to Excel’s Hide/Unhide Commands
Excel’s built-in route is selecting rows, columns, or sheet tabs one by one and right-clicking Unhide — manageable for a couple of items, painful across an entire workbook. This tool scans the whole workbook in one pass and clears every hidden flag it finds.
| Approach | Where your file goes | What to expect |
|---|---|---|
| This tool | Nowhere — processed in your browser | Free, no sign-up, unhide all at once, batch-friendly |
| Excel Hide/Unhide commands | Stays on your disk | Manual, one row/column/sheet at a time |
What Gets Unhidden
Hiding is just a flag stored in the file’s XML, and there are three places the flag lives. This tool clears all of them in one pass.
| What is hidden | Where the flag lives | Unhidden here |
|---|---|---|
| Rows (e.g. salaries in a budget) | hidden="1" on <row> in the sheet XML | Yes |
| Columns (e.g. an internal cost column) | hidden="1" on <col> in the sheet XML | Yes |
| Sheets missing from the tab bar | state="hidden" on <sheet> in workbook.xml | Yes |
| Sheets invisible even to right-click Unhide | state="veryHidden" in workbook.xml | Yes |
| Rows hidden by an active filter | Not stored as hidden flags | Clear the filter in Excel instead |
How Unhiding Works Inside the File
An .xlsx workbook is a ZIP archive of XML parts. A hidden row is simply a <row> element carrying hidden="1", a hidden column is a <col> with the same flag, and a hidden sheet is a <sheet> entry marked state="hidden" or state="veryHidden" in workbook.xml. veryHidden is nothing special — it is the same flag with a stricter name, which is exactly why Excel’s own interface refuses to show it.
This tool removes those attributes and nothing else. Row heights (ht), column widths (width), styles, and every cell value survive byte-for-byte — unhiding changes visibility, never data.
Your file never leaves your device. The archive is unpacked, edited, and repacked entirely in browser memory — there is no upload step at all.
Why Data Gets Hidden — and Why You Should Check
- Files you receive may hide helper columns, source data, or an entire sheet someone thought you should not see.
- Templates often ship with hidden example rows that silently affect formulas you are building on.
- Auditors and reviewers: unhiding reveals the complete picture before you sign off on the numbers.
- Remember the reverse: unhiding is also how you double-check that a file you are about to send holds no surprises.
Limitations
- .xlsx and .xlsm only — legacy .xls (Excel 97–2003) is a binary format; convert it to .xlsx first with our batch converter.
- File-open encryption cannot be processed — if Excel asks for a password before opening, no honest tool can read the file.
- Rows hidden by an active AutoFilter are not flagged as hidden in the file — remove the filter in Excel instead.
- Unhiding makes data visible; it does not recover anything that was actually deleted.
Frequently Asked Questions
Is this Excel unhide tool really free?
Yes — 100% free, with no sign-up, no watermark, and no file limit. All processing happens in your browser.
Can it unhide sheets that Excel’s Unhide menu refuses to show?
Yes. The veryHidden state is just a stricter flag in workbook.xml; this tool clears it exactly like a normal hidden sheet.
Will unhiding change my row heights or column widths?
No. Only the hidden flag is removed. Custom heights, widths, styles, and cell contents are preserved exactly.
Does it also unhide rows filtered out by AutoFilter?
No — filtered rows are not stored as hidden flags in the file. Clear the filter in Excel and those rows reappear.
Are my files uploaded to a server?
No. The archive is opened, edited, and repacked entirely in your browser with JavaScript. Nothing is transmitted anywhere.
Does it work with .xlsm files?
Yes. The revealed copy is returned as .xlsm with your VBA macros preserved and intact.
Can I process several workbooks at once?
Yes. Drop multiple files; each is processed in one pass and the results download together as a ZIP.
What if the file has nothing hidden?
You will see a “nothing found” note instead of a download prompt, and the original data is left completely untouched.
Related Tools
Need to view or edit the fully revealed spreadsheet afterwards?
Open the free online Excel editor