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.

Excel2016-RemoveEmptyColumns1

  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.
Tags:

Was this article helpful?

Related Articles