Excel Worksheets Disappeared 2010

In the unhide dialog box click the sheet you want to unhide and then click ok.

Excel worksheets disappeared 2010. Try ctrl f7 then use arrow keys to see if you can find it. In excel 2010 and earlier it s 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. The data in hidden worksheets and workbook windows is not visible but it can still be referenced from other worksheets and workbooks. Follow the steps to do so.

Originally posted by martindwilson. To unhide a worksheet right click on any visible tab and then click unhide. Click on repair to scan the corrupt file. Microsoft excel spreadsheets consists of a huge amount of data and disappearance of data from any cell would make the situation really troublesome for the excel users.

It may be of the screen perhaps someone opened it in a dual monitor and saved it in the right hand screen or something like that. If this occurs as shown in the figure you can double click on the workbook s name to maximize the window and restore your workbook tabs. Click and drag the arrow to the right until you see the complete tab name and any other tabs. If the file location is not available then find the excel file by clicking on search option.

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. The worksheet itself is hidden. Since this is a commonly reported issue of excel users here we will talk about how to recover back data disappears in excel 2007 2010 2013 2016 version. Even it is possible that the data missing on excel sheets can change the entire result of the workbook.

Once the scanning is complete verify the components of excel file and check if the available preview shows complete data that disappeared from excel.