• Skip to main content

masteryourtech.com

Mobile phones, software, consumer electronic how-to guides

  • iPhone
  • Excel
  • Powerpoint
  • Word
  • Google Drive
You are here: Home / Excel / How to Hide Sheet Tabs in Excel for Office 365

How to Hide Sheet Tabs in Excel for Office 365

posted on April 2, 2019

At the bottom of your worksheets are a series of tabs. If you don’t use them or rename them, then they probably have names like Sheet1, Sheet2, Sheet3. By navigating between these tabs you can have multiple spreadsheets in the same file.

But if you never use those tabs, or if you are accidentally clicking on them, then you might want to hide them. Our guide below will show you how to change a setting in Excel so that the worksheet tabs at the bottom of your workbook are always hidden.

How to Hide Worksheet Tabs in Excel

The steps in this article were performed in the Excel for Office 365 version of the program, but will work in earlier versions of Excel as well. Note that this only changes the setting for the file that is currently open. It won’t affect any other workbooks that you open in Excel.

Step 1: Open a file in Excel.

Step 2: Select the File tab at the top-left of the window.

open the excel file menu

Step 3: Choose the Options button at the bottom-left corner of the window.

open the excel options menu

Step 4: Click the Advanced tab at the left side of the Excel Options window.

select the advanced tab

Step 5: Scroll down to the Display options for this workbook section, click the box to the left of Show sheet tabs to clear the check mark, then click the OK button at the bottom of the window.

how to hide sheet tabs in microsoft excel for office 365

Tired of Excel automatically turning Web page addresses into clickable links? Learn how to disable automatic hyperlinking in Excel so that this stops happening for other files that you open in Excel in the future.

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Related

Filed Under: Excel

Search

  • Contact Us
  • Privacy Policy
  • Terms and Conditions

Copyright © 2022 MasterYourTech.com