Step 3: Select the Advanced tab at the left side of the window. Step 2: Click that Options button, which opens the Excel Options menu. Note that if you’re working in Excel 2007, you will need to click the Office button instead. Step 1: If you click the File tab at the top-left of the window, to the left of the Home tab, you will notice an Options button at the bottom of the left column. If you’ve read this article in an attempt to show your hidden worksheets, but are struggling to do so because there simply aren’t any tabs shown at all, then you may need to change a different setting.
How to Show Worksheet Tabs in Excel if They’re All Hidden It also lets you know about the keyboard shortcut that can add a new worksheet tab, which is Shift + F11.Ĭonversely you can delete a tab by right-clicking on it and choosing the Delete option. If you hover over this tab it will say Insert Worksheet. While many Excel installations will provide three worksheet tabs by default, that may not be enough for the work that you are about to do.įortunately you can add a new Excel sheet tab by clicking the tab to the right of your last tab. The same goes for a number of formatting options, too. For example, if you select all of your sheets then type something into one of the cells in one of the selected worksheets, then the data that you have entered will appear in that same cell on each of the selected sheets. The “Select All Sheets” command is particularly useful if you have a lot of worksheets in your file and would like to apply the same action to each of those tabs.
Right-clicking these tabs provides you with the ability to rename them like we showed in the section above, as well as the ability to hide or unhide tabs, change the color of a tab, or even select all of the sheets in your workbook at the same time. The example image below is from Microsoft Excel 2010, but still applies in future Excel versions such as Excel 2013, 2016, and Excel for Office 365.
The worksheet tabs in your workbook display near the bottom of the window. Where Do Sheet Tabs Display in a Workbook in Excel? If you want to rename worksheet tabs in Excel, you can do so if you right-click on one of the tabs, then choose the Rename option. If you haven’t renamed them, then they probably say something like Sheet1, Sheet2, Sheet3, etc. What is a Worksheet Tab in Excel?Ī worksheet tab in Excel is a small button below your cells that allows you to navigate between the different worksheets in your file. Select the sheet name of the worksheet that you wish to unhide, then click the OK button. This is going to open the Unhide dialog box. You can do this by right-clicking one of your visible worksheet tabs, then choosing the Unhide option. This is a pretty common occurrence in a large Excel file, particularly if includes a lot of formulas that reference data which may not need to be visible or accessible to others who work with that file. If you are able to see some sheet tabs at the bottom of the screen, then you may need to unhide worksheets individually instead. How to Unhide a Single Worksheet Tab in Excel
Our article continues below with additional information on showing worksheet tabs in Excel. Step 5: Click the OK button at the bottom of the window to apply the change.