How to Protect an Excel Sheet Without Locking Everything

To protect an Excel sheet in Microsoft 365 for Windows, unlock any cells people should be able to change, then choose Review > Protect Sheet and set the permissions. A sheet password can help prevent accidental edits, but it is not a substitute for secure file storage or encryption. Decide first which cells should remain editable, and keep a safe record of any password you set.

What You’ll Need

An Excel workbook saved in a format that supports sheet protection, such as .xlsx.
A clear idea of which cells users may edit and which actions they should be allowed to perform.
An optional password. If you use one, store it somewhere secure; Excel cannot retrieve a forgotten sheet-protection password for you.

Step-by-Step

Open the worksheet and identify the editable areas. Select the sheet tab you want to protect. Make a note of the cells users need to update, such as input fields, a comments column, or a monthly totals area. Protection is applied to the active sheet only, so repeat these steps for each worksheet that needs its own protection. If users should be able to edit different areas under different passwords, review the Allow Users to Edit Ranges feature before protecting the sheet; it may not be available in every Excel edition or managed environment.
Unlock the cells people are allowed to change. Select the intended cells. To select separate ranges, hold Ctrl while selecting each range on Windows; on Mac, use Command while selecting. Open Format Cells with Ctrl+1 on Windows or Command+1 on Mac. On the Protection tab, clear the Locked checkbox and choose OK. You can also right-click the selection and choose Format Cells. The Locked setting is usually enabled for cells by default, but it has no effect until you turn on sheet protection. If the sheet is already protected, unprotect it before changing cell locking.
Check the rest of the sheet’s locking settings. Cells you did not unlock will remain locked when protection is enabled. If you want only a few inputs to be editable, that is usually the right arrangement. To verify a cell, select it and open Format Cells > Protection; a checked Locked box means the cell will be protected once the sheet is protected. Be careful with selecting the entire worksheet and clearing Locked: that would make every cell editable after protection, defeating the main purpose.
Open the protection controls. On the Windows ribbon, choose Review > Protect Sheet. In the Protect Sheet dialog, make sure Protect worksheet and contents of locked cells is selected. The wording and dialog layout can vary slightly by update. In Excel for Mac, use Review > Protect Sheet; the dialog and available options may differ. Excel for the web has its own Review protection controls, and some advanced options may require opening the workbook in the desktop app.
Choose whether to use a password. You can leave the password field blank to make protection easy to turn off, or enter a password to restrict who can remove protection. A password is useful for discouraging routine edits, but worksheet protection is not strong encryption and should not be treated as a way to secure confidential data. If you set a password, record it in a password manager or another safe place before continuing. Avoid using a password that is essential to access other accounts.
Allow only the actions users need. The dialog contains a list of actions that can remain available on a protected sheet. For example, selecting locked cells, selecting unlocked cells, formatting cells, inserting rows, sorting, or using AutoFilter may be controlled by checkboxes. Leave the ability to select unlocked cells enabled if people need to enter data. Enable other actions only when they are part of the workflow. If users need to sort or filter, set that permission deliberately and test it; protection can restrict operations involving locked cells or ranges.
Apply protection and confirm the password if prompted. Choose OK. If you entered a password, type it again in the confirmation prompt and choose OK. The sheet is now protected. Try entering a value into an unlocked input cell, then try changing a locked formula or heading. The first action should work; the second should be blocked. Testing immediately makes it easier to catch a mistaken selection or permission before sharing the file.
Save the workbook and test the actual workflow. Save the file, then check the protected sheet as the intended user would: enter data, move between input cells, and use any allowed filters or formatting. If the workbook will be shared, use a copy or a suitable test account so you do not overwrite important data. Protection is attached to the sheet, not the workbook as a whole, so check every sheet that should be protected and consider separately whether users should be able to add, delete, rename, or move sheets.

Common Mistakes

Protecting the sheet before unlocking input cells. Since cells are generally marked Locked by default, turning on protection without first unlocking intended input cells can make the whole worksheet appear read-only. Unprotect the sheet, unlock the right cells through Format Cells > Protection, and protect it again.

Unlocking the wrong range. It is easy to select an entire column, a hidden range, or the wrong worksheet tab. Before applying protection, click a few input cells and confirm Locked is cleared, then check a formula or heading cell to confirm it remains locked. A quick test after protection is more reliable than assuming the selection was correct.

Confusing sheet protection with file security. Protect Sheet helps control editing within a worksheet; it does not encrypt the contents or stop someone from accessing a copy of the file. For confidential information, use appropriate access controls and file encryption, and do not rely on sheet protection as the only safeguard.

