How to Hide the Sheet Bar in Excel

This wikiHow will teach you how to hide the sheet bar in Excel using the desktop program and web browser. A hidden sheet remains functional and appears in any linked formulas, but you won't see the worksheet or data in your workbook while it is hidden.

Steps

  1. Image titled Hide Sheet Bar in Excel Step 1
    1
    Open a project in Excel. This app icon looks like a white "x" on a green background overlaying a green rectangle.
    • You can open a saved project within Excel by navigating to File > Open or you can right-click the file in your file manager and select Open With > Excel. Click File > New to start a new project.
  2. Image titled Hide Sheet Bar in Excel Step 2
    2
    Right-click a sheet tab. You'll see sheet tabs at the bottom of the worksheet.
    Advertisement
  3. Image titled Hide Sheet Bar in Excel Step 3
    3
    Click Select All Sheets. This will select all the worksheets in your workbook.
  4. Image titled Hide Sheet Bar in Excel Step 4
    4
    Click the Home tab (if necessary). The "Home" tab might be open by default.
  5. Image titled Hide Sheet Bar in Excel Step 5
    5
    Click Format. If you're using Windows, you'll find this option in the "Cells" grouping.
  6. Image titled Hide Sheet Bar in Excel Step 6
    6
    Click Hide & Unhide. It's under the "Visibility" header.
  7. Image titled Hide Sheet Bar in Excel Step 7
    7
    Click Hide Sheet. All your selected sheets will hide from view.[1]
    • You will need to right-click the sheet bar and select Unhide. Since you can only unhide one sheet at a time, repeat this process until you've unhidden all the sheets.
    8. Advertisement

You Might Also Like

Transfer Microsoft Office to Another Computer
How to
Transfer Microsoft Office to Another Computer
Unprotect a Word Document Without the Password
How to
Unprotect a Word Document Without the Password
Duplicate a Page in Word4 Simple Ways to Duplicate a Page in Word: Windows & Mac
Install Microsoft OfficeHow to Install Microsoft Office: Subscribe and Download
Print Mirror Image
How to
Print Mirror Image
Change Transparency in PowerPoint
How to
Change Transparency in PowerPoint
Get Microsoft Office For Free7 Ways to Use Microsoft Office for Free: Web, Mobile, & Desktop Versions
Copy a Table from Word
How to
Copy a Table from Word
Send Large Files Through Outlook
How to
Send Large Files Through Outlook
Update Microsoft Office on Mac3 Simple Ways to Update Microsoft Office on a Mac
Insert a Comment Box in Word, PowerPoint, and Excel
How to
Insert a Comment Box in Word, PowerPoint, and Excel
Convert PowerPoint to Word
How to
Convert PowerPoint to Word
Set, Reset, Remove and Recover the Password of Excel Files
How to
Set, Reset, Remove and Recover the Password of Excel Files
Customize the Quick Access Toolbar in Microsoft Word (Windows 7)
How to
Customize the Quick Access Toolbar in Microsoft Word (Windows 7)
Advertisement

References

  1. ↑ https://support.microsoft.com/en-us/office/hide-or-show-worksheets-or-workbooks-69f2701a-21f5-4186-87d7-341a8cf53344#ID0EAACAAA=macOS

About This Article

Darlene Antonelli, MA
Written by:
Darlene Antonelli, MA
wikiHow Technology Writer
This article was co-authored by wikiHow staff writer, Darlene Antonelli, MA. Darlene Antonelli is a Technology Writer and Editor for wikiHow. Darlene has experience teaching college courses, writing technology-related articles, and working hands-on in the technology field. She earned an MA in Writing from Rowan University in 2012 and wrote her thesis on online communities and the personalities curated in such communities. This article has been viewed 5,863 times.
How helpful is this?
Co-authors: 3
Updated: September 27, 2020
Views: 5,863
Categories: Spreadsheets | Microsoft Office
Article SummaryX

1. Open a project in Excel.
2. Right-click a sheet tab.
3. Click Select All Sheets.
4. Click the Home tab (if necessary).
5. Click Format.
6. Click Hide & Unhide.
7. Click Hide Sheet.

Did this summary help you?
Advertisement