Unhide a Worksheet in Excel

By Ted French, About.com Guide

As with all things Microsoft, there is more than one way to unhide a worksheet in an Excel worksheet.

These instructions cover how to unhide a worksheet using the Format button on the ribbon in Excel 2007 and Excel 2010.

Note: You must first hide a worksheet in Excel before the unhide option is available.

Example: Unhide a Worksheet in Excel 2007 and 2010

Note: For help with this example, see the image above.

1. Click on the Home tab.


2. Click on the Format icon on the ribbon to open the Format drop down menu.


3. Under the Visibility section of the drop down menu, choose the Hide / Unhide option to open the sub menu.


4. Under the Hide / Unhide sub menu, click on the Unide Sheet option to open the Unhide dialog box.


5. The sheets that are currently hidden will be listed in the dialog box window.


6. Click on the sheet you wish to unhide.


7. Click OK.


8. The selected worksheet should be visible again.