Protect Excel Sheets in Teams: What It Does and How

Yes. You can protect a worksheet in an Excel workbook shared through Microsoft Teams by opening the workbook in Excel and using Review > Protect Sheet. This limits changes to locked cells, but it does not stop teammates who have file access from viewing or copying the workbook; use Teams or SharePoint access permissions for that.

How Excel files in Teams work

Teams is the place people find and collaborate on a workbook, but the file itself is generally stored in SharePoint for a channel or in OneDrive when it is shared in a chat. A channel file can be opened in Excel for the web or in the desktop app. The workbook remains the same file as people edit it, rather than a separate copy for each person, unless someone deliberately downloads or makes a copy.

That distinction matters because worksheet protection is a setting in the workbook, while permission to open or edit the file is managed through its storage location. Protecting a sheet can help prevent an accidental change to formulas, labels, or a carefully arranged template. It is not a substitute for deciding who should be able to access the workbook at all.

Teams’ interface can vary by version and organization. In a channel, look for the workbook under the channel’s Files tab or the newer Shared area. You can also open the file in SharePoint and choose to open it in the desktop app. Chat files are commonly available from the chat’s shared files area.

Protect a worksheet in Excel for Windows

For Microsoft Excel for Microsoft 365 on Windows, use these steps. If several people are working in the file, let them know before changing protection settings so they are not surprised by the change.

Open the workbook from Teams, then choose Open in Desktop App if it is currently open in a browser.
Select the worksheet tab you want to protect. Protection applies to a sheet at a time, so repeat these steps for each sheet that needs it.
On the ribbon, select Review > Protect Sheet.
In the dialog, decide whether to set a password. Select the actions you want users to be allowed to perform, such as selecting unlocked cells or using AutoFilter, where those options are available.
Select OK. If you set a password, enter it again when prompted to confirm it.
Save the workbook. Check the sheet by trying to edit a cell that should be protected and one that should remain editable.

By default, cells in a worksheet are marked as locked, but that setting does not prevent edits until sheet protection is switched on. A common setup is to unlock the cells teammates are expected to fill in, then protect the sheet so formulas and headings are less likely to be overwritten.

Choose which cells teammates can edit

To make a form or shared tracker usable, prepare the editable areas before protecting the sheet. Select the cells people should be able to change, open Home > Format > Format Cells, choose the Protection tab, clear Locked, and select OK. Then protect the sheet using the Review tab. The Protection tab controls the cell’s locked status; it does not protect the sheet by itself.

For example, a team expense tracker might have locked column headings and formula cells, with the date, description, and amount columns unlocked for contributors. Once the sheet is protected, users can enter information in those unlocked cells while the protected cells resist ordinary editing. Test the arrangement with a sample entry before relying on it.

The Protect Sheet dialog also lets you permit certain actions. Options can include selecting locked or unlocked cells, formatting cells or columns, inserting rows, sorting, and using AutoFilter. Choose only what the workflow needs. If a team must filter a protected list, allow the relevant filter action and confirm that the filters are already set up as intended; protection settings can affect what users can do with them.

If different people need access to different input areas, Excel’s Allow Users to Edit Ranges feature may be useful in some desktop configurations. It is more involved than simply unlocking a set of cells, and availability or authentication options can depend on the environment. For a straightforward shared form, unlocked input cells are often easier to maintain.

Worksheet protection is not file security

Protect Sheet is mainly a control against routine or accidental changes. It does not hide the worksheet’s contents, make a confidential cell invisible to someone who can open the file, or act like encryption. A user with access may still be able to copy visible data, make another copy of the workbook, or use other methods to get around worksheet protection. Microsoft describes worksheet protection as a way to prevent changes, not as a security feature for sensitive information.

Do not put information in a workbook on the assumption that a sheet password will keep it secret from coworkers who can access the file. If some people should not see particular information, store that information in a file or system they do not have permission to access. Hiding a sheet is not a reliable confidentiality control either: a hidden sheet may be unhidden by someone with sufficient access, and workbook structure protection is not a replacement for access control.

Use Teams and SharePoint permissions to control who can open or edit the file. Depending on the location and your organization’s setup, owners can manage membership or file access and may be able to grant view-only rather than edit access. The exact controls depend on whether the file is in a team channel, a private or shared channel, or a chat, and on organizational policies. If access should be restricted, review the file’s sharing settings rather than relying on a worksheet password.

Worksheet protection versus workbook protection

