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.

birthday t-shirts for boys
vintage t rex t-shirt

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