How To Delete (Remove) Blank Or Empty Columns In Excel Explained

Описание: In this video we discuss how to delete blank columns, or columns that don't have any data in them in an excel worksheet. We go through the process step by step

Transcript/notes
Let’s say that you have some blank columns, such as in this example worksheet, that you want to delete to clean things up a bit. To do this, make sure you are on the home tab at the top of the worksheet. From here, left click on the number of any row that has data in it, so it is highlighted. Next, in the editing section near the top of the worksheet, left click on the find and select icon. Next, in the drop down box, left click on go to special and a pop up box will appear.

In the box, left click on blanks, and then left click on ok. As you see, the cells of the blank columns in this row are highlighted, from here, in the cells section near the top of the worksheet, left click on the down arrow under the delete icon. In the drop down box, we want to left click on delete sheet columns.

And now, all of the blank columns have been deleted.