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

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.

Picture of 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!

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”!

Leave a Reply

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

You Made It,
Don't Close!

Get Up To 60,000 UberTTS Character Credits for Free!!!

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

Share to...