How To Lock Cells In Excel To Prevent Accidental Changes

Summary

This guide helps you troubleshoot and resolve: How To Lock Cells In Excel To Prevent Accidental Changes. Follow the steps below to fix the issue.

Common Causes

This guide explains how to configure Microsoft Excel workbooks so financial documents such as supplier invoices, parts quotes, and customer job sheets cannot be altered unintentionally. It covers applying password protection to worksheets and unlocking specific editable ranges for authorised staff. Automotive workshops can use these settings to maintain accurate pricing records while allowing front-desk staff to update only the required fields.

Lock Cells in a Worksheet

1. Open the Excel workbook you want to protect.
2. Select all cells by clicking the corner button where row and column headers meet, or press Ctrl + A.
3. Right-click the selection and choose Format Cells.
4. Go to the Protection tab and ensure the Locked checkbox is ticked.
5. Click OK.
6. Go to the Review tab on the ribbon.
7. Click Protect Sheet.
8. Enter a password if required, choose the actions users are allowed to perform, and click OK.

Unlock Specific Cells for Editable Fields

If front-desk staff need to update certain fields—such as customer details or job status—while keeping pricing and parts data fixed, unlock those cells first.

1. Select the cells or ranges that should remain editable.
2. Right-click and choose Format Cells.
3. Go to the Protection tab.
4. Untick the Locked checkbox.
5. Click OK.

You can select multiple non-adjacent ranges by holding down Ctrl while clicking each cell or range before opening Format Cells.

Protect the Worksheet

Once cells are marked as locked or unlocked, enable sheet protection to enforce the settings.

1. Go to the Review tab on the ribbon.
2. Click Protect Sheet.
3. Optionally enter a password to prevent unauthorised users from unprotecting the sheet.
4. Under Allow all users of this worksheet to:, tick the actions you want to permit, such as Select locked cells and Select unlocked cells.
5. Click OK.
6. If you set a password, re-enter it to confirm.

Store your password in a secure location. If the password is lost, Microsoft cannot recover it, and you may be unable to unprotect the sheet.

Protect Workbook Structure (Optional)

Use this to prevent users from adding, deleting, moving, or hiding worksheets within the file.

1. Go to the Review tab.
2. Click Protect Workbook.
3. Enter a password if desired and click OK.

Troubleshooting

Cells can still be edited after protection is enabled

• Check that the cells you want to protect are marked as Locked in Format Cells > Protection.
• Ensure sheet protection is actually turned on via Review > Protect Sheet.

Forgotten worksheet password

• Excel does not provide a password recovery option for protected sheets.
• If you have an unprotected backup copy, you can re-apply protection with a new password.
• Otherwise, recreate the sheet settings in a new workbook.

For further assistance with Microsoft 365 configuration, please contact your IT support provider.

Still Having Issues?