Yes. In Excel for Microsoft 365 on Windows, right-click a worksheet tab and choose Hide to conceal that sheet, or turn off Show sheet tabs to hide the entire row of worksheet tabs. These actions are different: hiding a sheet changes its visibility in the workbook, while hiding the tab bar only removes the on-screen controls.
Which Excel tabs can you hide?
People usually mean the worksheet tabs along the bottom of an Excel window when they ask about hiding tabs. Those tabs are labeled with sheet names such as Summary, January, or Data. Excel lets you hide an individual worksheet, and it also has a display setting that hides the whole sheet-tab bar.
The word tab can also mean a tab on the ribbon, such as Home or Insert, or a tab in a web browser. Those are separate things. The methods below concern worksheet tabs. Hiding a worksheet does not remove its data, and hiding the worksheet-tab bar does not hide the ribbon or browser controls.
Before changing anything, decide what you want other people to see:
- Hide one or more worksheets when you want to keep supporting or intermediate sheets out of the ordinary workbook view.
- Hide the entire worksheet-tab bar when you want more screen space or a cleaner display.
- Protect workbook structure when you want to make it harder for someone to unhide, move, rename, or add sheets.
How to hide an individual worksheet
In Excel for Microsoft 365 on Windows, select the sheet you want to conceal and use either of these methods:
- Right-click the worksheet tab and select Hide.
- Or select the sheet, open Home > Cells > Format > Hide & Unhide, and choose Hide Sheet.
The sheet disappears from the tab row, but its contents remain in the workbook. Formulas on other sheets can continue to refer to cells on a hidden sheet, and charts or other workbook features may still use its data. Hiding is a visibility choice, not a deletion or a way to remove a sheet’s contribution to calculations.
For example, a workbook might have a visible Dashboard sheet and a hidden Data Import sheet. A colleague opening the file normally sees the dashboard, while formulas on it can still read the imported figures. If the source figures should not be shared at all, hiding the sheet is not enough; remove the sensitive data or control access to the workbook itself.
You can select multiple adjacent sheet tabs with Shift-click, or nonadjacent tabs with Ctrl-click, and hide the selected sheets together. Excel must still have at least one visible worksheet, so it will not let you hide every sheet in a workbook. If the Hide command is unavailable, check whether the workbook structure is protected.
How to hide the entire worksheet-tab bar
If you want all sheet names to disappear from the bottom of the window without hiding the sheets themselves, change the workbook display setting. In Windows, go to File > Options > Advanced. Under Display options for this workbook, clear Show sheet tabs, then select OK. If Excel has more than one workbook open, check that you are changing the setting for the intended workbook.
This setting hides the row of sheet tabs; it does not make the worksheets hidden. The workbook still contains its sheets, and their data and formulas continue to work. Turning Show sheet tabs back on restores the tab row. This is useful for a presentation-style view, but it should not be treated as a privacy feature or as protection against someone navigating the workbook by other means.
On a Mac, Excel also provides a sheet-tab display option in its settings. Depending on the release, open Excel > Settings or Excel > Preferences, then look under View for the Sheet tabs option. The labels and layout can differ slightly between Mac releases. In Excel for the web, worksheet visibility can be managed from a sheet tab’s context menu, but the desktop File > Options dialog described above is a Windows-specific path.
How to unhide a worksheet
To restore a hidden sheet in Excel for Microsoft 365 on Windows, right-click any visible worksheet tab and select Unhide. You can also use Home > Cells > Format > Hide & Unhide > Unhide Sheet. Choose the sheet name in the dialog and select OK. If several sheets are hidden, repeat the process; the standard dialog restores one sheet at a time.
If the entire tab bar is missing, first turn Show sheet tabs back on using File > Options > Advanced. Otherwise, you may not have a visible tab to right-click. If the Unhide command is disabled or the sheet does not appear in the list, workbook structure protection or a more advanced visibility setting may be involved.
Excel does not provide a built-in personal view of hidden worksheets for each collaborator. A sheet hidden by one person is hidden for anyone who opens that saved workbook. If a team needs different people to see different information, separate workbooks or a properly permissioned data source are more suitable than relying on sheet visibility.
Protecting workbook structure
Hiding a sheet alone is easy to reverse: someone can usually right-click a visible tab and choose Unhide. To stop ordinary users from changing sheet structure, use Review > Protect Workbook and enable the Structure option. Depending on the prompt, Excel lets you set a password. With structure protected, users cannot use normal commands to unhide, rename, move, add, or delete worksheets.
Workbook-structure protection is different from protecting a worksheet. Review > Protect Sheet is intended to restrict changes to cells and other worksheet contents; it does not by itself prevent a user from un-hiding a sheet. If your goal is to keep hidden sheets from being casually restored, protect the workbook structure as well as hiding the relevant sheets.
Protection is a barrier against routine editing, not strong information security. A password does not make a workbook a safe place to store credentials, personal records, or other information that recipients must not access. Anyone who can obtain the file may be able to use tools or procedures outside normal Excel commands. For genuinely confidential material, do not include it in a file shared with people who are not authorized to see it.
Hidden, very hidden, and protected: what is the difference?
Excel’s normal Hide command creates an ordinary hidden worksheet. It is absent from the tab row but can be restored through Unhide, unless workbook structure protection prevents that command. This is appropriate for decluttering a workbook or keeping calculation details out of the way, not for concealing information from a determined recipient.
Excel also supports a VeryHidden sheet state that is set through the Visual Basic Editor rather than the standard Hide command. A very hidden sheet does not appear in the ordinary Unhide dialog. This can help workbook designers keep helper sheets out of routine navigation, but it is still not a security boundary: someone with suitable access and knowledge may be able to change the setting. It is best understood as an advanced workbook-design option, not a substitute for access controls.
Protection and visibility solve different problems. Visibility determines whether a sheet appears in normal navigation; structure protection restricts changes to the workbook’s sheet arrangement. Neither should be described as encrypting or securely deleting the hidden sheet’s contents.
Common problems and how to fix them
- Hide is unavailable: The workbook structure may be protected. If you are authorized to change it, ask the owner for the password or have them adjust the protection.
- Unhide is unavailable: Check whether any worksheet is hidden and whether workbook structure protection is active. If the tab bar itself is missing, restore Show sheet tabs first.
- The sheet is not in the Unhide list: It may already be visible, or it may have been set to VeryHidden in the Visual Basic Editor. The normal Unhide dialog lists ordinary hidden sheets, not very hidden ones.
- There is no sheet tab to right-click: The tab bar may have been turned off, or the window may be too narrow to display all tabs. Restore the tab-bar setting or use the sheet navigation controls at the bottom of the window.
- A colleague can still access the information: Hiding a sheet does not remove its data or stop formulas from using it. Share a version without restricted data when access matters.
When hiding tabs is useful—and when it is not
Hiding sheets is practical in workbooks with many tabs. You might hide completed monthly sheets while keeping the current month visible, conceal a staging sheet used to clean imported data, or keep lookup tables out of the main navigation. A clear naming system and a note in a visible Read Me sheet can help maintainers understand what the hidden sheets do.
It is less suitable when the purpose is to conceal confidential content, create different permissions for different users, or prevent all access to a data source. Also consider whether hiding a sheet will confuse the next person who maintains the file. If a hidden sheet contains important assumptions or instructions, document its role and make sure an authorized user knows how to restore it.
If the issue is simply a crowded bottom row, consider renaming sheets clearly, grouping related information, or splitting a large workbook into separate files. If you only want to hide the ribbon commands temporarily, Ctrl+F1 on Windows collapses or expands the ribbon; it does not hide worksheet tabs. The equivalent ribbon controls and shortcuts can vary on Mac, so use the ribbon display controls in that version.
Frequently Asked Questions
Can I hide all the worksheet tabs in Excel?
Yes. Turn off Show sheet tabs in File > Options > Advanced on Windows. This hides the tab bar, not the worksheets themselves. If you use the Hide command on sheets, Excel still requires at least one visible worksheet.
Can I hide a sheet without deleting it?
Yes. Select Hide from the worksheet tab’s right-click menu. The sheet and its contents remain in the workbook, and formulas can continue to refer to them. Use Unhide to restore an ordinarily hidden sheet.
Can someone unhide a sheet I have hidden?
Usually, yes. A user can use the Unhide command unless workbook structure protection blocks changes. Even with protection, hiding should not be relied on to secure sensitive information.
Why can’t I see the Unhide option?
There may be no ordinarily hidden sheets, workbook structure may be protected, or the tab bar may be turned off. A VeryHidden sheet also does not appear in the standard Unhide dialog.
Does hiding a sheet stop its formulas from calculating?
No. Hidden worksheets remain part of the workbook, and formulas can still use their cells. Hiding changes what is shown in sheet navigation; it does not switch off the sheet’s data or calculations.
Can I hide tabs in Excel for the web?
You can hide and unhide worksheets using the sheet-tab context menu in Excel for the web. Some display and advanced visibility controls available in desktop Excel may not be available in the browser, so use the desktop app when you need those options.
Related
- Billing Invoice Template Excel: Setup and Key Details
- Can You Convert Notepad to Excel? A Practical Guide
- Can You Auto Capitalize in Excel? Methods That Work
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Sales Tracking Spreadsheet Template: Free Excel SetupYes—a sales tracking spreadsheet template can be free: create a workbook in Excel and use the column headings…
- Excel Max Rows per Sheet: Limits and WorkaroundsIn Microsoft Excel for Microsoft 365, a worksheet can contain a maximum of 1,048,576 rows and 16,384 columns.…
- Excel Consolidate: Combine Data from Multiple SheetsTo use Consolidate in Excel for Microsoft 365 on Windows, choose a blank destination cell, go to Data…
- Excel Eye Center Spanish Fork: Services, Doctors & MoreExcel Eye Center in Spanish Fork is a full-service eye care clinic offering routine eye exams, medical eye…
- Google Sheets GOOGLEFINANCE Formulas: Examples and TipsIn Google Sheets, use =GOOGLEFINANCE("NASDAQ:GOOG","price") to fetch the latest available price for Alphabet’s stock, or replace the ticker…
- Excel Text to Columns: Find It and Split Data CorrectlyIn Microsoft Excel for Microsoft 365 on Windows, find the Text to Columns button on the Data tab,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.