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.
- Open your Excel file.
- Click File at the top-left.
- Select Options at the bottom-left.
- Choose the Advanced tab.
- Click the box to the left of Show sheet tabs to remove the check mark.
- 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.
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.
Step 4: Select the Advanced tab at the left side of the Excel Options window.
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.
Step 6: Click the OK button at the bottom of the window to apply your changes.
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.
- How to subtract in Excel
- How to sort by date in Excel
- How to center a worksheet in Excel
- How to select non-adjacent cells in Excel
- How to unhide a hidden workbook in Excel
- How to make Excel vertical text
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.