Excel Tips

How to Disable Track Changes in Excel to Enable Insert under Developer Tab

Disable Track Changes to Enable Insert button (with Images)

Step by step instructions to Disable Track Changes

What is it:

Insert button under Developer tab is greyed out and not allowing you to click?

Why is it disabled:

One of the reasons for this option is grayed out or disabled because you might have enabled ‘Track Changes’ in Excel. If Track Changes is enabled Insert feature will not work.

How to disable Track Changes:

Once you disable Track Changes, Insert will be enabled.

Step 1: Go to “Review” tab and click on the “Track Changes” option.

Step 2: From the Drop Down menu Click on “Accept/Reject Changes”. Once disabled the option should greyed out.

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!