Excel workbooks are actually collections of different spreadsheets that you can use to organize data within one file. But the sheet navigation at the bottom of the window takes up valuable screen real estate and, if you want that extra space to be able to view more cells at once, you might decide to hide those sheet tabs. If you have personally hidden the sheet tabs in Excel 2010, or if someone else uses your computer and they have hidden them, then it can be difficult to switch between sheets in a workbook. Fortunately it is a simple process to restore these sheet tabs to the bottom of your workbook screen so that you can effortlessly navigate between sheets. Have you been considering a switch to Windows 8? To decide if making that switch is in your best interest. How to Unhide Sheet Tabs in Excel 2010 If unhiding your sheets is a temporary effect, then you will be happy to know that you can simply reverse the process outlined below to go back to hiding the sheets.
In Microsoft Excel 2016, how do I unhide a sheet that has been hidden? Answer: You can view all of the sheet names as tabs along the bottom of the. The Show sheet tabs setting is turned off. First ensure that the Show sheet tabs is enabled. To do this, For all other Excel versions, click File > Options > Advanced—in under Display options for this workbook—and then ensure that there is a check in the Show sheet tabs box.
But for the purpose of showing your worksheet tabs below your Excel spreadsheet, which is the default setting, you can simply follow this procedure. Step 1: Launch Microsoft Excel 2010. Step 2: Click the File tab at the top-left corner of the window, then click Options. Step 3: Click the Advanced option in the column at the left side of the Excel Options window.
![Excel Excel](/uploads/1/2/4/1/124135312/733441333.png)
Step 4: Scroll to the Display options for this workbook section, then check the box to the left of Show sheet tabs. Step 5: Click the OK button at the bottom of the window to apply the change. We have a number of other helpful articles about Excel 2010 on this site.
To see some articles that might help you with a problem you are having, or might give you an idea about how to customize Excel in a way that you didn’t know was possible.
Note: The image in this article are from Excel 2016. Your view might be slightly different if you have a different version, but the functionality is the same (unless otherwise noted). Cause Solution The window sizing is keeping the tabs hidden.
If you restore multiple windows in Excel, ensure that the windows are not overlapping. Perhaps the top of an Excel window is covering the worksheet tabs of another window. The status bar has been moved all the way up to the Formula Bar. Tabs can also disappear if your computer screen resolution is higher than that of the person who last saved the workbook. Try maximizing the window to reveal the tabs. Simply double-click the window title bar. If you still don't see the tabs, click View Arrange All Tiled OK.
![Excel 2016 Worksheet Tabs Disappeared Excel 2016 Worksheet Tabs Disappeared](/uploads/1/2/4/1/124135312/321674871.png)
The Show sheet tabs setting is turned off. First ensure that the Show sheet tabs is enabled. To do this,. For all other Excel versions, click File Options Advanced—in under Display options for this workbook—and then ensure that there is a check in the Show sheet tabs box. If you are using Excel 2007, click the Microsoft Office button Excel Options Advanced category, and under Display options for this workbook, ensure the that there is a check in the Show sheet tabs box. Note: In Excel 2007, you may not see worksheet tabs after adding a macro sheet to a workbook.
For more information, see. The horizontal scroll bar obscures the tabs. Hover the mouse pointer at the edge of the scrollbar until you see the double-headed arrow (see the figure). Click-and-drag the arrow to the right, until you see the complete tab name and any other tabs. The worksheet itself is hidden.
To unhide a worksheet, right-click on any visible tab and then click Unhide. In the Unhide dialog box, click the sheet you want to unhide and then click OK. Need more help?
You can always ask an expert in the, get support in the, or suggest a new feature or improvement on.