![]() In the Unhide dialog box, click the sheet you want to unhide and then click OK. ![]() To unhide a worksheet, right-click on any visible tab and then click Unhide. ![]() Click-and-drag the arrow to the right, until you see the complete tab name and any other tabs. Hover the mouse pointer at the edge of the scrollbar until you see the double-headed arrow (see the figure). The horizontal scroll bar obscures the tabs. To do this,įor 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. The Show sheet tabs setting is turned off.įirst ensure that the Show sheet tabs is enabled. If you still don't see the tabs, click View > Arrange All > Tiled > OK. Simply double-click the window title bar. Try maximizing the window to reveal the tabs. Tabs can also disappear if your computer screen resolution is higher than that of the person who last saved the workbook. The status bar has been moved all the way up to the Formula Bar. Perhaps the top of an Excel window is covering the worksheet tabs of another window. ![]() If you restore multiple windows in Excel, ensure that the windows are not overlapping. The window sizing is keeping the tabs hidden. Your view might be slightly different if you have a different version, but the functionality is the same (unless otherwise noted). Note: The image in this article are from Excel 2016.
0 Comments
Leave a Reply. |