Yes. In Excel for Microsoft 365 on Windows, you can protect one worksheet tab without protecting the others: open that sheet, choose Review > Protect Sheet, and set the protection options. The sheet’s cells are marked as locked by default, but those locks take effect only after you turn on sheet protection.
What “locking a tab” means in Excel
Excel uses “lock” to describe two different things. You can protect the contents of an individual worksheet, or you can protect the workbook’s structure so people cannot change the sheet tabs themselves. These controls are separate, and you may use one or both.
Sheet protection applies to one worksheet at a time. If you protect the tab named Budget, the other sheets in the same workbook remain editable unless you protect them separately. This is useful when a sheet contains formulas, instructions, or a carefully arranged report, while other tabs are intended for data entry.
Worksheet protection does not mean that every cell becomes impossible to change in every circumstance. It enforces the locked or unlocked status of cells while protection is on, subject to the actions you allow in the protection options. This lets you keep formula cells protected while leaving designated input cells available.
How to protect just one worksheet
In Excel for Microsoft 365 on Windows, use the following steps. You do not need to select the worksheet’s cells first if you want to protect all of them.
- Click the sheet tab you want to protect. Confirm that it is the active worksheet.
- Open the Review tab and select Protect Sheet.
- In the dialog box, optionally enter a password. A password is not required to turn on sheet protection.
- Review the list of permitted actions. For example, you can allow users to select cells, format cells, or use AutoFilter.
- Click OK. If you entered a password, Excel asks you to confirm it.
Protection is now applied to that sheet only. Click another tab to check: it should remain editable unless it has its own protection. To remove protection later, return to the protected sheet and choose Review > Unprotect Sheet. If Excel asks for a password, enter the one used when protection was set.
On Excel for Mac, the same feature is on the Review tab as Protect Sheet, although the dialog and available controls can differ slightly by version. The Windows shortcut for Format Cells is Ctrl+1; on Mac, use Command+1. Excel for the web also supports worksheet protection, but some management options may be more limited than in the desktop app.
How to leave some cells editable
By default, Excel marks cells as locked, but that setting does nothing until you protect the sheet. To let people enter values in a few cells while keeping the rest protected, unlock those cells before applying protection:
- Select the cells people should be able to edit. To select separate ranges, hold Ctrl while selecting on Windows; on Mac, hold Command.
- Open Home > Format > Format Cells, or press Ctrl+1 on Windows (Command+1 on Mac).
- In the Format Cells dialog, open the Protection tab and clear Locked. Select OK.
- Protect the worksheet through Review > Protect Sheet.
For example, suppose a worksheet has product names in column A, formulas calculating totals in column D, and blank quantity-entry cells in column B. Leave the formula cells locked, unlock the intended quantity cells, and then protect the sheet. Users can enter quantities without casually overwriting the calculations. Be precise about the selected ranges: unlocking an entire column when only a few rows are intended for input gives users more editing access than necessary.
The Protect Sheet dialog lets you choose actions that remain available, such as selecting locked or unlocked cells. Options such as formatting, inserting rows, sorting, or using filters may be available as well. Only check the permissions people need. Some operations have practical limits when a protected range contains locked cells; for example, sorting may not work as expected if the cells in the sort range are protected.
Protecting the sheet tab itself
If by “lock a tab” you mean stop someone from renaming, deleting, moving, hiding, or adding worksheet tabs, Protect Sheet is not the control for that. Use workbook-structure protection instead. In desktop Excel for Windows, go to Review > Protect Workbook and enable protection for the workbook’s structure in the dialog. You can set a password, then confirm it.
Workbook-structure protection affects the workbook’s sheet organization, not just one tab. It can help preserve a fixed set of sheets, but it is not a way to make only one sheet’s contents read-only. You can combine structure protection with sheet protection: protect the structure to guard the tabs, and protect an individual sheet to guard its cells. If users need to add or rename tabs, do not enable structure protection unless that restriction is intentional.
Passwords, security, and what protection does not do
A password on a protected worksheet is intended to control changes through Excel’s sheet-protection feature. It should not be treated as strong confidentiality or file security. Worksheet protection does not encrypt the workbook’s contents, and it is not a dependable way to keep a determined person from accessing information in the file.
For sensitive information, do not rely on hiding a sheet or protecting its cells as a substitute for restricting access to the file. If the goal is to require a password to open the workbook, Excel has a separate file-encryption option: use File > Info > Protect Workbook > Encrypt with Password in desktop Excel for Windows. Store that password safely; losing access credentials can prevent you from opening the file. Also remember that anyone who can edit a workbook may be able to copy information they can view, even if they cannot edit the protected cells.
Use a worksheet password to prevent accidental edits or enforce simple editing boundaries, not as the only security measure for confidential data. If several people collaborate on the file, agree who should be able to change protected areas and keep a safe copy before changing protection settings.
Common problems and fixes
- Cells still seem editable. Check that sheet protection is actually on. Merely having the Locked box selected in Format Cells does not protect a sheet by itself.
- Users cannot type in intended input cells. Unprotect the sheet, select the input range, clear the Locked setting, and protect the sheet again.
- Users cannot format or filter. Unprotect the sheet and review the permitted actions in Protect Sheet. For filters, set up the AutoFilter before protecting the sheet and allow use of AutoFilter if that option is available.
- A tab can still be renamed or deleted. That is a workbook-structure issue. Protect the workbook structure separately if you need to prevent sheet-tab changes.
- You cannot remove protection. Excel may request the password used to protect the sheet. If you do not know it, seek the password from the workbook’s owner or administrator; do not assume Microsoft can recover it.
When preparing a shared template, test it as a normal user would: try entering values in the intended fields, changing a formula, filtering the table, and navigating between tabs. This can reveal a permission that is too restrictive or a range that was accidentally left unlocked.
When another approach may be better
Sheet protection is a good fit when the goal is to reduce accidental edits while allowing people to work in designated cells. For a reusable form, unlock only the entry fields and protect the sheet. For a workbook where users should not alter any tabs, add structure protection as well.
If people need different access rights—for example, one group may edit one sheet while another group may edit a different sheet—worksheet passwords are not a complete user-permission system. Consider separate files with appropriate sharing permissions, or a controlled data-entry process. Hiding a tab is also not a security boundary: users with access to the workbook may be able to unhide it unless workbook structure is protected, and hidden content should not be treated as confidential.
Frequently Asked Questions
Can I protect one Excel sheet and leave the rest unlocked?
Yes. Activate the sheet and use Review > Protect Sheet. Protection applies to the active worksheet, so other sheets remain editable unless you protect them separately.
Can I lock only certain cells on a sheet?
Yes. Unlock the cells users should edit through Format Cells > Protection, then protect the worksheet. Locked cells are enforced only while sheet protection is active.
Can I protect a sheet without a password?
Yes. You can enable sheet protection and leave the password field blank. A password can make it harder for someone to switch off protection casually, but sheet protection is not encryption.
Does Protect Sheet stop someone from deleting the tab?
No. Protect Sheet controls actions on the worksheet. To restrict adding, deleting, renaming, moving, or hiding sheets, protect the workbook’s structure separately.
Can I lock a worksheet in Excel for the web?
Excel for the web supports worksheet protection, though the available controls can differ from desktop Excel. If you need detailed settings or cannot find a control in the browser, open the workbook in the desktop app and use the Review tab.
Related
- Break-Even Analysis Calculator Excel Template
- Break External Links in Excel: Steps and Side Effects
- Break External Links in Excel: Safe Ways to Remove Them
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Does Excel Online Have Goal Seek? What to Use InsteadNo. Excel for the web does not currently include the Goal Seek command, so you cannot run a…
- Excel Data Validation Conditional Lists: Setup and FixesIn Excel for Microsoft 365 on Windows, a conditional list—also called a dependent dropdown—changes its choices based on…
- Page Break in Excel Shortcut: Insert and Adjust BreaksIn Excel for Microsoft 365 on Windows, select the row, column, or cell where the printed page should…
- Create a Page Break in Excel: Steps and Print TipsTo create a page break in Excel for Microsoft 365 on Windows, select the cell below and to…
- Delete a Page in Word: The Quick Keyboard ShortcutTo delete a page in Word quickly, click anywhere on the page, press Ctrl+G on Windows (or Option+Command+G…
- Convert Text to Columns in Excel: Steps, Options & TipsTo convert text to columns in Excel for Microsoft 365 on Windows, select the cells in one column,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.