Tip of the week # 452
9 July 2015

Quickly delete empty rows (Microsoft Excel) *

Excel is a popular program that can save you countless hours in calculating and recalculating information. You can also use its powerful filters and PivotTables to quickly retrieve information and manipulate it in numerous ways. Blank rows, however, makes this all difficult and messy. OK, you can obviously delete your empty rows one by one, but there's a quick way to select and delete all of them.

Here's how:

  1. If necessary, select the range containing the empty rows.
  2. Press F5 and click on the Special button.
  3. Click on the Blanks radio button and click OK.
  4. All rows containing a blank cell anywhere in the row are selected, so be careful to check the data!
  5. On the Home tab, in the Cells group, click on the arrow next to the Delete button and select Delete Sheet Rows.

And wouldn't these steps be a great one to record as a macro? See tip_351.php for further details.

* Unless stated otherwise, these tips were written for Microsoft Office 2010.