Unhide Excel spreadsheets

How to unhide a hidden spreadsheet with Microsoft Excel?

Display hidden Excel spreadsheets in a workbook

A hidden Excel worksheet is handy in a shared workbook to not allow all users to change data or settings. For example, if the Excel workbook is locked with a password, then the hidden data is protected from changes. With Microsoft Excel, how to unhide an Excel spreadsheet, i.e., make a hidden worksheet visible?

There are two options, search in the Excel options at the top of the workbook or right click. Excel has been part of the Office 365 suite for some years.

Show hidden Excel worksheets from the right-click menu

Firstly, Excel sheets appear as tabs in Excel. To display a hidden Excel worksheet in the easiest and fastest way, and without writing complex code, just follow these two steps:

Find the Office tutorial in video format on Youtube:

  • Right click on the name of the current Excel sheet.
  • Click on Display and then choose the hidden worksheet to display.
Right-click to display a hidden Excel spreadsheet in a workbook
Right-click on the worksheet name to display a hidden Excel worksheet

Unhide an hidden Excel spreadsheets with the Format menu

Secondly, this solution is not as fast as the first one because you must click several times in the top menu of Excel.

  • From the Home tab, choose Format menu on the left, then under Visibility select Hide and Unhide, then click on Unhide Sheet.
  • Then choose the sheet to be displayed in the list, only the hidden Excel worksheets appear.
Format menu to display a hidden Excel spreadsheet
Format and visibility menu to make a hidden worksheet visible

Also, if this Excel tip is useful for you and you want to save even more time and efficiency with Excel, here is a selection of the best Excel shortcuts to manage spreadsheets.

In conclusion, this article explains how to display a hidden Excel sheet in a workbook. The counterpart of these options allows of course to hide a visible sheet. To go further, here is an article on another Excel tips on how to separate date and time columns with Excel.

Do the blog posts help you? Share them on social networks!

Be the first to comment

Leave a Reply

Your email address will not be published.


*