How to Unhide a Worksheet in Excel 2010

Your Excel file is called a workbook, and it can contain a varying amount of worksheets. The worksheets are the spreadsheet grids into which you type your data, and many situations can call for you to have multiple active worksheets within a workbook. Typically you can navigate between these worksheets by clicking the sheet tabs at the bottom of the window.

But the worksheet tabs can be hidden in Excel 2010, making it a little more difficult to work on other worksheets. Fortunately a worksheet that is hidden in Excel 2010 can also be unhidden, and you can follow our short guide below to learn how to do so in Excel 2010.


Unhiding Worksheets in Excel 2010

The steps in this article are directed specifically at Excel 2010 users. However, these steps will work for other versions of Excel as well. If you are unsure about which version of Microsoft Excel you are using, you can click here to learn how to tell.


Step 1: Open your workbook in Excel 2010.


Step 2: Locate the sheet tabs at the bottom of the window.

locate the sheet tabs



Step 3: Right-click one of the tabs, then click the Unhide option.

right-click a sheet tab, then click unhide



Step 4: Click the worksheet that you would like to unhide, then click the OK button.

select a sheet, then click OK



Are you unable to use the method above because all of your sheet tabs are hidden? Then your workbook may have been configured to hide all of the sheet tabs using a different method. Read this article to learn how to display sheet tabs when none of them are visible. newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.