Excel has two related features that are easy to confuse. Protect Sheet limits changes to cells and selected worksheet actions on the active sheet. Protect Workbook can protect the workbook’s structure, such as preventing users from adding, deleting, moving, hiding, or renaming sheets. In Excel for Windows, the structure option is available from Review > Protect Workbook.

Workbook structure protection does not make the cells on each sheet read-only. Conversely, protecting one worksheet does not prevent someone from adding another sheet or changing the workbook’s structure. If a template needs both types of guardrail, configure each separately and test them. Neither should be treated as a way to keep file contents secret from people who have permission to open it.

Passwords, recovery, and collaboration

A password is optional when protecting a worksheet. Without one, users who can access the protection controls may be able to turn protection off. With one, they need the password to unprotect the sheet through Excel’s normal interface. Use a password only if the team can store and share it safely, and make sure at least one responsible owner knows where it is kept.

Do not assume there is a simple Microsoft recovery process for a forgotten worksheet-protection password. Keep a secure record of it, document who is responsible for the workbook, and retain an appropriately controlled backup or version history. A file password used to encrypt a workbook is a different feature from a worksheet-protection password and has different security implications.

Protected worksheets can still be part of collaborative workflows when contributors have permission to edit the workbook and the sheet allows changes in the intended cells. But protection settings can block actions people expect, and changing protection while others have the workbook open may cause confusion. Coordinate changes, ensure everyone is working from the shared file rather than an old download, and check the result in the same environment the team uses.

Excel for the web and Mac differences

In Excel for the web, worksheet-protection controls are available through the Review area; the interface may show a control such as Manage Protection. Options can differ from the Windows desktop dialog, and some protection tasks or settings may require opening the workbook in the desktop app. If you cannot find a setting in the browser, choose Open in Desktop App and configure it there.

Excel for Mac has worksheet-protection features too, though ribbon labels and dialog layouts can differ slightly from Windows. Look on the Review tab for the sheet-protection command. Keyboard shortcuts also differ between Windows and Mac, but no shortcut is required for the steps above. For a workbook shared in Teams, the protection is saved in the file, so teammates using another supported Excel app will see the resulting restrictions, subject to that app’s available controls.

Common problems and practical checks

A teammate cannot type in a cell: The cell may still be locked, or the protected sheet may not allow the action they need. Confirm the cell’s Locked setting and review the selected permissions.
Someone can still open the file: Sheet protection does not control file access. Adjust permissions on the Teams, SharePoint, or OneDrive file instead.
A user can edit a formula: Check that the formula cell is marked Locked and that sheet protection is active. Both conditions matter.
Filtering or sorting is unavailable: Review the permissions selected when the sheet was protected. Some actions may also depend on how the data and filters were set up before protection.
The password does not work: Check for a typing error, including keyboard layout or capitalization, and confirm that the password belongs to this sheet rather than to a different workbook feature. Excel does not provide a dependable password reminder for a forgotten protection password.
Changes seem missing: Confirm that the person edited the shared Teams file rather than a downloaded copy, and check that the workbook has saved. File versions and access controls may be managed in its SharePoint or OneDrive location.

Before distributing a protected workbook, test it using the same kind of account and app your teammates will use. Confirm that an intended input cell can be edited, a formula cell cannot be changed through normal editing, and any needed filtering or formatting remains possible. This small check often catches problems faster than trying to diagnose them after a team has started using the file.

Frequently Asked Questions

Can I protect an Excel sheet directly in Teams?
Teams provides access to the workbook, but sheet protection is an Excel feature. Open the workbook in Excel, use the Review protection controls, and save the changes to the shared file.

Can teammates edit unlocked cells in a protected sheet?
Yes. Mark the intended input cells as unlocked before turning on sheet protection, then permit the necessary actions in the protection settings. Users still need edit access to the workbook itself.

Does Protect Sheet stop people from viewing the data?
No. It restricts ordinary editing actions; it does not hide data or provide strong confidentiality. Use file-level permissions, or keep sensitive information in a location the intended readers cannot access.

Can I protect only one sheet in a workbook?
Yes. Select that sheet and protect it. Other sheets are not automatically protected, so protect each one separately if its contents or layout need the same editing restriction.

What if I forget the sheet-protection password?
There is no simple password-recovery option to rely on. Check your organization’s approved records or contact the workbook owner, and avoid setting passwords without a secure way to retain them.

Does protecting a worksheet stop someone from deleting a sheet?
Not by itself. Protect the workbook structure separately if you need to restrict actions such as deleting or renaming sheets, and remember that neither protection feature replaces file permissions.

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.