Excel Protect Sheet From Being Viewed? The Real Fix

No: Excel’s Protect Sheet feature stops or limits edits; it does not prevent someone from viewing the sheet’s contents. To keep a workbook’s contents from being opened, use file encryption with a password to open it, or restrict who can access the file through its storage or sharing permissions.

What Protect Sheet actually does

In Excel for Microsoft 365 on Windows, the command is on the Review tab: choose Review > Protect Sheet. You can set a password and choose which actions are allowed, such as selecting cells, formatting cells, or inserting rows. These controls are useful when you want people to fill in designated cells without changing formulas or layout.

Protection applies to editing, not secrecy. A person who can open the workbook can still see the protected sheet and read its visible values and formulas. The password prompt associated with sheet protection is not a password-to-open prompt. It should not be treated as a way to conceal sensitive information.

For example, a budget template might protect cells containing formulas while leaving the monthly input cells unlocked. That helps prevent accidental changes to calculations. It does not make the budget private from someone who receives the file.

Choose the right kind of protection

Start by identifying what you need to prevent. Excel has several controls with similar-sounding names, but they solve different problems:

Prevent people from opening the workbook: encrypt it with a password to open.
Prevent accidental or unauthorized edits: protect a sheet or the workbook structure.
Limit access to particular people: share the file only with those people and manage their access in OneDrive or SharePoint.
Keep selected information out of a shared copy: remove that information before sharing, rather than relying on hiding it.

These methods can be combined. For instance, a workbook can have an opening password and protected formula cells. But an editing safeguard does not replace an access control, and hiding data does not make it confidential.

Encrypt a workbook so it requires a password to open

For a local workbook in Excel for Microsoft 365 on Windows, open the file and follow this path:

Choose File > Info.
Select Protect Workbook > Encrypt with Password.
Enter a strong password, select OK, and enter it again to confirm.
Save the workbook, close it, and check that opening it prompts for the password.

This encryption protects the workbook file itself: a person who does not have the password should not be able to open its contents in Excel. Use a password that is difficult to guess, and keep it somewhere secure. Excel does not provide a way to recover a forgotten opening password, so losing it can mean losing access to the workbook’s data.

On Excel for Mac, password settings are available through File > Passwords; use the password-to-open option, then save and verify the file. The exact dialog wording can vary by release. Excel for the web does not support opening password-encrypted workbooks, so recipients may need to use the desktop app. If the workbook is stored in a managed workplace environment, follow the organization’s approved sharing and encryption policies as well.

What encryption does—and what it does not do

A password to open is the appropriate Excel feature when the goal is to keep a recipient who lacks the password from viewing the workbook. It is different from a sheet password, which is encountered only after the workbook has already opened. Encryption also does not prevent an authorized recipient from copying, photographing, or sharing information after they have opened the file.

Think carefully about where the password is sent. Sending the workbook and its password in the same email or chat reduces the protection if that account or message is exposed. For sensitive work, send the password through a separate approved channel, and share the file only with the intended people.

Password encryption can also create practical obstacles. A recipient may not be able to preview the file in a browser, and automated systems or other spreadsheet programs may not handle the encrypted workbook as expected. If recipients need to collaborate in a browser, use controlled cloud access rather than assuming that an opening password will fit that workflow.

Why hiding a worksheet is not enough

To hide a sheet in Excel for Windows, right-click its sheet tab and choose Hide. This removes the tab from ordinary view, but someone with access to the workbook can use Unhide to show it again. Hiding is useful for tidying a workbook or keeping supporting calculations out of the way; it is not access control.

You can also protect the workbook structure so users cannot ordinarily add, delete, move, rename, hide, or unhide sheets. Choose Review > Protect Workbook, select the structure option if shown, enter a password, and confirm it. This makes casual changes harder, but it still does not encrypt the hidden sheet’s contents or stop someone who can open the workbook from viewing data by other means. Structure protection is an editing restriction, not a confidentiality boundary.

A useful example is a sales report with a hidden lookup sheet. Hiding it keeps the main report uncluttered, and structure protection reduces accidental unhiding. If the lookup sheet contains confidential salaries or customer details, however, do not include those details in a file given to people who should not see them. Create a separate, sanitized copy instead.

Control access when sharing from OneDrive or SharePoint

If people need to collaborate on a workbook, manage access at the file or folder level. In OneDrive or SharePoint, share with named people when possible, choose whether each recipient can edit or only view, and review or remove access when it is no longer needed. The available controls depend on the account, organization settings, and how the file is shared.

A view-only link can reduce the risk of unwanted edits, but it does not make information invisible to viewers. Someone who is allowed to view a file can see its contents, and may be able to copy or capture them. Link settings such as expiration dates or restrictions on downloading may be available in some work or school environments, but they are not universal guarantees against copying.

For confidential data, use the organization’s approved storage and access process rather than emailing multiple uncontrolled copies. If a workbook is already shared, check the sharing panel and remove unintended recipients or links; changing a sheet password alone does not revoke access to the file.

Common mistakes and safer workflows

Using Protect Sheet for privacy: it protects edits, not viewing. Use encryption or access permissions for confidentiality.
Hiding sensitive rows or sheets before sending a file: hidden content remains part of the workbook. Delete or remove information that recipients must not receive, then inspect the copy before sharing.
Assuming a password can always be recovered: keep a secure record of the opening password and test it before distributing the workbook.
Using one password for everyone indefinitely: if access needs to change, manage file permissions or distribute a newly secured copy, and follow your organization’s policy.

A practical workflow is to make a separate sharing copy, remove confidential worksheets and data from that copy, check the remaining visible and hidden content, and then apply the appropriate opening password or cloud permissions. Protect sheets only where you also need to prevent accidental edits. This separates the privacy task from the spreadsheet-maintenance task.

Frequently Asked Questions

Can I password-protect one Excel sheet from being viewed?

No. Excel sheet protection controls editing and does not hide the sheet’s contents from someone who can open the workbook. To keep the workbook private, use a password to open the file or restrict access to it. If only one sheet contains sensitive data, remove that data from the copy you share.

Does hiding a sheet and protecting the workbook structure make it secure?

No. It can stop ordinary users from unhiding sheets through the usual interface, but it does not encrypt the data. Use hiding for organization and structure protection for edit control, not for confidential information.

What is the difference between Protect Sheet and Encrypt with Password?

Protect Sheet limits changes to a worksheet after the workbook is open. Encrypt with Password requires a password to open the workbook’s contents. Use the second option when the concern is viewing, and the first when the concern is editing.

Can someone open a password-protected Excel workbook in a browser?

Excel for the web does not support opening workbooks encrypted with a password. A recipient may need to download the file and open it in the Excel desktop app. For browser-based collaboration, manage access through OneDrive or SharePoint instead.

What if I forget the Excel password to open the file?

Excel does not offer a password recovery method for an encrypted workbook. Check your secure password manager or approved records. If the password cannot be found, you may not be able to open the file, which is why keeping a secure backup of the password matters.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

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

Spotted an error in this guide? Let us know.