How to Unhide All Sheets in MS Excel

By Lysis

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.

Things You'll Need

  • Computer
  • Microsoft Excel

Step 1

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 2

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

Step 3

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 4

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.