Excel 2016 – How to delete all empty columns

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

Note: this process does not account for partially empty columns. For example if a row in column 2 was empty that column 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. 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-RemoveEmptyColumns2
  8. In the ‘Home’ ribbon, click on the arrow below the ‘Delete’ button then click on ‘Delete Sheet Columns’
  9. Excel2016-RemoveEmptyColumns3
  10. Your empty columns have now been removed.