Insert button grayed out in the developer tab

Insert button grayed out in the developer tab

What is it:

Insert option under Developer tab is grayed out and not allowing you click?

Why is it disabled:

One of the reasons for this option is grayed out or disabled is because your excel sheet must be Shared.

How to enable Insert button:

Once you Remove the Share Workbook option this gets enabled.

Step 1: Go to Review tab and click on Share Workbook.

Step 2: From the pop-up menu Uncheck the  “Allow changes…..” option and click OK.

(adsbygoogle = window.adsbygoogle || []).push({});

Pin

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

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.

(adsbygoogle = window.adsbygoogle || []).push({});
</scriptInsert button grayed out in the developer tabx; text-align: center;”>Insert button grayed out in the developer tab

What is it:

Insert option under Developer tab is grayed out and not allowing you click?

Why is it disabled:

One of the reasons for this option is grayed out or disabled is because your excel sheet must be Shared.

How to enable Insert button:

Once you Remove the Share Workbook option this gets enabled.

Step 1: Go to Review tab and click on Share Workbook.

Step 2: From the pop-up menu Uncheck the  “Allow changes…..” option and click OK.

(adsbygoogle = window.adsbygoogle || []).push({});

Pin

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

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.

(adsbygoogle = window.adsbygoogle || []).push({});
Insert button grayed out in the developer tabx;text-align: center”>Insert button grayed out in the developer tab

What is it:

Insert option under Developer tab is grayed out and not allowing you click?

Why is it disabled:

One of the reasons for this option is grayed out or disabled is because your excel sheet must be Shared.

How to enable Insert button:

Once you Remove the Share Workbook option this gets enabled.

Step 1: Go to Review tab and click on Share Workbook.

Step 2: From the pop-up menu Uncheck the  “Allow changes…..” option and click OK.

(adsbygoogle = window.adsbygoogle || []).push({});

Pin

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

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.

(adsbygoogle = window.adsbygoogle || []).push({});
</scriptInsert button grayed out in the developer tabx; text-align: center;”>Insert button grayed out in the developer tab

What is it:

Insert option under Developer tab is grayed out and not allowing you click?

Why is it disabled:

One of the reasons for this option is grayed out or disabled is because your excel sheet must be Shared.

How to enable Insert button:

Once you Remove the Share Workbook option this gets enabled.

Step 1: Go to Review tab and click on Share Workbook.

Step 2: From the pop-up menu Uncheck the  “Allow changes…..” option and click OK.

(adsbygoogle = window.adsbygoogle || []).push({});

Pin

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

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.

(adsbygoogle = window.adsbygoogle || []).push({});