You convert a PDF into Excel, open the file, and the data is there, but it is broken up by empty rows scattered through the sheet. Sometimes there is one blank row between every page, sometimes a gap wherever a header repeated, sometimes a run of empties where the PDF had spacing. Those blank rows stop you from sorting cleanly, they break a filter, and they make a SUM or a pivot table pick up the wrong range. This is one of the most common cleanup jobs after any PDF to Excel conversion, and it takes about a minute once you know the safe method.
Below is why the blank rows appear in the first place, the fastest way to strip them out without wiping good data by accident, and the single gotcha that trips most people up: a row that looks blank but is not.
How do I remove blank rows in Excel after converting a PDF?
The safest way to remove blank rows in Excel is the filter method. Select your data, press Ctrl+Shift+L to turn on filters, open the drop-down on any column, uncheck Select All, check only Blanks, then select the filtered rows, right-click, and choose Delete Row. Turn the filter off and the empty rows are gone. This deletes only fully empty rows and leaves rows that have data in some columns untouched.
The reason to prefer the filter over the quicker Go To Special method is control. Go To Special selects every blank cell, so it will also flag a row that is only partly empty and delete it with the rest. The filter looks at one column at a time, so you decide exactly what counts as blank.
Why does a PDF to Excel conversion add blank rows?
A PDF to Excel conversion adds blank rows because a PDF is a fixed page layout, not a real spreadsheet. The converter turns visual spacing into structure, so anything that put a gap on the page can become an empty row: the break between pages, a header or footer that repeats on every page, page numbers, and the vertical padding around a table. None of that is data, but it lives on the page, so it lands in the sheet.
Merged cells are the other big source. When a PDF shows a category name once and spans it down over several lines, the converter often writes the name in the first row and leaves the rows beneath it empty, which shows up as blanks in that column even though the row still has numbers in others.
How do I delete blank rows with Go To Special?
Select the data range, press F5 or Ctrl+G, click Special, choose Blanks, and click OK. Excel selects every blank cell in the range. Then on the Home tab click Delete, then Delete Sheet Rows. This is the fastest method for a sheet where the only blanks are in fully empty rows.
Watch the trap: Go To Special selects any cell that is empty, so if one real row happens to have an empty cell in one column, that whole row gets selected and deleted along with the truly empty ones. On converted data, where a column sometimes has a genuine gap, this quietly removes rows you wanted to keep. If your data has any partial blanks, use the filter method instead.
How do I remove blank rows without deleting good data?
Add a helper column and count the real values in each row. In a spare column next to your data, enter =COUNTA(A2:E2) across the row, fill it down, then filter that column for 0. A zero means every cell in the row is empty, so those are the only rows you delete. Everything with at least one value survives.
This is the most reliable method when a sheet mixes fully empty rows with rows that are only missing one field, which is exactly what converted financial data tends to look like. Delete the helper column when you are done.
Why won't my blank rows delete? They look empty but aren't
If a row looks empty but the filter will not treat it as Blanks, the cells almost certainly contain something invisible: a space, a non-breaking space, or a line-break character carried over from the PDF. Excel sees a character, so it does not count the cell as blank. This is the number one reason a cleanup seems to do nothing.
Fix it by wrapping the column in =TRIM(CLEAN(A2)) to strip spaces and control characters, then paste the result back as values. After that the rows read as truly empty and the filter or Go To Special will catch them. You can also filter the column and look for entries that show as a lone space and clear those cells directly.
How do I remove blank rows when I import a PDF with Power Query?
If you pulled the PDF in through Data, Get Data, From PDF on Excel for Windows, clean it inside the Power Query editor before loading. On the Home tab click Remove Rows, then Remove Blank Rows, and the empty rows drop out of the preview. Click Close and Load and the table lands in the sheet already clean.
Power Query has a catch too: Remove Blank Rows only removes rows that are entirely null, so rows padded with spaces slip through. Use the filter arrow on a column, uncheck (null) and any lone-space entries, and the padding rows go with it. Because the query is repeatable, the same cleanup runs automatically the next time you refresh with a new statement.
How do I stop blank rows appearing in the first place?
You cannot fully stop them with a basic converter, because it is reacting to the page layout, but a table-aware converter that reads the actual table structure produces far fewer of them. Instead of turning every visual gap into a row, it maps the real rows and columns, so page breaks and repeated headers do not become empty rows in your output.
Upload your PDF with the converter at the top of this page to get a cleaner sheet to start from. You will still want to glance down the columns and run one filter pass, but there is a lot less to remove, and the fewer blank rows you begin with, the smaller the chance of deleting a real one by mistake.
A quick checklist before you delete
Run through this before you strip rows out of a converted sheet, so you clean it once and keep every real record:
- Scroll the whole sheet first so you know whether blanks are full rows or partial gaps.
- For fully empty rows only, use Go To Special, Blanks, then Delete Sheet Rows.
- For a sheet that mixes empty and partly filled rows, use the filter method or a COUNTA helper column.
- If rows will not register as blank, wrap the column in =TRIM(CLEAN()) to remove hidden spaces and line breaks, then delete.
- Check that any numbers came in as real numbers, not text, so your totals recalculate after the cleanup.
- Compare the final row count against the PDF so you know nothing real was deleted with the blanks.
Blank rows are the most visible part of cleaning up a conversion, but they are rarely the only one. If your figures also refuse to add up, the values probably came in as text, and the fix is in how to fix numbers stored as text. If the columns themselves shifted during the conversion, start with how to convert a PDF to Excel accurately. For scanned statements and receipts, the extra step is OCR, covered on the OCR PDF to Excel page.
These blank-row gaps are especially common when the source is a multi-page statement, because every page break can become an empty row. If you are converting bank statements regularly, a purpose-built tool like bankxlsx.com handles the page breaks and repeated headers for you, and scanned invoices land cleaner through invoicesocr.com.