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. Nov 25, 2016 · Excel 2007 and later: Go to the home tab > select format > click hide and unhide sheet. Excel 2003 and earlier: Select Format > Sheet > and Unhide. And Excel 2011 for Mac: From the main menu > select format option > sheet > unhide. The format command on the home tab of the ribbon doesn’t let you unhide worksheet.Author: Sandra Louis.
How to Get Those Vanished Tabs at the Bottom of an Excel Workbook to Reappear. If, after you corrected those problems, you still can’t see the tabs, here are two likely fixes. If one doesn’t work, try the other. Double-click the window’s title bar (see screenshot at right). Open the tab and in the Window group click Arrange All and then Tiled and OK. Dec 28, 2011 · He called me this morning to say that he opened the same Excel (2007) files today, but he can't see the tabs for the worksheets, nor can he see the horizontal scroll bar at the bottom of the page. This is true for all of the files - both the originals and the ones created using "Save As".
Oct 30, 2011 · Anyway, I opened up my data base and the SHEET TAB bar at the bottom of each worksheet is GONE. I looked at the online Microsoft help and it told me to go to the office button, select EXCEL OPTIONS/ADVANCED and make sure the option for displaying sheet tabs is checked. Typically, within an Excel workbook you'll see worksheet tabs along the bottom of the screen, but it's also possible to hide the worksheet tabs, as shown in Figure 1. To manage this setting: Excel 2010/2013: As shown in Figure 2, choose File, Options, and then enable the Show Sheet Tabs setting in the Display Options section of the Advanced options.
Hide or display scroll bars in a workbook. By default, a horizontal and vertical scroll bar are displayed in an Excel workbook so that you can scroll through the data in its worksheets. However, you can turn scroll bars on or off as needed. Click the File tab. Click Options, and then click the Advanced category. Under Display options. Mar 27, 2016 · Solve for Sheet tab in Excel 2013. This feature is not available right now. Please try again later.