Excel Cannot Insert Column: 6 Fixes

Struggling to add columns in Excel? If Excel can’t insert columns, follow this guide to fix the problem.

Curiosity is a dangerous thing. You can lose hours of your life scrolling your phone calendar to see just how far into the future it goes. If you’re an Excel user, perhaps you’ve tried to work out just how many Excel columns or rows there actually are.

For the majority of the time, the answer is that there are more than plenty. Sometimes, however, you may bump into issues where Excel seems to think that you’ve used up all the available columns, and it won’t let you add any more in.

If this sounds like you, then here are some steps to try if Excel cannot insert a column where you want one.

One of the most common causes of not being able to insert a column in Excel is because Excel thinks that by doing so, it will destroy some of your data. This occurs when Excel thinks that you have already entered data in the maximum number of allowable columns.

In order to add another column, Excel would have to delete one of the current columns. It means that you can move columns, but if you try to add a new one, you’ll see a warning message that the action can’t be performed.

Often, however, this is usually just down to rogue data or cell formatting being found in all the columns, rather than actual useful data.

By deleting the content from any unneeded columns, you should be able to fix the issue. However, you’ll need to save and reopen the file before it will work.

To delete content from excess columns in Excel:

Another reason why you may see this error is if you have merged two entire rows together. In this case, when you try to insert a column, there is no additional room as your merged cell already takes up the full width of the spreadsheet.

To fix this, unmerge the rows—you should be able to insert columns again.

To unmerge rows in Excel:

If you don’t see the Microsoft Excel cannot insert new cells error, then the problem lies somewhere else. Another common reason that you can’t insert a column is because the spreadsheet has been protected to stop any changes being made to it.

By unprotecting the document again, you may be able to insert columns once more. If you try to insert a column, and you see most of the options are grayed out, this is a clue that your worksheet is protected.

To unprotect an Excel document:

If you want to keep your sheet protected, but still want to be able to insert columns, you can change the sheet protection settings.

To allow new columns in a protected Excel worksheet:

There may be cases where freezing panes can stop you from inserting any more columns into your spreadsheet.

By unfreezing panes in your sheet, you may be able to insert columns once more.

To unfreeze panes in Excel:

If you have tables in your data, this may cause issues when trying to insert columns. If this is the case, you can convert your tables back into ranges again, and you should be able to insert columns as normal.

Although it can feel like Excel is one big table, multiple cells within Excel are considered a range. If you insert a table, it has specific formatting that is different from standard ranges, such as sortable column headers, banded rows, and calculated columns.

Inserting columns in a table adds another table column to the next column of cells, rather than inserting a new column into the worksheet.

To convert a table to a range in Excel:

If all else fails, you can try copying that data you want to use and pasting it into a new worksheet. This may ensure that no erroneous data or formatting gets carried over that could stop Excel from allowing you to insert any more columns.

To copy your Excel data to a new sheet:

If you’re having issues because Excel cannot insert a column, then hopefully one of the fixes above can help. Please let us know in the comments below if you discover any other useful ways to fix the issue.

Sometimes getting Excel to do what you want it to can be a challenge. There are some useful tips that can help, however. There are some steps you can try if you’re having problems with Excel formula references, or if you’ve ended up with some circular references.

And there are some useful fixes to try if you find that Excel keeps crashing.

Your email address will not be published. Required fields are marked *

Comment

Name *

Email *

Δ

Save my name and email and send me emails as new comments are made to this post.