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.
3 Responses
I tried all 5 ways that you mentioned to enable insert row
, but finally below video helped – FYI pls and do include it too.
https://www.youtube.com/watch?v=LaC-y8M4utQ