How to Unhide All Sheets in MS Excel

Microsoft Excel is a spreadsheet application used by home and office users. The software has several worksheets within one workbook. You can hide and unhide these worksheets within each workbook. Hiding sheets makes it easier to work with several pages within the Excel workbook. The function is found in the main menu of the Excel spreadsheet software. Once the sheets are unhidden, you can work with the encompassing data.

Young businesswoman eating lunch at desk
credit: Siri Stafford/Digital Vision/Getty Images

Step

Double-click the Excel file on your hard drive you want to edit. Double-clicking the file opens the spreadsheet and loads the software automatically.

Step

Select a location on the spreadsheet where the list box will be created. Click the "Data" menu item and select "Validation."

Step

Select "List" from the first window. In the text box that is enabled, click the arrow button on the right. This opens a new window where you select all the cells on the spreadsheet that populate the list box values. After you've selected the spreadsheet cells, press the "Enter" key.

Step

Press the "Ok" button in the validation window. The window is closed and the new list box is displayed on the spreadsheet. Click the arrow on the list box, and you'll notice all the possible values entered into the control.