Enable Insert Button under Excel Developer tab

Table of Contents

Enable Insert Button under Excel Developer tab (with Images)

What is it: Insert button under Excel Developer tab is greyed out and not allowing you click?Developer_Enable Insert Button

Why is it disabled:

One of the reasons for Insert button under Excel Developer tab is grayed out or disabled is because there must be multiple sheets selected in your workbook.Before

How to enable insert button:

Once you remove the multiple sheet selection Insert button will be enabled.




Step 1: Go to Sheet Tabs and Shift + Left Click on any one of the selected sheets.After

Step 2: Go back to Developer tab and check the Insert button, it should be enabled now.Developer-Enable Insert Button

If the above didn’t work for you then, Check for the other 4 reasons for insert button grayed out on the Developer tab.



Insert button under Excel Developer tab is greyed out and not allowing you click?>Enable Insert Button under Excel Developer tab (with Images)

What is it: Insert button under Excel Developer tab is greyed out and not allowing you click?Developer_Enable Insert Button

Why is it disabled:

One of the reasons for Insert button under Excel Developer tab is grayed out or disabled is because there must be multiple sheets selected in your workbook.Before

How to enable insert button:

Once you remove the multiple sheet selection Insert button will be enabled.



Step 1: Go to Sheet Tabs and Shift + Left Click on any one of the selected sheets.After

Step 2: Go back to Developer tab and check the Insert button, it should be enabled now.Developer-Enable Insert Button

If the above didn’t work for you then, Check for 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!

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...