Forgetting the password or restricting useful actions. A forgotten sheet password can leave you unable to remove protection through normal Excel controls. Also, leaving options such as selecting unlocked cells disabled can make a form awkward to use. Keep a password record and test with the same actions users will need.

Assuming one protected sheet protects the whole workbook. Each worksheet has its own protection settings. Sheet protection also does not prevent users from changing workbook structure unless you separately protect the workbook structure. Check the exact protection goal rather than relying on one command to cover every risk.

Tips

Make editable cells obvious. Use a consistent fill color, add a short instruction near the input area, or label fields clearly. If users need to enter information in a large sheet, consider applying data validation to input cells so entries follow the expected format. Protection and validation do different jobs: protection controls whether a cell can be changed, while validation can guide or limit the value entered.

Keep formulas and important labels locked, and unlock only the cells that need input. For a reusable form, set up and test the unlocked ranges before distributing a clean copy. If formulas refer to input cells, try a few realistic entries and check that calculated results still update when the sheet is protected.

Choose permissions with the user experience in mind. If users need to use filters, apply AutoFilter before protection and enable the relevant filter permission in the protection dialog. If they need to format cells or insert rows, allow those actions only when necessary. Permissions do not guarantee every operation will work in every layout, particularly when a requested action affects protected cells, so test the actual worksheet.

Use a descriptive file name and keep an unprotected master copy in a secure location if your workflow calls for one. Limit access to that master copy. When you change the sheet layout later, revisit the protection settings: inserted cells, new formula areas, or expanded input ranges may not have the locking behavior you intended.

Troubleshooting

I cannot edit a cell I should be able to change. Confirm that you are on the correct sheet and that the sheet is protected rather than the workbook being read-only. If you can unprotect it, select the cell, open Format Cells > Protection, and clear Locked. Then protect the sheet again. Also check that the cell is not part of a merged range or an area with other constraints that affect selection.

I can edit a formula or heading that should be protected. Unprotect the worksheet and inspect the cell’s Locked setting. If it is unchecked, select the cell or range and enable Locked in Format Cells > Protection. Reapply protection and test the cell. Remember that Locked does not take effect until the sheet is protected.

The Protect Sheet command is unavailable or I cannot change the settings. Check whether the workbook is opened in read-only mode, whether you have permission to edit it, or whether the file is being managed by an organization. A shared or co-authored workbook may also affect which protection changes are available. Save an editable copy if you are authorized to do so, or ask the file owner to change the settings. In Excel for the web, open the workbook in the desktop app if the options you need are not shown.

I cannot sort or filter after protection. Unprotect the sheet, confirm the filter is set up as intended, and review the actions allowed in Review > Protect Sheet. Enable the needed sorting or AutoFilter permission, reapply protection, and try again. If the operation still fails, check whether it would change or move locked cells.

I forgot the sheet password. Excel does not provide a normal password-recovery option for removing worksheet protection. Check your password manager, documentation, or the person who set up the workbook. If you have an unprotected backup, restore from it. Avoid relying on unverified recovery tools, especially with sensitive files.

Frequently Asked Questions

Does protecting an Excel sheet prevent people from viewing its data?
No. Sheet protection is mainly intended to restrict editing, not hide information. Do not put confidential data in a worksheet and assume a sheet password makes it private.

Can I protect a sheet but leave some cells editable?
Yes. Before enabling protection, select the cells users may change, open Format Cells > Protection, and clear Locked. Then protect the sheet. Locked cells are restricted; unlocked cells remain available, subject to the permissions you choose.

Does the password have to be strong?
Use a password you can store and retrieve safely, but understand its purpose: it deters ordinary changes to the sheet rather than encrypting the workbook. Use file encryption and appropriate access controls when you need to protect sensitive information.

Can I protect only formulas and leave the rest editable?
Yes, but you need to arrange the cell locking deliberately. Keep formula cells locked, unlock the cells intended for input, and then protect the sheet. Because cells are generally Locked by default, it is often simpler to unlock input cells rather than unlock everything and relock formulas.

Is protecting a sheet the same as protecting workbook structure?
No. Protect Sheet controls actions on one worksheet. Protect Workbook can restrict structural changes such as adding, deleting, moving, or renaming sheets. Use the relevant workbook-level control if those changes also need to be limited.

Can I remove protection later?
Choose Review > Unprotect Sheet and enter the password if one was set. On Mac, use the corresponding Review protection command. You can then change cell locking or permissions and protect the sheet again.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.