Permission & Access Issues

How to Lock All Excel Cells Except Specific Ones (For Salespeople)

Emma Brown Oct 10, 2026 870 views

Question details

The user needs to lock an entire Excel worksheet to prevent unauthorized changes while leaving specific cells editable for certain users, such as salespeople.

How to Lock All Excel Cells Except Specific Ones

Product: Excel
Device & OS: not provided
Scenario: Securing a shared worksheet to restrict data modification, allowing only designated cells to be edited by specific team members.
Observed behavior: Users want to prevent accidental or unauthorized edits to formulas and static data while enabling data entry in specific unprotected cells.

Before you start

Before proceeding, ensure your worksheet is currently unprotected so you can modify cell locking properties, and prepare a secure password that you will easily remember.

Solution 1Recommended

Lock All Cells and Selectively Unlock Required Cells

This is the standard and most reliable method to ensure all non-essential cells are locked while providing editing access to specific areas.

By default, all cells in Excel have their 'Locked' property turned on, but this locking does not take effect until worksheet protection is enabled. To avoid conflicts from previous settings, it is best to explicitly lock all cells first, then unlock only the ones you need.

Unprotect the worksheet

If your worksheet is already protected, go to the Review tab and click 'Unprotect Sheet' to allow formatting changes.

Select all cells

Click the small triangle square at the intersection of the column letters and row numbers (top-left corner) to select the entire worksheet.

Lock all cells

On the Home tab, navigate to Format > Lock Cell. This ensures every cell in the worksheet is properly locked initially.

Unlock specific cells for salespeople

Highlight the specific cells your salespeople need to edit. You can hold the Ctrl key while clicking to select multiple nonadjacent cells. Once selected, go to Home > Format > Lock Cell again to unlock just these cells.

Protect the worksheet

Go to Home > Format > Protect Sheet (or Review > Protect Sheet). Enter a secure password, verify the permissions you want to grant, and click OK.

Lock All Cells and Selectively Unlock Required Cells

Password Recovery Warning: Keep your password in a safe place. If you lose or forget the password, it may not be possible to recover it or remove the worksheet protection.

Solution 2

Unlock Specific Cells Using the Format Cells Dialog

An alternative approach using the classic Format Cells dialog box, ideal for users who prefer working with keyboard shortcuts and deeper formatting options.

Secure Your Spreadsheets Easily

Easily Protect and Lock Cells with WPS Spreadsheet

WPS Spreadsheet offers robust worksheet protection features, allowing you to effortlessly lock entire sheets and grant specific cell edit permissions to your team members.

1. Select Cells: Open your document in WPS Spreadsheet and select the specific cells you want users to edit.
2. Unlock Selected Cells: Right-click the selection and choose 'Format Cells'. Go to the Protection tab and uncheck the 'Locked' option.
3. Protect the Sheet: Go to the Review tab on the top ribbon and click 'Protect Sheet'.
4. Set a Password: Enter your desired password and confirm it to secure the rest of the document while keeping your selected cells editable.

Free and lightweight office suiteFully compatible with Microsoft Excel (.xlsx) formatsIntuitive cell formatting and protection toolsSecure your business data with customizable password protection

Frequently Asked Questions

Why does locking cells not take effect immediately?

In Excel, the 'Locked' property of a cell is inactive by default. It only takes effect once you enforce it by enabling the 'Protect Sheet' feature from the Review or Home tab.

Can I unlock multiple non-adjacent cells at the same time?

Yes, you can hold down the Ctrl key while clicking or dragging to select multiple non-adjacent cells or ranges, and then unlock them all at once before protecting the sheet.

Is it possible to let multiple users edit different specific ranges with different passwords?

Yes, Excel has a feature called 'Allow Users to Edit Ranges' located under the Review tab. This allows you to set specific passwords for different cell ranges before you protect the entire worksheet.

Why is the 'Lock Cell' option greyed out?

The 'Lock Cell' option is usually greyed out if the worksheet is currently protected. You must unprotect the worksheet first from the Review tab before you can change any cell's locked status.

Document & File Issues