You can remove blank rows in Excel by first doing a “Find & Select” of blank rows in the document.
You can then delete them all at once using the “Delete” button on the Home tab.
Once rows or cells are deleted in Excel, the data below them will move upwards.
Though having blank rows in an Excel worksheet isn’t necessarily a bad thing, sometimes they’re unnecessary, as they can make a document take up much more space than intended.
Finding and removing blank spaces and rows in Excel is easy and can be done by using the “Find & Select” feature.
Here’s how to delete blank rows in Excel on a Mac or PC.
How to remove blank rows in Excel
1. Click the Home tab in the top menu bar of Excel.
Quick tip: You can quickly get to the Home tab by pressing Alt + H on a PC.
2. Click Find & Select on the right side.
3. Select Go to Special to open the associated dialog box.
Click “Go to Special” in the menu.
Stefan Ionescu/Insider
Quick tip: You can get to the Go to Special dialog box by pressing F5 on your keyboard to open the Go To dialog box, and then clicking the Special button in the bottom left corner.
4. A pop-up box will appear. Select Blanks, and then hit OK.
Tick the radial button next to “Blanks,” and then click “OK.”
Stefan Ionescu/Insider
5. Excel will then highlight all of the blank cells. Before you delete the blank cells, ensure that only the cells that you want to remove are highlighted. If you just want to remove rows and not individual blank cells, you can always select a cell with Control + click on a PC, or Command + click on a Mac, to deselect it.
Note: When you delete cells in Excel, the data below it will be moved up.
6. Once all the blank rows are highlighted, go to the Home tab and locate the Delete button on the right-hand side.
Click the “Delete” button in the Home tab.
Stefan Ionescu/Insider
7. Click the down arrow next to the Delete button and select Delete Sheet Rows to remove the blank rows.
Click “Delete Sheet Rows.”
Stefan Ionescu/Insider