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


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.

Anson Antony

Anson Antony

Anson is a contributing author and founder at Learning anything new has always been his passion, 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.

Launching soon...

E-book price at Amazon will be $14.99 

A Practical Guide To Online Business
You Made It,
Don't Close!

Enter your chance to win our Premium Membership License for FREE! ( Normal Price $199/Year)

Thank you for your visit!

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

Premium Membership Giveaway - Popup

Let's have a chat

Fill out the form below to consult with us

*Please check your Inbox or Junk Folder for the Confirmation Email. You must confirm your Company email address before we could revert.

Share to...