What to Do When Excel Won't Let You Insert Columns

spreadsheet_rom2015.jpg

spreadsheet
rom2015/iStock
Share this content
19

From time to time you might encounter the prompt that appears when Excel thinks you can't add additional columns or rows.

This occurs when Excel considers used range of the worksheet to encompass all columns or rows. In this article I'll describe some techniques you can use to overcome this problem.

Figure 1: It's frustrating when Excel won't allow you to insert columns or rows.

Please Login or Register to read the full article

To access all of the content on our site, register (it's free!) or login to your existing account.

Replies

Please login or register to join the discussion.

avatar
By carpetstains
Jun 26th 2015 01:10

this great information i've learn on here so keep up the good inforamtion you've posted here guys

Thanks (0)
avatar
By carpetstains
Jun 26th 2015 01:10
Thanks (0)
avatar
By HienNguyen
Jun 26th 2015 01:10

thank you so much, I've got it solved alreadly

Thanks (0)
avatar
By Ronald Miranda
Jun 26th 2015 01:11

Hi! I've just posted how to fix this:

http://runakay.blogspot.com/20...

Thanks (0)
avatar
By Amy Witt
Jun 26th 2015 01:11

It didn't work for me. Any other suggestions

Thanks (0)
avatar
By HEMENDRA PARIDA
Jun 26th 2015 01:11

It happened to me as well. the above did not work. I tried a trick. I opened a work book where I could incert colums. then with that workbook I opened my file which was having probmem (by file Open mode "CTRL+O" and not by going through folder) then tried to incert column. It worked. What I feel is there could be file extension issue. Just try this out it may work for you as well. Thanks, Hemendra.

Thanks (0)
avatar
By cocktaildresses
Jun 26th 2015 01:11
Thanks (0)
avatar
By Xcl
Jun 26th 2015 01:11

Had the same issue, turned out to be the file name was too long (sounds weird), when I renamed to a smaller one it worked.

Thanks (0)
avatar
By Anonymous
Jun 26th 2015 01:11

The three paragraphs under Figure 1: Very helpful! Thank you!

Thanks (0)
avatar
By akjalewa
Jun 26th 2015 01:11

Worked well gr8 help thanks

Thanks (0)
avatar
By JAC
Jun 26th 2015 01:11

thank you

Thanks (0)
avatar
By SecondBull
Jun 26th 2015 01:11

If there is a problem, then I would seek help that could help resolve this issue. There are so many menus that can be tried one by one. Learn about Seattle IT Consulting James Murray

Thanks (0)
avatar
By SecondBull
Jun 26th 2015 01:11

Entering the column will be an easy job for those who know basis. They will be able to enter the field in accordance with the needs of how many.Best Delux Prince Of Wales Island Fishing Lodges

Thanks (0)
avatar
By bokins
Jun 26th 2015 01:11

Tnx. I fix my problem with insert new columns.

Thanks (0)
avatar
By leahplotkingmailcom
Jun 26th 2015 01:11

awesome! worked like a charm - thank you!

Thanks (0)
avatar
By Shane Atchison
Jun 26th 2015 01:11

Didn't work at all.

Thanks (0)
avatar
By HaroldSalvatored
Jun 26th 2015 01:11

Insert column will be a difficult thing if you and a lot of people do not know how. You must use the menu on the right way. led high bay lighting

Thanks (0)
avatar
By Alessandra
Jun 26th 2015 01:11

The first didn't work, but the Visual Basic Editor one worked perfectly! Thank you for posting this.

Thanks (0)
avatar
By Rebecca
Jun 26th 2015 01:11

Thank you so much so helpful! Was driving me crazy!! Solved a work problem!

Thanks (0)