To edit a cell on a protected Excel sheet, either enter data in a cell the sheet’s owner left unlocked, or remove protection with the password: in Excel for Microsoft 365 on Windows, go to Review > Unprotect Sheet and enter the password if prompted. To make selected cells editable while keeping the rest protected, unprotect the sheet, select those cells, clear the Locked setting in Format Cells, and protect the sheet again.
What protecting an Excel sheet does
Sheet protection is a way to limit changes to the contents and layout of a worksheet. It is useful when a workbook contains formulas, instructions, or carefully arranged tables that people should not accidentally overwrite. For example, a staff member might enter weekly figures in designated cells while formula cells calculate totals and remain locked.
Excel cells are marked as locked by default, but that setting does not prevent editing until sheet protection is turned on. Protect Sheet activates the locked setting and lets the person protecting the sheet choose some permitted actions. Unlocked cells remain available for editing, subject to the selected protection options.
Sheet protection is not the same as securing a file with encryption. It is primarily an editing safeguard, not a way to keep confidential information secret from someone who can open the workbook. If the goal is to prevent people from opening a file, use file-level encryption and manage access to the file itself.
Unprotect a sheet so you can edit it
If you know the password, removing sheet protection is straightforward in the desktop version of Excel for Windows:
- Open the worksheet you need to change.
- Select Review > Unprotect Sheet. In some Excel layouts, the command may be shown as Protect Sheet when the sheet is not protected.
- If Excel prompts for a password, enter it and confirm.
- Edit the cells or make other needed changes. If the worksheet should remain protected, turn protection back on afterward.
If no password was set, Excel generally removes protection without asking for one. A password prompt means the person who protected the sheet set a password; it is not the same as a password required to open the workbook. After editing, use Review > Protect Sheet to restore protection and choose which actions users may perform.
In Excel for Mac, use the Review tab and its sheet-protection command; the wording and layout can vary with the Excel version. Excel for the web also provides sheet-protection controls, but the available settings and interface can differ from the desktop app. If a setting you need is missing in the browser, open the workbook in desktop Excel if you have access to it.
Make only certain cells editable
A common setup is to protect formulas and headings but leave input cells open. For example, in a simple expense sheet, users might enter dates and amounts in columns A and B while formulas in column C calculate totals. The following setup allows input in A2:B50 while protecting the rest of the worksheet:
- If the sheet is already protected, first choose Review > Unprotect Sheet and supply the password if requested.
- Select the cells people should be able to edit, such as A2:B50.
- Open Format Cells. On Windows, press Ctrl+1 or use Home > Format > Format Cells. On Mac, press Command+1.
- Choose the Protection tab and clear the Locked checkbox. Select OK.
- Choose Review > Protect Sheet. Add a password if appropriate, then choose which actions users should be allowed to take.
- Confirm the protection settings. Test the sheet by entering a value in an unlocked cell and trying to change a locked formula cell.
The Locked checkbox controls whether a cell is protected when sheet protection is active. It does not lock the cell immediately. If you need to reopen only a few cells later, unprotect the sheet, change their Locked setting, and protect it again. Keep a record of any password you set; if you lose it, Excel does not provide a standard password-recovery process for sheet protection.
Choose what users can still do
When you protect a worksheet, Excel presents options that determine which actions remain available. The exact choices and their presentation can vary by version, but commonly include selecting locked or unlocked cells, formatting cells, inserting or deleting rows, sorting, using AutoFilter, and editing objects. Allow only the actions users genuinely need.
For an input form, you might allow users to select unlocked cells but not locked cells, so they can move between entry fields without selecting formulas. For a data table, sorting or using an existing filter may be necessary; protection settings can affect those tasks. Test the actual workflow after enabling protection, because a checkbox that sounds suitable may not permit every variation of an action that users expect.
Protection is not a substitute for validation or a carefully designed form. If users can type into an unlocked cell, they may enter an unexpected value unless you also guide or restrict input. Data Validation, clear labels, and instructions can reduce mistakes, while protection helps prevent accidental changes to locked areas.
Protection versus passwords and workbook structure
Excel has several protections with similar names, but they solve different problems:
- Protect Sheet restricts changes to a particular worksheet according to its locked cells and allowed actions.
- Protect Workbook structure restricts structural changes such as adding, deleting, moving, or renaming sheets. It does not, by itself, protect every cell’s contents.
- Encrypt with Password protects access to the workbook file by requiring a password to open it. This is the relevant choice when the contents should not be readable by someone without permission.
These options can be used for different purposes, and one does not automatically replace the others. A workbook can have protected sheets while its tabs remain rearrangeable, or have its structure protected while cells on a sheet remain editable. Choose protection based on the specific risk: accidental edits, unwanted sheet changes, or unauthorized access to the file.
Common reasons a protected cell will not edit
If you cannot change a cell, first check whether the sheet is protected and whether that particular cell is locked. A protected sheet can still contain editable cells, so the padlock-like behavior is not necessarily a problem with Excel. Select the cell and check the protection settings after unprotecting the sheet, if you have permission and the password.
- The wrong cell is unlocked. The input area may have shifted, or the cell you need may not have been included when the owner cleared Locked. Ask the workbook owner to unlock the correct range.
- You are selecting a locked cell by design. Some sheets allow selection of unlocked cells only. Try moving to an input field, or ask the owner to adjust the selection permissions.
- The workbook is read-only or opened in Protected View. This is separate from sheet protection. Check whether Excel shows a read-only status or a Protected View message and follow your organization’s safe process before enabling editing.
- You can edit a cell but cannot change its format or insert a row. Those actions may be disabled in the Protect Sheet options, even if the cell itself is unlocked.
- The sheet is protected by a password you do not have. Contact the file owner or administrator. Do not assume that a password to open the file is the same as the sheet-protection password.
- The command is unavailable in the browser. Some protection settings are easier to manage in desktop Excel. If permitted, open the workbook in the desktop app and check the Review tab.
Also check whether the file is shared through a document service with access restrictions. File permissions can stop you from editing even when the worksheet itself is unprotected. In that case, the file owner may need to grant edit access.
Forgotten passwords and safe alternatives
If you do not know the sheet password, ask the workbook creator, file owner, or IT administrator for access or an authorized unprotected copy. If the workbook is important, look for a previous version or backup that you are permitted to use. A version history may help if the file is stored in a service that keeps prior copies, although restoring an older version can also discard later changes.
Excel does not offer a standard command to recover a forgotten sheet-protection password. Be cautious about websites or utilities that promise guaranteed recovery: they may expose sensitive workbook data, install unwanted software, or violate workplace rules. If your task is legitimate, request the password or a corrected file rather than trying to defeat protection.
If you own the workbook and want to avoid blocking future maintenance, document what the protection is intended to prevent, store passwords in an approved password manager, and keep an unprotected backup in a secure location. A backup should have access controls appropriate to its contents; leaving an unrestricted copy in a shared folder can defeat the purpose of protecting the working file.
Frequently Asked Questions
Can I edit an Excel sheet without unprotecting it?
Yes. You can edit cells that were unlocked before the sheet was protected, provided the protection settings allow the action. Locked cells generally require the sheet to be unprotected before they can be changed.
Why does Excel say a cell is protected?
The worksheet is protected and the selected cell is locked, or the protection settings do not permit the action you are attempting. Ask the owner to unlock the cell or allow the needed action, or unprotect the sheet if you have authorization and the password.
Can I protect formulas but leave input cells editable?
Yes. Clear the Locked setting for the input cells in Format Cells, leave formula cells locked, and then turn on sheet protection. Test both types of cells after protecting the worksheet.
Does Protect Sheet encrypt my Excel file?
No. Sheet protection restricts worksheet editing; it is not file encryption. To require a password to open a workbook, use the file-encryption option in desktop Excel and store the password safely.
Can Microsoft recover a forgotten sheet password?
There is no standard Excel feature for recovering a forgotten sheet-protection password. Contact the workbook owner or administrator, or use an authorized backup or prior version.
Related
- Excel Power Query Append Queries: Combine Tables Easily
- Wedding Budget Spreadsheet UK: Build a Practical Tracker
- Excel Power Query Joins: How to Combine Tables Correctly
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Freeze Just One Row in ExcelTo keep the first row visible while you scroll in Excel, open View > Freeze Panes > Freeze…
- Project Tracker Spreadsheet Best Practices for TeamsFor a reliable project tracker spreadsheet, use one row per task, assign each task a stable ID and…
- Excel Shortcut to Move Between Sheets in a WorkbookIn Excel for Microsoft 365 on Windows, press Ctrl+Page Down to move to the next worksheet and Ctrl+Page…
- VLOOKUP Google Sheets Tutorial: Formulas, Examples & FixesIn Google Sheets, VLOOKUP searches the first column of a table and returns a value from a column…
- Remove Duplicates in Excel: Shortcut and Safe StepsIn Excel for Microsoft 365 on Windows, select a cell in your data and press Alt+A, then M…
- Excel Auto Merge Cells With the Same Value? Here’s HowNo—Excel for Microsoft 365 does not automatically merge cells just because they contain the same value. You can…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.