Enable Insert Button under Excel Developer tab (with Images)
Che cosa is it: Insert button under Excel Developer tab is greyed out and not allowing you click?
Perché is it disabled:
One of the reasons for Insert button under Excel Developer tab is grayed out or disabled is because there must be multiple sheets selected in your workbook.
Come a enable insert button:
Once you remove the multiple sheet selection Insert button will be enabled.
Passo 1: Go to Sheet Tabs and Shift + Left Click on any one of the selected sheets.
Passo 2: Go back to Developer tab and check the Insert button, it should be enabled now.