You may have encountered with the situation where you open an excel workbook that has several worksheets, but only single worksheet appears to you. If this happens your missing worksheet may get hide in plain sight due to some changes in excel setting. In order to restore the vanished worksheet tabs, here are few techniques which help you in easy navigation of workbooks easier, as well as other ways to find hidden worksheets.
Normally, within the excel workbook you will get several tabs along with the bottom of the screen but do you know it is possible to hide the worksheet tabs. In order to solve the mystery of missing tab you must know, what are the symptoms of occurrence of this issue first and then workaround you need to fix it.
There are number if things which leads you to get stuck in such situation but out of that, some most common ones are mentioned here:
- When you inadvertently disconnect the workbook windows from the excel windows when using the trio of restore windows buttons on the tile bar and move the windows under the status bar.
- User of the file might have made the screen resolution too high and tab get vanished from the bottom of the screen.
- You may have turn off the Display options for this workbook.
In order to fix this issue, you can opt any of these below mentioned solution:
Method 1: minimize and then restore the workbook window
- To minimize the workbook windows tap to the Minimize Window button next to the Microsoft Office Excel Help.
- On the minimized worksheet, click the restore up button or the Maximize button to restore the workbook window.
Method 2: Press ALT+TAB
If several workbooks are opened, press ALT+TAB to change between workbooks.
Method 3: Click the workbook buttons in the taskbar
If multiple workbooks are open then to switch between the workbooks you can click the workbook button in the taskbar.
Method 4: Open or create a new workbook
In addition to workbook that contains the macro worksheet, open an existing workbook or create a new workbook.
Method 5: Change the Zoom settings
Change the zoom settings to some other settings. Then change the zoom settings back to the preferred settings. Follow these steps to do this:
Click zoom out or zoom in on the status bar.
On the view tab, click zoom in the zoom group, select the settings you want under Magnification, and then click OK.
You may encounter workbooks where the worksheet tabs aren’t visible.
The show sheet tabs setting controls whether or not worksheet tabs are visible.
In excel 2010 and earlier, it is relatively easy to inadvertently arrange a spreadsheet window so that the worksheet tabs aren’t present on the screen, even if the Show Sheet Tabs option is enabled. While this happen, you can double click on the workbook’s name to maximize the window and restore your workbooks. In excel 2013 if you can’t see the worksheet tabs, simply double-click on the words “Microsoft Excel” at the top of the windows to maximize excel’s application window.
Figure 3: sometime excel windows get arranged such that tab are not visible.
You can use a keyboard shortcut to navigate between worksheet within the workbook. To do this, press Ctrl-Page Up to activate the adjacent worksheets to the left or press Ctrl-Page Down to activate the nest worksheet to the right.
Excel 2013 offers helpful improvements to this activate menu, as all worksheets are comes displayed in a single dialog box, and then you select a worksheet by typing the first letter of the sheet name. In excel 2010 and earlier version, the Activate menu initially displays up to 16 worksheets, requiring to choose more sheets to display more list.further
Further, in Excel 2010 and earlier you must choose a desired sheet name with your mouse, as the menu cannot be accessed by way of keystrokes as is possible in Excel 2013.
Figure 4: to display list of worksheet, right click on the navigation arrows in any version of excel as it will display a list of worksheet.
In other case ,your worksheet tabs may be present, but a worksheet still appears to be missing. In excel 2007 and later version, you can right click on any worksheet tab and choose unhide. if this command is disabled, there most likely aren’t any hidden worksheets in the workbook, but there is a way you can determine this categorically.
You can access the unhide sheet command from the excel’s main menu.:
- Excel 2007 and later: on the home tab, choose format, hide and unhide sheet.
- Excel 2003 and earlier: Choose Format, Sheet, and then Unhide.
- Excel 2011 for Mac: From the main menu, choose format option>sheet >unhide. The format command on the home tab of the ribbon doesn’t allow you to unhide worksheet.
If the unhide sheet is disabled, you can’t necessarily assume that there are no hidden worksheet within a workbook.
Automatic Solution To Fix This Missing Excel Worksheet Tab Issue
You must try the Excel Repair Tool being professional software is capable of fixing any errors related to MS Excel. It can easily recover the data in Excel, solve any type of excel corruption error and above all it has easy and consistent user interface.
This repair tool is designed to recover every single object in your file without having any problem with the formatting, layout and some other properties. With the help of this tool you can restore user defined charts, formatting of the charts, properties of worksheet generating formulas, shared formulas, condition formatting rules, numbers, text and rules.