Excel Tips

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?

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.

Pin

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

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 is a contributing author and founder at 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!

2 Responses

Pingback: Excel Insert Button Greyed Out? 5 Solutions (with Images)
Pingback: Insert button grayed out in the developer tab |...

Thousands Of Users Every Month

Get connected with ASKEYGEEK.com

Our Deals - ^{up to}82% OFF

*Use Code: MASTERS20

*Discount Applied Automatically

Forgot Password

Insider Login