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

Developer-Insert-Enabled
Table of Contents

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?How To Enable Insert Under Developer Tab In Excel 2007 And 2010 1

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.

How To Enable Insert Under Developer Tab In Excel 2007 And 2010 2

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

How To Enable Insert Under Developer Tab In Excel 2007 And 2010 3



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.






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.






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.






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.



Anson Antony
Anson Antony
Anson is a contributing author and founder at www.askeygeek.com. Learning anything new has always been his passion, askeygeek.com is an outcome of his passion for technology and business. He has got a decade of versatile experience in Business Process Outsourcing, Finance & Accounting, Information Technology, Operational Excellence & Business Intelligence. During the tenure, he had worked for organizations like Genpact, Hewlett Packard, M*Modal and Capgemini in various roles and responsibilities. Outside business and technology, he is a movie buff who spends hours together watching and learning Cinema and a Film Maker too!

6 Responses

Leave a Reply

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

Congratulations!
You Made It,
Don't Close!
Enter your chance to win 100,000 UberTTS Character Credits
Thank you for your visit!

This popup won’t show up to you again!!!

UberTTS 100K Easter Egg
Share to...