How to limit the changes other users can make to an Excel spreadsheet, whilst not limiting me from changing anything

Hi Adrian

Thanks again for your help.

Alas, your solution also prevents me from editing other parts of the spreadsheet. Therefore, it doesn't resolve the problem.

Any other suggestions?

Regards

Justin

Hi Adrian

Thanks for your prompt reply.

My mistake, I don't think I was clear enough in my initial question: I want to allow other users to be able to edit certain cells at any time, but I want to be able to do anything personally to the spreadsheet without limits. I don't want to have to unlock the sheet to make my edits as this would leave it vulnerable to other users.

For clarity, I'm using the spreadsheet to record both historic sales figures and future forecast figures. The users should only be able to alter the forecast figures.

Any ideas?

Hi Justin

Thank you for your reply and clarification.

Here is a solution to set the editable area, ensuring that other users can only edit the specified cells (such as forecast data), while you as the creator can edit the entire table at any time without restrictions, without manually unprotecting it:

• Unlock cells for user editing:

1. Select the range of cells you want to allow the user to edit (e.g., D2:F20).
2. Right-click → Format Cells → Protection tab → Uncheck "Locked" → OK.

• Protect the worksheet:

1. Go to the Review tab → Click Protect Sheet.
2. In the permissions list, check only "Select unlocked cells" (uncheck other permissions like formatting, inserting rows, etc.).
3. Set a password (e.g., 123) → Confirm the password.

This way, the user can only edit the unlocked range (e.g., D2:F20), while other areas remain locked.

I hope these suggestions have been helpful to you!

Feel free to let me know if you have any other questions or need any further help.

Best regards

Adrian.C-MSFT | Microsoft Community Support Specialist

Hi Justin

To restrict other users from making changes in an Excel spreadsheet while retaining full control as the creator, follow these steps:

Method 1: Standard Excel Protection

1. Unlock All Cells (optional, but ensures you retain access):
   • By default, all cells are "locked" but not protected. To confirm:
     • Press Ctrl + A to select all cells.
     • Right-click → Format Cells → Protection tab → Uncheck "Locked" → OK.
2. Protect the Sheet with a Password:
   • Go to Review → Protect Sheet.
   • Uncheck all permissions (e.g., formatting, inserting rows) to restrict others entirely.
   • Set a password (e.g., MyPassword) and confirm.
   • Others cannot edit cells or perform restricted actions without the password.
   • You must unprotect the sheet (using the password) to make changes, then reprotect it afterward.

Method 2: File System Permissions (External)

Set read-only access for others via your OS:

1. Right-click the file → Properties → Security tab.
2. Edit permissions to grant others Read access only (no Write).

Result:

• Others can open the file but cannot save changes (they’ll be prompted to save a copy).

Summary

• For simplicity: Use Method 1 and unprotect/reprotect as needed.
• For strict control: Use Method 2 (OS permissions) alongside Excel protection.

Choose the method that best balances security and convenience for your workflow.

I hope these suggestions have been helpful to you!

Feel free to let me know if you have any other questions or need any further help.

Best regards

Adrian.C-MSFT | Microsoft Community Support Specialist