How to Unhide Sheets in Excel Shortcut

Excel is a spreadsheet program that allows you to calculate, analyze, and present data in an organized format. One of the important features of Excel is the ability to hide and unhide sheets. Hiding sheets can be useful when you want to focus on specific data or protect sensitive information. However, sometimes you may need to unhide sheets. In this article, we will explain how to unhide sheets in Excel using keyboard shortcuts.

Step 1: Open Excel

The first step is to open Excel on your computer. You can do this by clicking on the Excel icon on your desktop or by searching for Excel in the Start menu. Once Excel is open, you can proceed to the next step.

Excel IconSource:

Step 2: Select the Workbook

After opening Excel, you need to select the workbook that contains the hidden sheet. You can do this by clicking on the “File” tab in the top left corner of the screen and selecting “Open” from the dropdown menu. Then, navigate to the location where the workbook is saved and select it.

Excel Open FileSource:

Step 3: Access the Home Tab

Once the workbook is open, you need to access the Home tab on the Excel ribbon. The ribbon is the panel at the top of the Excel window that contains all the different options and commands. Click on the “Home” tab to access it.

Excel Home TabSource:

Step 4: Find the Unhide Option

Under the Home tab, you will see several groups of commands. Look for the “Cells” group and click on the “Format” button. In the Format dropdown menu, you will see an option called “Hide & Unhide”. Click on this option to reveal another dropdown menu.

Excel Unhide OptionSource:

Step 5: Select Unhide Sheet

In the Hide & Unhide dropdown menu, you will see two options: “Unhide Rows” and “Unhide Columns”. Since you want to unhide a sheet, select “Unhide Sheet”.

Excel Unhide SheetSource:

Step 6: Select the Hidden Sheet

After selecting “Unhide Sheet”, you will see a list of all the hidden sheets in the workbook. Select the sheet that you want to unhide by clicking on it. Once you have selected the sheet, click on the “OK” button.

Excel Select Hidden SheetSource:

Step 7: View the Unhidden Sheet

After clicking on “OK”, the hidden sheet will be unhidden and you can view it just like any other sheet in the workbook.

Excel View Unhidden SheetSource:

Keyboard Shortcuts to Unhide Sheets in Excel

If you want to unhide sheets in Excel more quickly, you can use keyboard shortcuts. Here are the two keyboard shortcuts you can use to unhide sheets:

Shortcut 1: Alt + H + O + U

This keyboard shortcut unhide a sheet in Excel. Press and hold the “Alt” key on your keyboard and then press “H” to access the “Home” tab. Next, press “O” to access the “Format” dropdown menu, and then press “U” to select “Unhide Sheet”.

Shortcut 2: Ctrl + Shift + 9

This keyboard shortcut unhide a sheet in Excel. Press and hold the “Ctrl” and “Shift” keys on your keyboard, and then press “9”.


Unhiding sheets in Excel is a simple task that can be done using keyboard shortcuts or through the Excel ribbon. By following the steps outlined in this article, you can easily unhide hidden sheets and view the data they contain.

Related video of How to Unhide Sheets in Excel Shortcut

Mustakim ID
Mustakim ID

Seorang blogger enthusiasm & starter copy writer. Sangat tertarik dengan perkembangan dunia teknologi.

Articles: 766