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?Disable Track Changes

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.Disable Track Changes_asKeygeek

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

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

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.



About Anson

I’m Anson having a decade of versatile experience in Business Process Outsourcing, Finance & Accounting, Information Technology, Operational Excellence & Business Intelligence. I have got the opportunity to work for Genpact, Hewlett Packard, M*Modal and Capgemini in various roles and responsibilities, starting from an Associate to a Manager. Learning anything new has always been my passion and if related to Business and Technology then I love it. asKeygeek.com is an outcome of my passion towards the same and I have been into asKeygeek since 2012. Outside business and technology I’m a movie buff who spends hours together watching and learning Cinema, I do make Short Films 🙂

2 Comments

  1. Pingback: Excel Insert Button Greyed Out? 5 Solutions (with Images)

  2. Pingback: Disable Track Changes to Enable Insert button (...

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.