Now that your sheets are hidden, making them visible again calls for repetitive action, as every version of Excel requires you to unhide worksheets one at a time: Excel 2007 and later: On the Home tab, you can choose Format, Hide and Unhide, Unhide Sheet, and then unhide a single sheet. Jan 17, 2018 · Hiding worksheets in a spreadsheet application like Microsoft Excel or Google Sheets is an effective may to make it difficult for someone to edit data, but still keep that data available in case you need it later, or in case it needs to be used by a formula. Mar 18, 2017 · Simple trick to look (hack) into hidden sheet. ... Indeed I don’t even need to unhide the worksheet to get the data on it. ... I have problem with excel sheet. Please do as follows: 1 . Click Home > Format > Hide & Unhide > Unhide Sheet . See screenshot: 2 . Now all hidden worksheets are listed in the Unhide dialog box. Please select the worksheet you want to show, and then click the OK button. 3 . Then the selected hidden sheet is displayed. Repeat ... Eventually, some worksheets may have older data and not need to be reviewed as often as others. To make it easier to find and view your most important worksheets, you can hide the ones you're not using. Later, you can unhide them as necessary, when you want to work with them again. To hide or unhide a worksheet in Excel, follow these steps.