Insert button grayed out in the developer tab

Insert button grayed out in the developer tab

What is it:

Insert option under Developer tab is grayed out and not allowing you click?

Developer-Insert button

Why is it disabled:

One of the reasons for this option is grayed out or disabled is because your excel sheet must be Shared.

How to enable Insert button:

Once you Remove the Share Workbook option this gets enabled.

Step 1: Go to Review tab and click on Share Workbook.


Step 2: From the pop-up menu Uncheck the  “Allow changes…..” option and click OK.

Share Tick_asKeygeek

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

Developer-Insert button

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 a decade of versatile experience in Business Process Outsourcing, Finance & Accounting, Information Technology, Operational Excellence & Business Intelligence. I have got the opportunity to work for Genpact, Hewlett Packard, M*Modal and Capgemini in various roles and responsibilities, starting from an Associate to a Manager. Learning anything new has always been my passion and if related to Business and Technology then I love it. is an outcome of my passion towards the same and I have been into asKeygeek since 2012. Outside business and technology I’m a movie buff who spends hours together watching and learning Cinema, I do make Short Films 🙂


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

  2. Pingback: Insert button grayed out in the developer tab |...

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.