In Excel for Microsoft 365 on Windows, open the worksheet, choose Review > Protect Sheet, select which actions people may perform, and optionally enter a password. To keep designated cells editable, unlock them first through Format Cells > Protection, then protect the sheet.
What sheet protection does
Protect Sheet is a way to prevent accidental changes to parts of a worksheet. It works with each cell’s Locked setting: cells are generally marked as locked by default, but that setting has no effect until you protect the sheet. Once protection is on, users cannot change locked cells through normal editing, while unlocked cells remain available for data entry.
This makes protection useful for templates and shared workbooks. For example, a team may need to enter quantities in a prepared order form without changing product descriptions, formulas, or formatting. You can leave the quantity and notes cells unlocked, protect the sheet, and allow people to select unlocked cells.
Protection is not a substitute for secure access control. It is intended to discourage or prevent ordinary editing, not to encrypt workbook contents or guarantee that information cannot be copied or accessed. Use file encryption and appropriate sharing permissions when confidentiality matters.
Protect a worksheet step by step
For a typical worksheet, apply protection after deciding which cells should remain editable. In Excel for Microsoft 365 on Windows:
- Open the worksheet you want to protect. Protection applies to the current sheet, not automatically to every sheet in the workbook.
- If users need to edit particular cells, select those cells and unlock them before continuing. The next section explains how.
- Go to Review > Protect Sheet.
- In the Protect Sheet dialog, confirm that Protect worksheet and contents of locked cells is selected.
- Choose the actions users should be allowed to perform, such as selecting locked or unlocked cells, formatting cells, or using AutoFilter.
- Enter a password if you want to require one to turn protection off, then select OK. Excel asks you to enter the password again to confirm it.
A password is optional. If you leave it blank, users can turn off protection without entering one. If you set one, record it somewhere appropriate: Excel does not provide a normal way to recover a forgotten sheet-protection password.
To protect another worksheet, activate it and repeat the steps. If a workbook has several sheets, check each one individually rather than assuming the first protection action covers them all.
Leave input cells editable
Unlock intended input cells before protecting the sheet. Select a cell or range, press Ctrl+1 on Windows to open Format Cells, and choose the Protection tab. Clear the Locked checkbox and select OK. The cells will still look the same; the change becomes meaningful when sheet protection is enabled.
On a Mac, select the cells and press Command+1 to open Format Cells. The dialog’s Protection tab contains the Locked setting as well. The exact appearance of the ribbon and dialog can vary slightly by Excel version, but the underlying sequence is the same: clear Locked for the entry cells, then use Review > Protect Sheet.
For example, suppose a form has customer names in A2:A20, formulas calculating totals in D2:D20, and blank quantity fields in C2:C20. Leave the formula cells locked, unlock C2:C20, and protect the sheet. People can then enter quantities without overwriting the calculations. If users also need to add rows or edit notes, unlock those specific cells too.
You can select multiple non-adjacent ranges by holding Ctrl while selecting them on Windows, then change the Locked setting for the selection. On Mac, use Command while selecting separate ranges. Before protection is applied, check the selection carefully: accidentally unlocking a formula range can make it editable to anyone who can edit the sheet.
Choose what users are allowed to do
The Protect Sheet dialog includes a list of permitted actions. The available choices let you tailor protection rather than treating every user as read-only. Options commonly include selecting locked or unlocked cells, formatting cells, columns or rows, inserting or deleting rows or columns, sorting, using AutoFilter, and using PivotTable reports. Some actions depend on the workbook contents and Excel version.
Allow only the actions people genuinely need. For a simple data-entry form, allowing selection of unlocked cells may be enough. If people need to filter a protected table, enable the AutoFilter permission; if they must change cell appearance, consider allowing formatting. Giving permission for an action does not necessarily make every locked cell editable. The specific permissions govern which operations can be carried out while protection is active.
Consider the workflow before enabling row or column changes. Inserting or deleting rows can affect formulas, references, or the layout of a carefully designed template. If users need to add records, an Excel table or a separate data-entry process may be more suitable than granting broad structural actions on a protected sheet.
Excel also has an Allow Edit Ranges feature on Windows, available from the Review tab in supported desktop versions. It can define ranges that particular users may edit, including ranges with their own passwords in some setups. This is different from simply unlocking cells for everyone. Availability and authentication options can vary by edition and organizational setup, so check the dialog in the Excel version being used.
Set or remove a protection password
When you create sheet protection, the password is used to remove or change that protection. It does not encrypt the worksheet, hide its contents, or protect the entire workbook from being opened. Someone who can open the file may still be able to view or copy data, depending on the workbook and sharing arrangements.
To remove protection when you know the password, select the protected sheet and choose Review > Unprotect Sheet. Enter the password if Excel prompts for it. You can then make changes, adjust the Locked settings, and protect the sheet again with the permissions you want.
Keep passwords accurate and available to authorized workbook owners. A forgotten sheet password can prevent normal editing of the protected sheet, and Microsoft does not offer a standard password-recovery command for it. Avoid putting the password in a note stored beside the workbook if that would defeat your access policy. If a password is lost, use an authorized backup or contact the workbook owner or administrator rather than assuming sheet protection is a recoverable security system.
Sheet protection, workbook protection, and encryption
These controls solve different problems. Protect Sheet controls editing on one worksheet. Protect Workbook, found on the Review tab, is generally used to protect workbook structure, such as preventing users from adding, deleting, hiding, or renaming sheets. It does not replace protection of the cells within each worksheet.
Password encryption is different again: it can require a password to open the file and is intended to protect access to the workbook’s contents. In Excel for Windows, file encryption is available through File > Info > Protect Workbook > Encrypt with Password. Menus can differ on Mac and in Excel for the web, so use the corresponding file-protection options in that edition. For sensitive files, combine suitable encryption with controlled storage and sharing permissions rather than relying on sheet protection alone.
A common misconception is that hiding a sheet makes it secure. Hiding changes whether a sheet is visible in the workbook interface; it does not provide confidentiality. Workbook-structure protection can restrict ordinary unhiding, but it is not a replacement for encrypting a file that contains private information.
Common problems and fixes
- Users cannot type in an intended input cell: Unprotect the sheet, select the cell, clear Locked in Format Cells > Protection, and protect the sheet again. Confirm that the cell was not accidentally left locked.
- Users can edit a formula they should not change: Check that the formula cell is marked Locked, then reapply sheet protection. Remember that Locked has no effect while the sheet is unprotected.
- Filtering or sorting is unavailable: Unprotect the sheet and review the permitted actions in Review > Protect Sheet. Enable the relevant option, then protect the sheet again. Some operations may still be constrained by the range or table setup.
- The password does not work: Check spelling, capitalization, keyboard layout, and whether the correct worksheet is selected. Sheet passwords are case-sensitive. Excel does not display the password as you type it.
- Only one tab is protected: Protection is applied separately to each worksheet. Repeat the setup for every sheet that needs it.
If a user can no longer edit an area after a workbook is changed, review both the cell’s Locked status and the sheet’s allowed actions. Protection problems often come from one of these two settings, rather than from a damaged workbook.
Excel for Mac and Excel for the web
In Excel for Mac, the core process is similar: use the Review tab to protect or unprotect the active worksheet, and use Format Cells to change whether selected cells are locked. The dialog layout and some permissions may differ from Windows. The common cell-format shortcut differs too: Ctrl+1 on Windows and Command+1 on Mac.
Excel for the web supports worksheet protection, but its interface and available protection settings may not match desktop Excel in every detail. If you need a particular permission, a range-based editing rule, or a more complete protection setup, open the workbook in the desktop application and verify the options there. A user may also encounter different behavior depending on whether they have editing access to the file through OneDrive or SharePoint; file-sharing permissions and sheet protection are separate controls.
Frequently Asked Questions
How do I protect an Excel sheet without a password?
Choose Review > Protect Sheet, select the actions to allow, and leave the password field blank. The sheet will be protected against normal editing, but someone can turn protection off without a password.
Can I protect a sheet but allow people to enter data?
Yes. Unlock the intended input cells through Format Cells > Protection before protecting the sheet. Leave formula and label cells locked, and allow selection of unlocked cells in the protection dialog.
Does protecting a sheet stop people from viewing the data?
No. Sheet protection limits ordinary editing; it is not file encryption or a confidentiality feature. Use file encryption and carefully managed sharing access when the contents must be kept private.
How do I unprotect an Excel sheet?
Select the sheet and choose Review > Unprotect Sheet. If protection has a password, enter it when prompted. Without the password, Excel does not provide a normal recovery option.
Can I protect all sheets in a workbook at once?
Sheet protection is applied separately to each worksheet, so protect each sheet that needs it. Workbook-structure protection is a separate option and does not automatically lock cells on every sheet.
Related
- Can You Merge Cells in Excel? Options and Limits
- Can You Group Rows in Excel? Steps and Tips
- How to Hide a Column in Excel and Unhide It Easily
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Shortcut Keys A to Z: What Each Letter MeansExcel does not assign a standard action to every Ctrl-plus-letter combination, but many of the most useful Windows…
- Out of Office in Outlook: Set Up Your Automatic ReplyTo set an out-of-office greeting in Outlook, open Automatic replies, switch them on, write your message, and—if available—set…
- Excel Insert Page Break Shortcut: Windows and MacIn Excel for Microsoft 365 on Windows, press Alt, P, B, I in sequence to insert a page…
- How to Mail Merge in Word for Personalized Email MessagesTo mail merge in Word for email, prepare a recipient list in Excel, connect it to a Word…
- Excel Time Format Without Seconds: How to Set ItTo show an Excel time without seconds, select the cells, press Ctrl+1 on Windows, choose Number > Custom,…
- Employee Schedule Template for Google Sheets: SetupAn employee schedule template in Google Sheets is a reusable spreadsheet for assigning shifts, tracking hours, and sharing…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.