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.

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