Como desativar o controle de alterações no Excel para ativar a inserção na guia Desenvolvedor

Disable Track Changes to Enable Insert button (with Images)

Step by step instructions to Disable Track Changes

O que é isso:

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

Por que está desativado:

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.

Como para disable Track Changes:

Once you disable Track Changes, Insert will be enabled.

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

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

Etapa 3: Volte para a aba Desenvolvedor e marque o botão Inserir, ele deve estar habilitado agora.

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.