5 Reasons/Causes for Excel Insert button greyed out on the Developer tab

Share This Post

Share on facebook
Share on linkedin
Share on twitter
Share on email

Excel Insert Button Greyed Out? 5 Solutions (with Images)

What is it:

Insert button under Developer tab helps you insert Form Controls and ActiveX Controls like Combo Box, List Box, Spin Button etc on your User Form or Excel worksheet. But there are few situations when this insert option disabled in Excel or the Excel Insert Button greyed out and will not allowing you click.

In this post we are discussing the various reasons for Excel Insert Button greyed out and how to enable the same.

Why is it Disabled:

There are mainly 5 different reasons for Excel Insert button greyed out on the Developer Tab.Excel Insert button greyed out_asKeygeek

Reason 1: Excel Insert button greyed out due to Excel Sheet or Workbook is Protected.

Click the Here to know how to Unprotect and Enable the Greyed out Insert buttonExcel Insert button greyed out-Unprotect

Reason 2: Excel Insert button greyed out due to Excel Sheet or Workbook is Shared.

Click the Here to know how to Unshared and Enable the Greyed out Insert button.Excel Insert button greyed out_asKeygeek

Reason 3: Excel Insert button greyed out due to Multiple Sheets Selected in the Workbook.

Click the Here to know how to Unselect and Enable the Greyed out Insert button.Excel Insert button greyed out_asKeygeek


Reason 4: Excel Insert button greyed out due to Display Options for the Workbook is Disabled.

Click the Here to know how to Enable Display Options and Enable the Greyed out Insert button.Excel Insert button greyed out_asKeygeek

Reason 5: Excel Insert button greyed out due to Track Changes Enabled for the Workbook.

Click the Here to know how to Disable Track Changes and Enable the Greyed out Insert buttonExcel Insert button greyed out_TrackChanges_asKeygeek

These are the common reasons for Excel Insert button greyed out on the Developer Tab and the solutions to the same. Please let us know if you find some other reason for insert option disabled excel.

I’m sure you work on lots of Excel data and VBA and I Strongly Recommend you to Join the below VBA Classes! Its a worth Investment in Yourself! DO IT NOW!
VBA Classes

You can also refer these eBooks:

Download Excel/VBA/Macro Books.




Subscribe To Our Newsletter

Get updates and learn from the best

26 Responses

  1. For reason #4 you may have pressed ctrl+6 which toggles display options on/off pressing ctrl+6 again toggles it back on.

  2. I spent hours in looking for a solution. In my case it was the solution 4. Thank you for your tips

  3. in folder
    C:\Users\Username\AppData\Roaming\Microsoft\Excel
    just delete the excel folder

    it works for me at least

  4. Go to following file location in your login profile
    C:\Users\Username\AppData\Roaming\Microsoft\Excel\Excel14.xlb

    Just Close all excel files and rename
    Excel14.xlb
    To
    Excel14.xlb_old
    and start excel file and enjoy………………………………

Leave a Reply

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

More To Explore

Why Is It Important to Use AI in Digital Marketing
Artificial Intelligence

Why Is It Important to Use AI in Digital Marketing?

Artificial intelligence is making life a lot easier, not just in the digital marketing world but for every field it is being used. If you do not know how to use ai in digital marketing then you are falling behind already

UiPath License Model
Automation

UiPath License – 12 Facts You Must Know!

Sometimes it can be little confusing to understand the UiPath License models, especially with the terms like UiPath Studio License, UiPath Orchestrator License, Node Locked

Do You Want To Boost Your Business?

drop us a line and keep in touch

small_c_popup.png

Let's have a chat

Fill out the form below to consult with us

FREE ACCESS CODE!

We are glad you are here!
You are now part of our ASKEYGEEK family and as promised here is your Free Premium Upgrade Code for AI TTS and other Premium services

PRETTS2021

Copy this code and use it while checkout

Congratulations!

You Made It,
Don't Close!

Get your Premium Access Code to Artificial Intelligence TTS and Others for FREE! ( For 1 Month worth $199)

Thank you for your visit!