Worksheet In Excel Missing
How to show missing worksheet tabs in excel 2013 step 1.
Worksheet in excel missing. To unhide a worksheet right click on any visible tab and then click unhide. Open your workbook in excel 2013. Clicking on the file tab click on the advanced category and select the display options for this workbook button. In other cases your worksheet tabs may be present but a worksheet still appears to be missing.
If only one or more particular sheets are missing from the sheet tab then those worksheets might be individually hidden. A list of hidden worksheets will appear. Click on the file tab and select options. Click options at the bottom of the column on the left side of the window.
Right click on the navigation arrows in any version of excel to display a list of worksheets. Follow the steps to do so. The worksheet itself is hidden. Click and drag the arrow to the right until you see the complete tab name and any other tabs.
If so the first place to check is to see if the worksheet has been hidden. Right click on any visible tab on the worksheet click unhide then in the unhide dialog box click sheet you desire to unhide click ok. Click the advanced tab in the left column of the excel. From the home tab click format drop down button under visibility section point to hide unhide and then click on unhide sheet.
Open excel and launch the spreadsheet for which the scroll is missing. Click the file tab at the top left corner of the window.