Enable Insert Button under Excel Developer tab (with Images)
ماذا is it: Insert button under Excel Developer tab is greyed out and not allowing you click?
لماذا 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.
كيف to enable insert button:
Once you remove the multiple sheet selection Insert button will be enabled.
الخطوة 1: Go to Sheet Tabs and Shift + Left Click on any one of the selected sheets.
الخطوة 2: Go back to Developer tab and check the Insert button, it should be enabled now.