Unable to insert columns

[michaelsgramps]

I am unable to insert columns on any worksheets. Even a blank worksheet. The insert column function remains disabled. Work sheets are not protected. What can I do to activate this function?

[VBA Noob]

Hi,

Excel only has 256 Columns. Have you used them all ??

VBA Noob

[michaelsgramps]

This problem is on any worksheet, even blank sheets that I have not used any columns.

[oldchippy]

Are there any other operations on the Insert menu blanked out?

[tony h]

Have you got the workbook protected? Look in Tools...Protection it will then list either Protect or Unprotect depending on the current status.

Hope this helps

[michaelsgramps]

Work book is not protected. All the other insert functions work ok.

[nsv]

Another way of inserting col's and rows is by typing CTRL + '+' and it must be the plus-sign at the numeric keys.
It is a poor solution, but at least it lets you insert your col's

[oldchippy]

Work book is not protected. All the other insert functions work ok.

Can you post the workbook here and see if we can duplicate the problem?

[NBVC]

This may help...

http://forums.microsoft.com/MSDN/Sho...56328&SiteID=1

There is a code to reset commandbars in the 5th post on this page.

[michaelsgramps]

Another way of inserting col's and rows is by typing CTRL + '+' and it must be the plus-sign at the numeric keys.
It is a poor solution, but at least it lets you insert your col's

Thank you that works,that will make life better.

But still don't understand why the insert column function is disabled all the time? I have reloaded the program and made sure I have all the lastest updates. The problem still remains?

[michaelsgramps]

This may help...

http://forums.microsoft.com/MSDN/Sho...56328&SiteID=1

There is a code to reset commandbars in the 5th post on this page.

NBVC
Thank you very much! This fixed the problem.

[Discreter]

Just another tip that I came across for anyone for whom the solution above did not work.....

Someone had set all of the column and row widths to 0.

Crtl + End then hold shift and select the last visible row or column with right click and set the width to 11 for columns or 13 for rows.

If the shift click does not work then go to the very end of the row of column and try to resize, this should resize the last row or column. Then shift click to the last visble and right click to change the width or height.