Yes. In Excel for Microsoft 365 on Windows, select the worksheet tab, go to Review > Protect Sheet, choose what users may do, and set a password if you want one. This protects worksheet actions, not the information from being viewed; for stronger confidentiality, encrypt the workbook file with a password instead.
What “protecting a tab” means in Excel
Excel calls each tab at the bottom of a workbook a worksheet. You can protect worksheets individually, so protecting one tab does not automatically protect every other sheet. Worksheet protection is mainly an editing control: it can stop users from changing locked cells, deleting formulas, or carrying out other actions you disallow.
It helps to distinguish three different controls that people often call “password protecting a tab”:
- Protect Sheet: Restricts changes and selected actions on one worksheet. A password is optional.
- Protect Workbook structure: Restricts changes to the workbook’s sheet tabs, such as adding, deleting, renaming, moving, or hiding sheets. It does not encrypt worksheet contents.
- Encrypt with Password: Requires a password to open the workbook file. This is the relevant choice when you need to keep the file’s contents confidential.
These options solve different problems. For example, you might protect a formula sheet from accidental edits while leaving the workbook readable, or encrypt the entire file before sending sensitive data to someone.
How to password-protect one worksheet
In Excel for Microsoft 365 on Windows, use these steps for the tab you want to protect:
- Select the worksheet tab at the bottom of the workbook.
- Open the Review tab and select Protect Sheet.
- In the dialog, keep Protect worksheet and contents of locked cells selected. Enter a password if you want Excel to require one when protection is removed.
- Choose the actions users should still be allowed to perform, such as selecting cells or sorting, then select OK.
- If you entered a password, type it again when Excel asks you to confirm it.
The permitted actions matter. If users need to filter a table, insert rows, or format cells, check whether the corresponding permission is enabled before you protect the sheet. Excel’s defaults allow selecting locked and unlocked cells, but generally block editing locked cells and other restricted actions. You can remove protection later from Review > Unprotect Sheet; Excel asks for the password if one was set.
On Mac, the sheet protection command is also on the Review tab, though dialog details can vary by version. Excel for the web has a more limited set of protection and file-security features than the desktop app. If you need to set a password or use a particular protection option and cannot find it online, open the workbook in desktop Excel.
Let people edit selected cells
A common setup is to lock formulas and headings while leaving input cells editable. By default, Excel marks cells as locked, but that setting does not take effect until you protect the worksheet. So first unlock the cells that users should be able to change, and then protect the sheet.
- Select the cells users may edit. To select separate ranges, hold Ctrl while selecting them on Windows.
- Press Ctrl+1 to open Format Cells. On Mac, use Command+1.
- Open the Protection tab, clear Locked, and select OK.
- Go to Review > Protect Sheet and set the allowed actions and optional password.
For example, a monthly expense sheet might contain locked category labels and total formulas, with unlocked cells for employees to enter dates and amounts. Protecting the sheet after unlocking those entry cells helps prevent accidental changes to the calculation, while still allowing data entry. It does not hide the formulas or stop someone from reading the figures.
Protect the workbook’s sheet tabs
If your concern is that someone might rename, delete, move, hide, or add tabs, use workbook structure protection as well as—or instead of—Protect Sheet. In Excel for Microsoft 365 on Windows, select Review > Protect Workbook, select the option for Structure in the dialog, enter a password if desired, and confirm it.
This setting applies to the workbook’s structure rather than the cells on an individual worksheet. It can be useful when a report depends on a fixed set of tabs, such as Summary, January, February, and March, and you want to prevent casual changes to that layout. It does not prevent someone from reading the sheets, nor does it necessarily prevent edits to unprotected cells. Use Protect Sheet separately if you also need to restrict worksheet editing.
When to encrypt the Excel file instead
Worksheet protection is not a substitute for file encryption. If a person should not be able to open or read the workbook at all, use Excel’s file-level password feature. In Excel for Microsoft 365 on Windows, go to File > Info > Protect Workbook > Encrypt with Password, enter a password, and confirm it. Save the workbook so the setting is applied.
With file encryption, the password is required to open the workbook, rather than merely to remove a worksheet restriction. This is generally the more appropriate choice for confidential content, such as personnel information or private financial records. Share the password through a separate, reasonably secure channel instead of putting it in the same email as the file.
Be careful to record the password securely. If you forget the password used to encrypt a workbook, Microsoft cannot retrieve it for you. The exact options and wording can differ in Excel for Mac, but use the workbook’s password or encryption settings—not only sheet protection—when the goal is to require a password before opening the file. Excel for the web does not provide all the desktop app’s encryption controls.
How to choose the right protection
Choose the control according to what you want to prevent. The simplest decision is whether the user may still see the data:
- Prevent accidental formula edits: Unlock intended input cells, then use Protect Sheet.
- Keep the tab layout from being changed: Protect Workbook structure.
- Require a password before anyone can view the workbook: Encrypt the file with a password.
- Share a file with different people who need different access: Consider storing it in a service with managed permissions, rather than relying only on worksheet protection.
You can combine these controls. For instance, a workbook can be encrypted to restrict opening, have its structure protected to preserve the tab layout, and have selected sheets protected to reduce accidental changes. Each setting has a separate purpose, so test the finished file using a copy and the level of access its intended users will have.
Limits and common problems
The most important limitation is that Protect Sheet is designed to control editing, not to provide strong security for confidential data. A protected sheet’s contents remain part of the workbook and can still be viewed by someone who can open the file. Sheet protection should not be treated as a way to conceal data or as a robust barrier against a determined user. Use file encryption or appropriate access controls when confidentiality matters.
Another frequent surprise is that users cannot type into cells after protection is turned on. This usually happens because those cells are still marked Locked. Unlock the intended input cells before protecting the sheet. Conversely, if formulas remain editable, check that their cells are locked and that sheet protection is active.
If Excel rejects a password when you try to unprotect a sheet, check capitalization and the keyboard layout; passwords are case-sensitive. Also confirm that you are unprotecting the correct worksheet. A password for one sheet is not automatically the password for every other sheet or for opening the workbook. If the password is lost, there is no supported password-recovery process that guarantees access to a protected sheet; for encrypted files, losing the opening password can make the contents inaccessible. Keep an authorized unprotected backup where appropriate.
Frequently Asked Questions
Can I password-protect just one tab in Excel?
Yes. Select that worksheet and use Review > Protect Sheet. Other tabs are unaffected unless you protect them too. Remember that this restricts worksheet actions; it does not hide the sheet’s contents from someone who can open the workbook.
Can someone still see a protected Excel sheet?
Yes. Protect Sheet is primarily an editing restriction. If the workbook opens normally, a user can generally view the protected sheet and its contents. Use Encrypt with Password if the workbook should require a password to open.
How do I let someone edit certain cells on a protected sheet?
Select those cells, open Format Cells with Ctrl+1 on Windows or Command+1 on Mac, and clear Locked on the Protection tab. Then protect the worksheet. Other locked cells remain restricted.
Is Protect Workbook the same as Protect Sheet?
No. Protect Sheet controls actions on a worksheet, while workbook structure protection restricts changes to sheet tabs, such as renaming or deleting them. Neither one encrypts the workbook so that a password is required to open it.
What if I forget the worksheet password?
Excel does not provide a supported way to recover a forgotten sheet-protection password. For an encrypted workbook, a forgotten opening password can prevent access to the file’s contents. Keep passwords in a secure password manager and retain an authorized backup when appropriate.
Related
- Free Budget Tracker Excel Template: Setup and Tips
- Budget Template NZ Excel: Build a Practical Household Plan
- Budget and Expense Tracking Excel Template: How to Use It
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Google Sheets IF Else: How to Write Conditional FormulasGoogle Sheets does not have a separate ELSE keyword; use the IF function to test a condition and…
- Excel Column Width: Units, Pixels, and How to Set ItExcel column width is measured in character-based units, not directly in inches or pixels. One unit is based…
- Delete a Page in Word After a Page Break: Step-by-StepTo delete a blank page after a page break in Word, show formatting marks, find the page break…
- Create Rules in Outlook to Move Emails AutomaticallyTo move Outlook emails automatically, create a rule that matches a condition—such as the sender or words in…
- Create a PowerPoint Template From an Existing PresentationYes. In PowerPoint for Microsoft 365 on Windows, open a copy of the presentation, choose File > Save…
- Excel Sharing Violation: Causes and FixesAn Excel sharing violation usually means Excel cannot save to the workbook because another user, program, or file-system…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.