Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I want to insert a column in excel 2007, yet the insert column is greyed out

the sheet it not protected, and there is not restrictions whatsoever

another sheet on the same file work correctly.

how do I fix this?

share|improve this question
    
What steps are you taking to insert a column? Are there any merged cells? Those can sometimes interfere with column/row operations. –  techturtle Oct 11 '12 at 14:33

1 Answer 1

up vote 0 down vote accepted

Well..

Apparently, If do conditional formatting it will stretch to all columns.. And if all columns are used there is no room to insert more columns..

once the useless columns are deleted it is solved..

share|improve this answer
    
Have you thought of adjusting the conditional formatting so that it only applies to the columns you need it to? –  pnuts Oct 11 '12 at 15:21
    
... and than you for actually posting your answer! –  pnuts Oct 12 '12 at 11:05
    
*thank . Also, you are allowed to accept your own answer. –  pnuts Oct 15 '12 at 15:40

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.