In some instances that will be the end of the process. Instructions on how to hide a sheet in Excel - and, more importantly, how to unhide them - can be found in this Microsoft Office article. It must be hidden… Find a hidden sheet in Excel But this spreadsheet doesn’t have a sheet with that name - or at least one that we can see. The formula is looking in a sheet called 'rawdata and checks' (the exclamation point is a useful clue to look for). This one is quite a mouthful - but you don’t have to understand it to spot the name of a sheet which is not visible: The box will probably contain a formula that provides a clue to the location of the missing data.

When selected, look in the formula bar above the sheet (but below any menus) - highlighted with the red box in the image above. The first step is to click on one of the cells containing the numbers you want - the numbers that change when a different option is selected from the drop-down menu. Select a cell with data and the formula bar will show a complex formula

Remove drop down menu in excel 2016