How to Enable Display options for this workbook:Insert Button Greyed Out

Developer-Insert-Enabled
Table of Contents

Enable Display Options in Excel to All (with Images)

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

Developer-Enable Display Options

Why is it disabled:

One of the reasons for this option is grayed out or disabled is because “Display options for this workbook For objects, show:” must be set as “Nothing (hide objects)” instead of “All”

How to Enable Display options:

Once you change or Enable Display options to “All” Insert Button will be enabled.

Step 1: GoTo Excel Options Menu and click on “Advanced”

Step 2: Set “For objects, show:” as “All” under “Display options for this workbook” from Advanced Menu options. And Click OK.



Excel_Options_Enable Display OptionsPinStep 3: Go back to Developer tab and check the Insert button, it should be enabled now.Developer-Insert-Enabled

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!

4 Responses

    1. In my case it was that my command buttons stopped being responsive and disappearing when moving between other sheets in my workbook.
      And surely know that I did not disable this in the settings, nor did I get any notice about it from Mr. “Microsoft”!
      Regards

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