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.

Tagged in

2 comments on “Excel 2016 – How to delete empty rows

  1. I wish this worked for me. I follow the steps, even Clear All for the blank rows, and delete the rows. Then the deleted rows are replaced with a duplicate of the problem rows. It never ends.

  2. In my excel 2016 there’s absoultelly no way to remove rows or columns. Nor with right click not with the menu, meaning the options is there but the result is not!

Leave a Comment

Your email address will not be published. Required fields are marked *