Excel 2016 – How to delete empty rows

The following steps show how to remove empty rows from an Excel spreadsheet using Excel 2016.

Note: this process does not account for partially empty rows. For example if a row in column 2 was empty that row would also be deleted.

Excel2016-RemoveEmptyRows1

  1. With your spreadsheet open, press F5 on the keyboard. The ‘Go To’ window will open.
  2. Click on the ‘Special’ button
  3. Excel2016-RemoveEmptyRows2
  4. Click on ‘Blanks’ then click ‘OK’
  5. Excel2016-RemoveEmptyRows3
  6. This will select all the empty fields within your table.
  7. Excel2016-RemoveEmptyRows4
  8. In the ‘Home’ ribbon, click on the arrow below the ‘Delete’ button then click on ‘Delete Sheet Rows’
  9. Excel2016-RemoveEmptyRows5
  10. Your empty rows have now been removed.