[Solved!] Can’t Delete Extra Columns in Excel (3 Solutions)

Get FREE Advanced Excel Exercises with Solutions!

Tired of trying to delete unnecessary columns in your dataset, but you couldn’t? Well, maybe your workbook has some common issues for which deletion is not working. But don’t worry, we are here to save you! This article will show some common reasons and will give three smart solutions to fix the problem when you can’t delete extra columns in Excel.


Download Practice Workbook

You can download the free Excel template from here and practice on your own.


3 Reasons and Solutions: Can’t Delete Extra Columns in Excel

To show the reasons and solutions, we’ll use the following dataset that represents some salespersons’ sales in different regions.


1. Make the Extra Columns Disappeared If You Can’t Delete Extra Columns in Excel

You cannot delete permanently the empty columns after the last columns in your dataset. Excel only removes contents from rows and columns. It never deletes them permanently.

Have a look that I have deleted Column E and go forward to the next image to see what happens.

Make the Extra Columns Disappeared If You Can't Delete Extra Columns in Excel

The column still exists.

Solution:

So, what you can do is hide all the extra columns from your sheet and it will look like the columns are deleted. At least they will not be visible anymore!

Make the Extra Columns Disappeared If You Can't Delete Extra Columns in Excel

Now let’s see how to do it.

Steps:

  • Select the first extra empty column by clicking the column number.

Make the Extra Columns Disappeared If You Can't Delete Extra Columns in Excel

  • Then press Ctrl+Shift+Right Arrow key to select till the last column- 16,384th column of Excel.
  • After that, right-click on any column.
  • Select Hide from the Context menu.

Soon after, you will get all the extra columns hidden and look like deleted.

Read More: How to Delete Extra Columns in Excel (7 Methods)


2. Identify Space Characters and Delete Extra Columns in Excel

If your dataset has space characters in cells in one of its columns, it will look like a blank column.

In this dataset, we have an empty column.

Identify Space Characters and Delete Extra Columns in Excel

First, let’s check if it is really empty or not.

  • Select the Column D.
  • Then click as follows: Home > Editing > Find & Select > Go To Special.

Identify Space Characters and Delete Extra Columns in Excel

  • Mark Blanks from the Go To Special dialog box.
  • Then press OK.

Identify Space Characters and Delete Extra Columns in Excel

Have a look that one cell is showing as non-blank that seems blank. So what is the reason?

Identify Space Characters and Delete Extra Columns in Excel

The reason is there is space character(s) in this cell.

Identify Space Characters and Delete Extra Columns in Excel

So if you use a tool to select all the extra empty columns in your dataset then that row won’t be selected. So what’s the solution?

Solution:

To solve this, follow the steps below.

Steps:

  • Select the whole dataset.
  • Later, press Ctrl+H to open the Find and Replace dialog box.

Identify Space Characters and Delete Extra Columns in Excel

  • Type space in the Find what box and keep the Replace with box empty.
  • Finally, press Replace All.

Identify Space Characters and Delete Extra Columns in Excel

Now Excel has removed the spaces and will give you a pop-up message about the result.

And now you will be able to detect all the extra empty columns in your dataset and delete them.

Read More: VBA Macro to Delete Columns Based on Criteria in Excel (8 Examples)


Similar Readings:


3. Unprotect Sheet in Excel If You Can’t Delete Extra Columns

Another most common reason is- maybe your sheet is protected with a password and you have forgotten to unprotect it before deleting extra columns. So if you try to delete columns, the delete option with many other options will remain faded which indicates that you can’t use them.

Unprotect Sheet in Excel If You Can't Delete Extra Columns

Solution:

Let’s see how to unprotect the sheet.

Steps:

  • Click as follows: Home > Cells > Format > Unprotect Sheet.

Unprotect Sheet in Excel If You Can't Delete Extra Columns

  • Give the password and press OK.

Unprotect Sheet in Excel If You Can't Delete Extra Columns

  • Select the extra empty column and see that the Delete option is activated.
  • Click it to delete.

Yes! it’s deleted successfully.

Read More: How to Delete Infinite Columns in Excel (4 Methods)


Conclusion

I hope the procedures described above will be good enough to fix the problem when you can’t delete extra columns in Excel. Feel free to ask any question in the comment section and please give me feedback.


Related Articles

Md. Sourov Hossain Mithun

Md. Sourov Hossain Mithun

Hello! I am Md. Sourov Hossain Mithun. Welcome to my profile. Currently, I am working at Exceldemy as an Excel and VBA Content Developer. Excel is amazing software. Here I will post excel related useful articles. I am a graduate of Bangladesh University of Engineering and Technology. I love to learn new things and work with them. Thank you.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo