To keep a worksheet out of casual view in Excel for Microsoft 365 on Windows, hide its tab, then protect the workbook structure so other users cannot simply unhide it. This is concealment, not strong security: anyone who must not be able to read the data should be kept from opening the workbook, using file encryption and a strong password. The distinction matters because Protect Sheet mainly limits editing; it does not hide the sheet’s contents.
What You’ll Need
- A workbook saved in a format that supports Excel features, such as .xlsx or .xlsm.
- Permission to change workbook protection settings. If the workbook is shared or managed by an organization, an owner or administrator may need to make the change.
- A secure way to store any password you set. Excel cannot recover a forgotten password for an encrypted workbook.
Step-by-Step
- Decide whether hiding is enough. Hiding a sheet and protecting workbook structure can deter casual browsing and prevent ordinary unhide actions. It does not encrypt the worksheet’s data. If the information is confidential, jump to step 6 and encrypt the entire workbook, or store the sensitive information in a separate file and limit access to that file. Do not rely on a hidden tab as an access-control system.
- Save a working copy. Choose File > Save As and save a separate copy before changing protection, especially if the workbook is shared or contains important formulas. This gives you a clean way back if you hide the wrong sheet or lose track of the password. Make sure you are editing the intended workbook, not a read-only copy or a downloaded preview.
- Hide the sheet. At the bottom of the Excel window, right-click the sheet tab you want to conceal and choose Hide. If the sheet tabs are not visible, first check whether the workbook window is arranged in a way that hides them; hiding a sheet does not remove the worksheet from the file. You can also select the sheet and use Home > Format > Hide & Unhide > Hide Sheet. The selected worksheet disappears from the tab row. Repeat for any other sheets you want to hide.
- Protect the workbook structure. Select Review > Protect Workbook. In the protection dialog, make sure Structure is selected, enter a password if you want password-based protection, and confirm it when prompted. Store the password safely. Workbook-structure protection is what blocks ordinary actions such as unhiding, adding, deleting, renaming, moving, or copying sheets. Protect Sheet is a separate command and is not a substitute for this setting.
- Check the result while protection is on. Try right-clicking a visible sheet tab and selecting Unhide. With structure protection enabled, Excel should prevent the action or make the command unavailable. You can also look at Review: the workbook protection control should indicate that the structure is protected, commonly by offering an Unprotect Workbook command. Avoid testing by sharing the password with someone who should not have it.
- Encrypt the workbook if readers must not see its contents. Choose File > Info > Protect Workbook > Encrypt with Password. Enter a strong password, confirm it, then save the file. Close the workbook and reopen it to confirm Excel asks for the password before displaying any sheets. Encryption protects the whole workbook, not just one worksheet. Anyone who knows the password and can open the file can still view the hidden sheet after removing or bypassing ordinary sheet-structure restrictions.
- Share the right version and explain the limits. If you only need to prevent casual discovery, share the copy with the sheet hidden and workbook structure protected. If the data is sensitive, do not send an unencrypted copy or a copy containing the sensitive sheet. For collaboration, consider putting only approved information in a separate workbook and sharing it through OneDrive or SharePoint with appropriate access permissions. Those permissions control who can access the file; hiding a tab does not.
On Excel for Mac, sheet hiding is available from the sheet-tab context menu or the Format menu, though labels and layout can vary by release. Workbook password options may be under File > Passwords; use a password to open the file for confidentiality, not merely a password to modify it. Excel for the web can display many protected workbooks, but some protection and password-management options may require opening the file in the desktop app.
Common Mistakes
Using Protect Sheet to hide data. Review > Protect Sheet is intended to restrict edits to cells and worksheet features. A person can still read visible cell contents. Use Hide and protect workbook structure for casual concealment, or encrypt the file when access to the data must be limited.
Assuming a hidden sheet is gone. Hiding only removes the tab from normal view. The worksheet and its contents remain in the workbook. Hidden data may also be exposed through formulas, charts, named ranges, linked content, or other sheets, even if the tab itself is not visible.
Using a weak or forgotten password. A guessable password undermines protection, while a forgotten encryption password can leave you unable to open the workbook. Use a unique, strong password and save it in an approved password manager. Do not put the password in the same email or folder as the workbook.
Sending the wrong copy. A temporary export, earlier attachment, or duplicate file may still contain the sheet in an unhidden or unencrypted state. Before sharing, open the exact file you intend to send, confirm the relevant settings, and check the filename and save location.
Tips
Use the least complicated method that meets the need. For a presentation workbook where a support sheet should not distract users, hide it and protect the structure. For personal, customer, payroll, or other sensitive information, encrypt the file and share its password separately through a secure channel. If recipients need only part of the information, create a separate workbook containing only that approved material instead of sending the original and hoping a hidden sheet stays unnoticed.
Keep a record of which sheets are hidden and why, especially in workbooks maintained by a team. This reduces confusion when someone later cannot find a tab. You can add a brief note to internal documentation without putting sensitive values in the note. Also review formulas, charts, pivot tables, and defined names: a visible worksheet might reveal information from a hidden sheet indirectly.
When using encryption, test the saved file after closing it. Confirm the password prompt appears, enter the password, and check that the workbook opens as intended. For a shared file, check access permissions as well as the password settings. If you need recipients to edit some sheets but not others, sheet protection can help control edits, but it still does not make hidden information secret.
Troubleshooting
Unhide is available even though you expected protection. Confirm that you chose Review > Protect Workbook and protected Structure, not only Review > Protect Sheet. If the workbook structure is not protected, hide the sheet again and apply structure protection. Check that you are working in the saved file and not another copy.
Excel will not let you hide or unhide a sheet. The workbook structure may already be protected. If you are authorized to change it, choose Review > Unprotect Workbook and enter the password, then make the change and protect the structure again. If you do not know the password, contact the workbook owner; do not assume that changing sheet protection will solve a structure-protection issue.
The file opens without asking for a password. Hiding a sheet or protecting workbook structure does not create an open-password prompt. Set encryption through File > Info > Protect Workbook > Encrypt with Password, save, close, and reopen the file to verify. Also make sure you are testing the encrypted copy rather than an earlier version.
A recipient can still access the information. If they have the file and can open it, ordinary hiding is not a reliable barrier. Remove the sensitive sheet from the shared copy, encrypt the workbook with a password known only to authorized readers, or restrict file access through your organization’s sharing controls. Remember that someone who is authorized to view information may be able to copy or photograph it.
You forgot a password. For an encrypted workbook, Excel does not provide a password-recovery feature that restores access. Check your password manager, secure notes, or organization’s approved recovery process. For a structure-protection password, ask the workbook owner or administrator for an authorized copy or the password. Keep an unprotected backup only in a suitably secure location.
Frequently Asked Questions
Does Protect Sheet stop people from viewing a worksheet?
No. It mainly controls editing and certain worksheet actions. It does not conceal the cell values from someone who can view the sheet. Hide the sheet for casual concealment, and use file encryption when the workbook itself must not be opened without authorization.
Can someone unhide a sheet protected by workbook structure?
Excel blocks ordinary unhide actions while workbook structure protection is active. This is a practical deterrent, not strong encryption or a guarantee against determined technical access. Do not use it as the only safeguard for confidential data.
Can I protect only one sheet with a password to view it?
Excel’s standard worksheet protection is not a separate view-password feature. A password on Protect Sheet restricts editing; it does not require a password just to see that sheet. To control viewing, protect access to the workbook or provide a separate file with only the appropriate content.
Will hiding a sheet remove its data from formulas or charts?
No. The data stays in the workbook, and formulas or charts on visible sheets may continue to use or reveal it. Review the whole workbook for linked values and summaries before sharing. If the data must not be available, remove it from the shared copy rather than only hiding its tab.
What if I need to share the workbook with people who should see different information?
Make separate files containing the information each audience is allowed to see, then share them with suitable permissions. A single workbook with different hidden sheets is convenient for organization but is not a dependable way to enforce different viewing rights.
Related
- Clean Excel Columns: Remove Spaces, Duplicates, and Errors
- Clean Excel Data: Practical Steps, Tools, and Common Fixes
- Lower Excel Data Load: Speed Up Large Workbooks
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Schedule Send an Email in Old Outlook with Delay DeliveryIn classic Outlook for Windows, open a new message, choose Options > Delay Delivery, set Do not deliver…
- How to Make a Fillable Form in Word Step by StepThe best way to make a fillable form in Word is to use the content controls in the…
- Can You Lock Cells in Excel and Google Sheets?Yes. In Excel, mark cells as locked or unlocked, then protect the worksheet for the setting to take…
- PowerPoint Template: How to Create Your Own DesignTo create your own PowerPoint template in Microsoft 365 for Windows, open a presentation, choose View > Slide…
- Share a Specific Calendar in Outlook: Access and StepsTo share one calendar in Outlook, select that calendar—not just the Calendar view—open its sharing settings, add the…
- How to Add a Header Underline in Word for Every PageTo add a line beneath a header in Microsoft Word, open the header, click its paragraph, then choose…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.