How to Remove Empty Rows in Excel

What this does

Go To Special finds and selects every blank cell in one pass, so you can delete their whole rows in a single action instead of scrolling and deleting by hand. You highlight the data, open Go To Special (F5 then Special, or Home ▸ Find & Select ▸ Go To Special), choose Blanks, and Excel selects only the empties — then Delete Sheet Rows clears the entire rows they sit on. For larger or partially filled sheets, a Filter on "Blanks" is the safer alternative. The same idea underpins a lot of everyday Excel work, so the few minutes spent getting it right here pay back across every sheet you build afterwards. Treat it as a pattern, not a one-off, and it stops being something you look up and starts being something you reach for. For “remove empty rows in excel”, the reliable version is a short checking loop, not just the first command that appears to work. Run it on a deliberately small range first, watch how the affected blanks change, and only then apply the same setup to the full sheet. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. That is what makes a data step that keeps your analysis trustworthy useful in real work: repeatable, auditable, and not dependent on memory or luck.

A worked example

A 200-row list has empty rows scattered between entries. Select A1:D200, press F5, click Special, choose Blanks, and OK — every blank cell is now selected. On the Home tab choose Delete ▸ Delete Sheet Rows, and all the empty rows vanish at once, leaving the remaining ~170 rows packed together with no gaps. Blank rows break sorting, filtering and any range a chart or pivot reads — a single gap can stop a SUM or split a table in two. Clearing them in one pass with Go To Special is a core clean-up before any analysis. If this is something you do often, add the command to the Quick Access Toolbar (right-click it on the ribbon and choose Add to Quick Access Toolbar) or learn its shortcut, so next time it is one click instead of a hunt through the menus.

In Google Sheets

This is a command rather than a formula, so there is no syntax to carry over. Google Sheets arranges its commands in menus across the top instead of a ribbon, names some of them differently and does not have every Excel command — look for the equivalent in the Sheets menus or its help before assuming the steps match. Nothing on this page is behind a login or a download: the exact answer is at the top, and the detail below it is there for when you need it. That is the whole promise here — the answer first, and just enough context to make it stick. The short version of “remove empty rows in excel”: the answer is at the top of this page, and the sections above explain why each step matters, so a variation of the problem does not stump you. Try it once on a copy of a real file and the steps stick far better than re-reading them.

Common mistakes

• Selecting a column that has some genuinely empty cells on otherwise-full rows — Delete Sheet Rows would then drop real data.
• Using Go To Special on a huge selection where most cells are blank, which can grab far more than the empty rows you meant.
• Pressing Delete (clear contents) instead of Delete Sheet Rows, which empties cells but leaves the rows in place.
• Forgetting to select the entire row range first, so only part of each blank row is removed.

Frequently asked questions