How to Lock Cells in Excel: The Complete Guide

If you’ve ever shared a spreadsheet with a colleague, only to discover later that a critical formula got accidentally overwritten, you already understand why locking cells in Excel matters. Whether you’re protecting a formula-heavy budget template, preventing accidental edits to a shared team tracker, or simply making sure certain reference data stays untouched, Excel’s cell locking feature gives you fine-grained control over exactly what can and cannot be edited in your workbook.

In this guide, we’ll walk through everything you need to know about locking cells in Excel, from the basic process of locking specific cells while leaving others editable, to protecting entire worksheets and workbooks, setting passwords, and allowing selective editing for certain users. We’ll cover both Excel for Windows and Excel for Mac, along with a look at how Google Sheets handles similar protection features if you’re working across platforms.

Understanding How Cell Locking Actually Works in Excel

Before diving into the steps, there’s an important concept to understand: by default, every single cell in an Excel worksheet is already set to “locked.” However, this locked status has no actual effect until you turn on worksheet protection. In other words, locking cells is a two-step process: first, you decide which cells should be locked or unlocked, and second, you activate protection on the worksheet itself, which is when the locking actually takes effect.

This two-step system is what makes Excel’s protection feature so flexible. You can unlock specific cells, like input fields, while leaving the rest of your formulas and formatting locked, then apply protection so only those unlocked cells remain editable.

Step 1: Unlock the Cells You Want to Remain Editable

Since every cell starts out locked by default, your first move should be identifying which specific cells you actually want users to be able to edit once protection is turned on.

1. Select the cell or range of cells you want to remain editable (for example, input fields where users will enter data).
2. Right-click the selection and choose Format Cells, or press Ctrl + 1.
3. Go to the Protection tab in the Format Cells dialog box.
4. Uncheck the Locked checkbox.
5. Click OK.

At this point, nothing has actually changed yet in terms of what users can edit, since protection hasn’t been applied. This step simply marks these specific cells as exceptions once protection is turned on.

Step 2: Protect the Worksheet

Once you’ve marked your editable cells as unlocked, the next step is to activate protection on the worksheet, which locks everything except the cells you specifically unlocked.

1. Click Protect Sheet.
2. A dialog box will appear. Optionally, enter a password if you want to prevent others from removing protection without your permission.
3. Choose which actions you want to allow users to perform even with protection enabled, such as selecting unlocked cells, formatting cells, inserting rows, or sorting data.
4. Click OK. If you entered a password, you’ll be asked to re-enter it to confirm.

Once this is done, any cell still marked as “Locked” will be fully protected from editing, while any cell you unlocked in Step 1 remains freely editable.

Lock All Cells in Worksheet

If your goal is simply to prevent any editing at all, without leaving specific cells open, you can skip the unlocking step entirely.

1. Go to the Review tab.
2. Click Protect Sheet.
3. Optionally set a password.
4. Click OK.

Since every cell is locked by default, this immediately locks the entire worksheet without needing to adjust individual cell settings first.

How to Lock Specific Cells While Leaving Others Unlocked

This is the most common real-world use case, protecting formulas or reference data while allowing users to fill in specific input fields.

1. Press Ctrl + A to select the entire worksheet.
2. Open Format Cells (Ctrl + 1), go to the Protection tab, and ensure Locked is checked for the entire sheet (this is usually the default, but it’s worth confirming, especially in workbooks that have been edited by multiple people).
3. Now select only the specific cells you want to remain editable, such as input fields or a data entry section.
4. Open Format Cells again, go to the Protection tab, and uncheck Locked for just this selection.
5. Go to the Review tab and click Protect Sheet to activate protection.

This approach ensures your formulas, headers, and reference data stay untouched, while designated input areas remain fully editable for anyone using the spreadsheet.

How to Add a Password to Protect Your Worksheet

Adding a password ensures that only people who know it can remove protection and make changes to locked cells.

1. Go to Review > Protect Sheet.
2. Enter your desired password in the Password to unprotect sheet field.
3. Click OK, then re-enter the same password when prompted to confirm it.
4. Save your workbook to ensure the password protection is preserved.

Keep in mind that Excel’s worksheet-level password protection, while useful for preventing accidental edits from colleagues, is not designed as a robust security measure against someone determined to bypass it. For genuinely sensitive data, consider workbook-level encryption (covered below) in addition to worksheet protection.

How to Protect an Entire Workbook’s Structure

Beyond protecting individual worksheets, you can also protect the overall structure of your workbook, preventing users from adding, deleting, renaming, or rearranging sheets.

