Remove blank rows and columns in Excel
Delete every completely empty row and column in one step, and keep everything else exactly as it was.
Want it to work exactly your way?
Keep this tool in your Mini-Apps to run it again in one click, or describe the job and AI builds an app of your own.
How to use Remove blank rows and columns
- 1Select your file, or drop it on the page
- 2Run it — nothing to set up
- 3Download no-blanks.xlsx
Your file is opened in an isolated sandbox with no internet access, processed and deleted with it. It is read the way people's spreadsheets really are — headers that are not on row 1, merged cells, totals pasted at the bottom, dates in two formats — and everything that is changed is listed back to you.
Questions
Will it delete a row that is only partly empty?
No. A row is removed only if every cell in it is empty or contains nothing but spaces. A row with a single value is kept.
Does it work on every sheet?
Yes. Each sheet is cleaned separately, and the result lists how many blank rows and columns came out of each one.
Does it move my header row or change values?
No. Nothing is re-ordered, renamed or converted — only fully empty rows and columns disappear.
Is this the same as Go To Special → Blanks in Excel?
Safer. Go To Special selects every blank cell, and deleting those rows also removes rows that were only partly empty. This removes only rows and columns that are completely empty.

