How to enable Insert under Developer tab in excel 2007 and 2010

Developer Tab Insert button disabled in Excel 2007 and 2010?

What is it: Insert option under Developer tab is greyed out and not allowing you click?

Why is it disabled: Reason why this option is greyed out or disabled is because your Excel sheet is Protected.

How to enable Developer tab:

Once you unprotect the sheet, this gets enabled.

Step 1: Go to Review tab and click on Unprotect.

Step 2: Enter the same password you used to protect the sheet and click OK.





Step 3: Go back to Developer and check the Insert button, it should be enabled now.

Developer tab

If the above didn’t work for you then Click Here to check out the other 4 reasons for insert button grayed out on the Developer tab.



About Anson

I’m Anson, having versatile experience in Business Process Outsourcing, Finance & Accounting, Information Technology, Operational Excellence & Business Intelligence. I'm currently working in a MNC in Bangalore, India. Learning anything new has always been my passions and if its related to Business and Technology then, I love it. This website/blog is an outcome of my passion towards it and I have been blogging since 2012. Outside business and technology I’m a movie freak who spends hours together watching and learning Cinema.

6 Comments

  1. I have this issue but the worksheet is NOT protected. Anyone know of another cause for the grayed out Insert button on the Developer tab?

  2. Pingback: How to enable Insert under Developer tab in exc...

  3. Pingback: Excel Insert Button Greyed Out? 5 Solutions (with Images)

Leave a Reply