1. Go to the Review tab.
2. Click Protect Workbook.
3. Optionally enter a password.
4. Click OK.

This is particularly useful for multi-sheet templates or reports where you want to prevent someone from accidentally deleting an entire tab or reordering sheets in a way that breaks internal formula references.

How to Encrypt an Entire Workbook with a Password

If you need to prevent anyone without a password from even opening the file at all, Excel offers a separate, more robust encryption option.

1. Go to File > Info.
2. Click Protect Workbook.
3. Select Encrypt with Password.
4. Enter your password, click OK, then confirm it by entering it again.
5. Save the file.

This is a much stronger form of protection than worksheet-level locking, since it requires the correct password just to open the file, rather than only restricting editing after it’s already open.

How to Lock Cells in Excel for Mac

The process on Excel for Mac closely mirrors Windows, with only minor interface differences.

1. Select the cells you want to remain editable, then press Cmd + 1 to open Format Cells.
2. Click OK.
3. Go to the Review tab and click Protect Sheet.
4. Optionally set a password, then click OK.

Workbook structure protection and file encryption are also available under similar menu paths, accessible through Review > Protect Workbook and File > Passwords respectively.

How to Allow Specific Users to Edit Certain Ranges

For shared workbooks used by multiple people, Excel offers a more advanced feature that allows different users to edit specific ranges, even while the rest of the sheet remains protected.

1. Go to the Review tab.
2. Click Allow Edit Ranges (found under Protect Sheet options in some Excel versions).
3. Click New to define a range.
4. Give the range a title, select the specific cells it applies to, and optionally set a password specifically for that range.
5. Click OK, then repeat for any additional ranges you want to define separately.
6. Finally, click Protect Sheet to activate protection across the entire worksheet, with your defined ranges available for editing based on their individual permissions.

This feature is especially useful in collaborative environments where different team members are responsible for filling in different sections of the same shared spreadsheet.

How to Lock Cells in Google Sheets (Free Alternative)

If you’re collaborating with someone using Google Sheets instead of Excel, the protection process works a bit differently but achieves a similar result.

1. Select the range or entire sheet you want to protect.
2. Add a description if you’d like, then click Set permissions.
3. Choose whether to restrict editing to yourself only, or to specific people you select.
4. Click Done.

Google Sheets is completely free with a Google account and offers a similar level of control, though it’s built around Google’s sharing permissions system rather than Excel’s password-based protection model.

Pro Tips for Locking Cells Effectively

• Always test your protection settings before sharing a workbook. Try editing a supposedly unlocked cell yourself first to confirm it behaves as expected, since it’s easy to accidentally leave a cell locked or unlocked due to a missed selection step.
• Use cell formatting to visually distinguish editable areas. Applying a light background color to unlocked input cells helps users immediately recognize where they’re supposed to enter data, reducing confusion and support questions.
• Combine worksheet protection with data validation. Locking cells prevents accidental overwrites, but pairing it with data validation rules (Data tab > Data Validation) ensures that even in unlocked cells, users can only enter values within an expected range or format.
• Don’t rely solely on worksheet passwords for sensitive data. If you’re protecting truly confidential information, use full workbook encryption (File > Info > Protect Workbook > Encrypt with Password) in addition to cell-level locking.
• Document your password somewhere secure. It’s surprisingly common to lock a sheet, forget the password months later, and be unable to make necessary edits. Password managers or a secure internal document are safer than relying on memory alone.
• Use Allow Edit Ranges for team templates. If multiple people need to fill in different sections of the same shared file, defining specific editable ranges per person avoids the common problem of one person accidentally overwriting another’s work.

Troubleshooting Common Cell Locking Issues

Problem: I unlocked cells, but they’re still not editable after protecting the sheet. Double-check that you actually selected the correct range before unchecking Locked in Format Cells. It’s a common mistake to unlock the wrong cells, or to accidentally re-select the entire sheet afterward and overwrite your changes before applying protection.

Problem: Protect Sheet is greyed out or unavailable. Check under Review > Protect Workbook to confirm whether workbook-level protection is interfering with sheet-level options.

Problem: Users can still see formulas even though cells are locked. As mentioned earlier, Locked and Hidden are two separate settings. If you only checked Locked, formulas remain fully visible in the formula bar when a cell is selected. You’ll need to also enable Hidden under the same Protection tab for formulas to stay concealed.

