Find and Delete All Blank Rows in an Excel Sheet

Tags

blanks, excel, remove blanks

Quick tip that I use fairly often when weeding out certain rows in reports:

1. Select the column containing blanks.
2. Press F5 (“Go to”) on your keyboard.
3. Click Special.
4. Check Blanks.
5. Click OK.
6. Right click a blank cell in the appropriate column.
7. Click Delete>Entire row.
8. Click OK.

Advertisement