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.
Step 3: Choose the Options button at the bottom-left corner of the window.
Step 4: Click the Advanced tab at the left side of the Excel Options window.
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.
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.