Allow insert and delete row function are not working at all in my Excel when protecting sheet functions allowed.

Question

Allow insert and delete row function are not working at all in my Excel when protecting sheet functions allowed.

Anonymous

I have tried starting fresh with just a basic table.

Unlocked the cells I wish to input data.

When I tab through it will create a new row if unprotected.

When protected, it will not allow insert or delete.

I have tried selecting ALL permissions when protecting.

All other permissions seem to work except insert and delete rows.

Microsoft® Excel® for Microsoft 365 MSO (Version 2501 Build 16.0.18429.20132) 64-bit

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Answer 1

Dear Crudmucker ,

Welcome to Microsoft Community.

We understand that there is a problem with the Excel function after you enable worksheet protection.

According to your description, you use Microsoft 365 and have tried to enable the "Protect Worksheet" information. We need to confirm with you:

Have you selected "Allow Editing Ranges" in your worksheet and set the corresponding information?

You said you selected all permissions. Did you check the box that allows all information to be operated after clicking "Protect Sheet"? Or did you set other permissions?

If possible, you can share a screenshot with us or share your file with us via private message, and we will help to confirm further.

We have tested and found that under normal circumstances, when you turn on "Protect Sheet", you make sure to check "Insert or delete rows or columns", and you can operate and insert information in the worksheet correctly:

If it doesn't work, we also recommend that you try to add permissions for the area you need to edit.

You can use the "Allow Editing Range" function to add permissions and range passwords for your cell range, and make sure to enter the password information during the editing process.

Then confirm whether your insert or other function information is correct.

You can try the operation first, because the functions and information displayed for protecting the worksheet under different operations are different. We also look forward to you sharing your files and more information with us, and we will help you find a solution.

Best Regards,

Zenobia.Z | Microsoft Community Support Specialist