Select the data column, press F5, choose Special, then Blanks, and finish with Home, Delete, Delete Sheet Rows. That clears fully empty rows in seconds, but it deletes any row where the selected column is blank, so use it only when you are sure a blank in that column means the whole row is empty.
How does Go To Special remove blank rows?
- Save a copy of the workbook.
- Select one column that is always filled when a row is real, for example the amount column, from the first data row to the last. Do not select the full sheet.
- Press F5 (or Ctrl+G), click Special, choose Blanks and press OK. Only the empty cells in your selection stay highlighted.
- On the Home tab choose Delete, then Delete Sheet Rows. Each row containing a highlighted cell is deleted.
The option is Delete Sheet Rows, not Delete Cells, which would shift data up unevenly and misalign columns. If you accidentally pick it, press Ctrl+Z straight away.
Why can this delete rows you wanted to keep?
Because it works on cells, not on rows. If you select columns A to F and delete every row with a blank cell in the selection, a transaction with an empty reference-number cell goes with the truly empty rows. Statements often have partly empty rows, such as a debit with no credit or a line with no cheque number. Those are real transactions.
One more precaution: if your data is formatted as an Excel Table, Delete Sheet Rows still works, but check that the table range shrinks as expected afterwards, and that no stray blank row remains at the very bottom, which can stop a later paste from landing where you expect.
What about rows that are only partly empty?
Use a helper column instead. In G2, next to the data in A to F, enter:
=SUMPRODUCT(--(LEN(TRIM(A2:F2))>0))=0
It returns TRUE when every cell in the row is empty or holds only spaces, and FALSE when any cell has content. Fill it down, filter column G for TRUE, select the visible rows, right-click the row numbers and choose Delete Row. Excel deletes only visible rows in a filtered range. Clear the filter and the real rows remain. This route also catches cells that look blank but hold a space, which Go To Special does not treat as blank.
Why do some blanks not get selected?
Go To Special, Blanks only finds truly empty cells. A formula returning "" or a cell holding a space is not empty, so those rows survive. The helper column above handles both.
Can sorting remove blank rows instead?
Sorting pushes empty rows to the bottom, where you can delete them in one block, but it also scrambles the order of your transactions. If the order matters, as it does when you check balances, add a number column first. Type 1 and 2 in the first two cells, select them, drag the fill handle down, and after deleting the blanks sort by that column to restore the original order. For a statement, that is worth the extra minute.
Quick worked check
Say the sheet has 312 rows, of which 12 are completely blank. After a helper-column delete you should have 300. If you have 295, five real rows went, so undo and look again. With invented numbers like these the arithmetic is easy; with your real file, note the count before and after, every time.
- Count rows before: select a column and read the Count in the status bar.
- Delete by the method above.
- Count again and compare with your expected number.
- Scan for a stray blank at the very top, which would break table detection.
If you find yourself repeating this every month, SpendixAI is one place that reads statement uploads and flags the rows for review, though a sheet with clean steps is perfectly fine for a single account.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


