How to Hide Sheet Tabs in Excel 2010

Microsoft Excel separates its worksheets via a tab system that you can find at the bottom of the window. Use these steps to hide sheet tabs in Excel 2010.

  1. Open your Excel file.
  2. Click File at the top-left.
  3. Select Options at the bottom-left.
  4. Choose the Advanced tab.
  5. Click the box to the left of Show sheet tabs to remove the check mark.
  6. Click OK to apply the changes.

Our article continues below with additional information and pictures for these steps.

Worksheets are a great way to separate pieces of information in Excel 2010, but still keep the data somewhere close if you need to access it later. It also provides a convenient place to store data that you might need for a VLOOKUP formula.

But not every situation calls for a multi-worksheet Excel file, and some Excel users might even prefer to avoid using worksheets at all. If you find that you have no use for the worksheet tabs at the bottom of the Excel window, then it may be more convenient to simply hide the tabs from view. Our tutorial below will show you the steps to take in order to accomplish this.

Hiding the Worksheet Tabs at the Bottom of the Excel 2010 Window

The steps in this article will modify the display of your Excel 2010 workbook so that your sheet tabs are no longer displayed. They will still be a part of the file, but the tabs will no longer be visible. When the sheet tabs are hidden, the scroll bar will extend to take up the entire bottom row of your worksheet. This article will show you how to hide the scroll bars as well.

Step 1: Open your workbook in Excel 2010.

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

click the File tab

Step 3: Click the Options button in the column at the left side of the window, which will open a new window called Excel Options.

click the options button

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

click advanced tab

Step 5: Scroll down to the Display options for this workbook section, then click the box to the left of Show sheet tabs to remove the check mark.

uncheck the show sheet tabs option

Step 6: Click the OK button at the bottom of the window to apply your changes.

click the OK button

Note that this setting will only apply to this workbook. If you wish to hide the worksheet tabs in other workbooks, then you will need to repeat these steps in those workbooks as well.

To unhide the sheet tabs you will need to follow the steps in this article, but check the box to the left of Show sheet tabs, then click OK.

Hiding sheet tabs in this manner is typically done to simplify the Excel workspace, or to prevent collaborators from easily accessing data that might be stored on other worksheets.

While this is more of a simple fix to make worksheets more difficult to edit, a determined individual will probably figure out how to access those other sheets.

If you want to prevent information on another sheet from being edited, then you may have more luck simply protecting that other worksheet. Find out about protecting worksheets in Excel 2010 and see if that’s something that could be useful to you.

Is there an individual worksheet that is hidden in your workbook? Click here and learn how to unhide worksheets in Excel 2010.

See also

solveyourtech.com newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.