How To Delete Excess Columns In Excel

Deleting excess columns in Excel means removing columns that are not needed or are unused in a spreadsheet. Excel spreadsheets usually have a large number of columns, and it’s common for some of them to be empty or contain data that is no longer needed. Deleting these excess columns helps to clean up the spreadsheet and make it more efficient to work with. Deleting excess columns in Excel does not remove any data in the rows of the deleted columns.

In this tutorial, we will learn how to delete excess columns in excel. In our dataset names of students along with their IDs and marks above are shown but there are extra columns that are empty between them and are excess columns. To delete them we will first select these columns using the Find and Select option and then delete these columns using the Delete Column option. Also, excess columns exist at the end of our data to delete them we used the Delete option. Following steps guide you to use these methods.

Method 1: Deleting Excess Columns in Between the Data

Step 1 – Select the Data

Select the Data that contain excess columns

Step 2 – Click on the Find and Select option

Click on the Find and Select option in the Home tab and a dropdown menu will appear

Step 3 – Click on the Go To Special option

From the dropdown menu click on the Go To Special option and a dialog box will appear

Step 4 – Click on Blanks

In the dialogue box click on the Blanks option
Click on OK at the end of the dialogue box and all excess columns will be shown as selected

Step 5 – Click on Delete

Right-click on any selected cell and a context menu will appear
From this menu click on delete and a dropdown will appear

Step 6 – Click on the Entire Column option

From the dropdown menu click on the Entire Column option
After clicking on the Entire column option Click on OK at end of the dropdown menu to get the required result