Deleting blank columns in Excel using manual selection and deletion

We can delete blank columns in Excel using manual selection and deletion. This method works with all types of data but it is time taking, here I would suggest to use this method only when your data is less. If you have a large number of columns to delete then move on to the second method. Now we understand this method with the help of an example. So consider the example

Step 1: Select the blank columns, to select the blank columns press Shift and press the down arrow to the row upto you want to select the column. 

Step 2: Then right-click on the selected column. A drop-down will appear (as shown below). Select the Delete button. The selected column will be deleted.

Repeat the same steps for all the blank columns left in the required worksheet and delete them.

Deleting blank columns and rows is a tedious task when you are working with a large set of data. Manual deletion is not even an option. In this article, you’ll learn to delete the blank columns in Excel in some simple steps using Excel’s built-in tool named Go To Special.

It is a quick and easy way to remove the blank columns. While this makes it a simple alternative to implement, be aware that it may cause your document to become misaligned. Always save a backup copy of your document before you start deleting cells to be safe.