Home › Knowledgebase › KB-1481

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.

Quick Tip: Need immediate assistance? 💻 Open a Ticket

Common Causes

Lock Cells in a Worksheet

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. Automotive workshops can use these settings to maintain accurate pricing records while allowing front-desk staff to update only the required fields.

  1. Open the Excel workbook you want to protect. For example, open your standard parts quote template.
  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. For example, select the cells where job status updates are entered on a customer job sheet.
  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.
  7. Test the protection by attempting to edit a locked cell, such as a supplier price cell, and confirming that Excel prevents the change.
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.

Protected View for Files from Untrusted Locations

Excel opens files downloaded from the internet or received via email in Protected View to help prevent potentially unsafe content from running. This is useful for supplier invoices or parts catalogues received from external sources.

  1. Open Excel and go to File > Options.
  2. Select Trust Center and click Trust Center Settings.
  3. Choose Protected View.
  4. Ensure the options for files originating from the internet or other potentially unsafe locations are ticked.
  5. Click OK to save the settings.
Protection features and menu paths vary slightly between Excel for Windows, Excel for Mac, and Excel for the web. Some advanced protection options may not be available in older Excel versions or in the web version.

Troubleshooting

Cells can still be edited after protection is enabled

Protect Sheet button is greyed out

Forgotten worksheet password

Open a Ticket

Still Having Issues?

Need more help? If the issue persists after trying these steps, please open a support ticket and our team will assist you.

💻 Open a Ticket