How to Unhide Sheets in Excel

In this tutorial, we’ll carry on with how to unhide hidden Spreadsheets in Excel.

So let’s get into it!

See the video tutorial and transcription below: 

See this video on YouTube:

Previously, you learned how to hide a sheet in Excel in a quick and simple way.

Now, we’ll have a look at how to revert this step and you’ll also see how you can easily find out how many hidden sheets there are in a workbook and what their names are.

As an example, we’ll use the same table as we did last time. You can notice that the only visible sheet here is the sheet ‘Questionnaire’.

How to Unhide Sheet in Excel - visible sheet

But there is a hidden spreadsheet in the workbook with the list of all months that was used to help us make this drop-down menu.

How to Unhide Sheet in Excel - not visible sheet

So, if you want to unhide a sheet in a workbook, you’ll need to click on any spreadsheet that is visible. Set the cursor on its name, right-click and select ‘Unhide’.

How to Unhide Sheet in Excel - select unhide sheet

You’ll see a pop-up window where you’ll find the list of all spreadsheets currently hidden in the workbook. In this case, only one spreadsheet is hidden, the spreadsheet called ‘Months’.

How to Unhide Sheet in Excel - how many sheets are not visible

What to Do if There Is More then One Hidden Sheet

If there were more, you’d need to select and click on the one you want to unhide. Then click on OK.

Great! The spreadsheet ‘Months’ with the source data for our drop-down list is visible again on the bar below!

How to Unhide Sheet in Excel - result of unhiding sheet

Are you wondering:

If you found this tutorial helpful, watch other video tutorials by EasyClick Academy. Learn how to use Excel in a quick and easy way!

Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button on our YouTube channel and join the EasyClickers!

See you in the next tutorial!