Problem: I protected the sheet, but formatting options I expected to allow aren’t working. Review the checkbox list inside the Protect Sheet dialog box carefully, since actions like formatting cells, inserting rows, or sorting are all individually toggled. If you didn’t specifically check the box for an action, it will remain restricted even with protection enabled.

When to Use Cell Locking vs Other Protection Methods

Cell locking isn’t always the right tool for every situation, so it’s worth understanding when a different approach might serve you better.

• Use cell locking when you want to prevent accidental edits to formulas or reference data while still allowing specific input fields to remain open, such as budget templates, invoice generators, or team trackers.
• Use workbook encryption when the concern is unauthorized access to the file itself, rather than accidental edits by people who already have legitimate access.
• Use Allow Edit Ranges when multiple people need different levels of access to different sections of the same shared spreadsheet.
• Use data validation alongside locking when you want to control not just whether a cell can be edited, but what kind of data can be entered into it once it’s unlocked.
• Forgetting to unlock cells before protecting the sheet. Since every cell is locked by default, skipping the unlock step means the entire sheet becomes uneditable, including areas you actually wanted to remain open for input.
• Assuming locked cells are hidden as well. Locking a cell only prevents editing; it doesn’t hide the cell’s contents or formulas. If you need to hide formulas from view entirely, check the Hidden checkbox alongside Locked in the Format Cells Protection tab, then apply Protect Sheet.
• Using a weak or easily guessable password. Since Excel’s worksheet-level protection isn’t designed for high-security scenarios, using a simple password provides only basic deterrence, not robust security, especially for genuinely sensitive information.
• Not testing protection across different Excel versions. Some protection options behave slightly differently between older Excel versions and the current Microsoft 365 version, so it’s worth double-checking behavior if your recipients are using an older version of the software.
• Losing the password with no backup plan. Excel doesn’t offer an official password recovery process for worksheet protection, so losing your password can mean permanently losing the ability to edit your own locked cells.

Conclusion

Locking cells in Excel is a straightforward but powerful way to protect your formulas, formatting, and reference data from accidental edits, whether you’re sharing a template with your team or building a form-style spreadsheet for others to fill in. The core process, unlocking specific cells first, then applying Protect Sheet, gives you precise control over exactly what stays fixed and what remains open for input.

From there, additional features like workbook structure protection, full file encryption, and Allow Edit Ranges give you even more flexibility for collaborative or sensitive projects. Whether you’re working in Excel for Windows, Excel for Mac, or using Google Sheets as a free alternative, the underlying goal is the same: making sure the right people can edit the right parts of your spreadsheet, without risking damage to the parts that need to stay exactly as you built them.

Frequently Asked Questions

1. Does locking a cell also hide its formula from view? No, locking only prevents editing. To hide a cell’s formula from being visible in the formula bar, you need to also check the Hidden option in the Format Cells Protection tab, in addition to Locked, before applying Protect Sheet.

2. Can I lock cells without setting a password? Yes, a password is entirely optional when protecting a sheet. Without one, the protection still prevents accidental edits, but anyone can remove it by clicking Unprotect Sheet, since there’s no password barrier.

3. What happens if I forget my worksheet protection password? Excel doesn’t offer an official built-in password recovery tool for worksheet protection, so losing your password can make it difficult to edit your own locked cells without third-party recovery software or rebuilding the sheet from scratch.

4. Can I lock an entire column instead of individual cells? Yes, select the entire column by clicking its header, then follow the same Format Cells > Protection process to lock or unlock it before applying Protect Sheet.

5. Will locked cells prevent someone from copying the data, even if they can’t edit it? By default, locked cells can still be selected and copied unless you specifically disable “Select locked cells” in the Protect Sheet options, which would prevent users from even clicking on those cells at all.

6. Is there a difference between protecting a sheet and protecting a workbook? Yes. Protecting a sheet controls editing permissions within that specific worksheet’s cells, while protecting a workbook controls the overall structure, preventing users from adding, deleting, or rearranging entire sheets.

7. Can different people have different editing permissions on the same sheet? Yes, using the Allow Edit Ranges feature, you can define specific ranges with individual passwords or permissions, allowing different team members to edit only their designated sections while the rest of the sheet remains locked.

8. Do I need Microsoft 365 to use cell locking, or does it work with a one-time Excel purchase? Cell locking and worksheet protection are available in both subscription-based Microsoft 365 plans (starting around $70 USD/year, approximately ₹6,000/year) and one-time purchase versions of Excel, since this feature has been a core part of Excel for many years across nearly all modern versions.