Search

How to unhide worksheets in Excel

 

You can hide worksheets in Excel workbook to prevent users from seeing it. Click following link to learn how to hide worksheets in Excel. When required, you can unhide hidden worksheets.

To unhide a hidden worksheet from Excel workbook, right-click the worksheet Tab and select "Unhide" from context menu as shown in below image.

 

 Unhide hidden worksheets from Excel workbook

"Unhide" worksheets dialog box is pop-up, containing a list box of hidden worksheets. As you can see from below image of "Unhide" worksheets dialog box, "Sheet1" and "Sheet2" are the hidden worksheets.

 Unhide worksheets dialog box

Select the hidden worksheet which you want to unhide from "Unhide" worksheets dialog box and then click "OK" button to unhide the hidden worksheet, as shown in below image.

 How to unhide hidden worksheets in Excel

As you can see from below image, hidden worksheet in Excel workbook is visible now.

 Hidden worksheet is visible

Another method to achieve the same result described above is to run command "Unhide Sheet" from Excel Ribbon > "Home" Tab > "Cells" Group > "Format" > "Hide & Unhide", as shown in below image.

 Unhide worksheets from Excel Ribbon

An animation about how to unhide hidden worksheets in Excel is copied below.

 How to unhide worksheets in Excel

 

 

Related Tutorials
• How to insert a new worksheet to Excel workbook
• How to rename an Excel worksheet
• How to delete a worksheet from Excel workbook
• How to hide worksheets in Excel