Ctrl + Shift + 9 in Excel: Unhide Rows

Have you ever hidden a row in Excel and needed to display it again?

You can use the Ctrl + Shift + 9 keyboard shortcut to unhide rows in Excel.

Let’s see how it works.

Keyboard Shortcut to Unhide Rows in Excel:

The keyboard shortcut to unhide rows in Excel is:

Ctrl + Shift + 9

How to Unhide Rows Using Ctrl + Shift + 9?

Suppose Row 3 is hidden in your worksheet.

Follow these steps:

1. Select the rows above and below the hidden row. For example, select Rows 2 to 4.

2. Press Ctrl + Shift + 9 on your keyboard.

Excel unhides the hidden row within the selected range.

For example, if Row 3 is hidden, selecting Rows 2 to 4 and using the shortcut displays Row 3 again.

Practical Example:

Suppose your worksheet contains these sales records:

Employee	Department	Region	Sales
Ravi	Sales	East	25000
Priya	Marketing	West	30000
Kiran	Finance	South	20000

If the row containing Priya’s details is hidden:

1. Select the rows above and below the hidden row.

2. Press Ctrl + Shift + 9.

Excel displays the hidden row again.

The data was still in the worksheet. The shortcut simply makes the row visible.

Can You Unhide Multiple Rows Using Ctrl + Shift + 9?

Yes. You can unhide multiple rows at once.

1. Select a range that includes the hidden rows.

2. Press Ctrl + Shift + 9.

Excel unhides the hidden rows within the selected range.

For example, if Rows 3 and 4 are hidden, select Rows 2 to 5 and press Ctrl + Shift + 9.

Excel displays the hidden rows again.

What If the Shortcut Does Not Work?

If Ctrl + Shift + 9 does not work, you can unhide rows using the mouse.

Method 1: Use the right-click menu:

1. Select the row numbers above and below the hidden row.

2. Right-click the selected row numbers.

3. Select Unhide.

Method 2: Use the ribbon

1. Go to the Home tab.

2. Select Format in the Cells group.

3. Choose Hide & Unhide.

4. Select Unhide Rows.

Important Things to Remember:

• Ctrl + Shift + 9 unhides rows in Excel for Windows.
• Select the rows around the hidden row before using the shortcut.
• If the shortcut does not work, use the right-click method or the ribbon.
• Unhiding a row displays its existing data. It does not change the data itself.

Excel Shortcuts to Hide and Unhide Rows and Columns:

Excel has four useful keyboard shortcuts to hide and unhide rows and columns.

Action	Keyboard Shortcut	Learn More
Hide columns	Ctrl + 0	How to Hide Columns in Excel
Unhide columns	Ctrl + Shift + 0	How to Unhide Columns in Excel
Hide rows	Ctrl + 9	How to Hide Rows in Excel
Unhide rows	Ctrl + Shift + 9	How to Unhide Rows in Excel

Tip: Select the relevant row or column before using a hide shortcut. To unhide rows or columns, select the surrounding rows or columns that include the hidden ones, then use the appropriate shortcut.

Frequently Asked Questions:

1. What is the shortcut to unhide rows in Excel?

The shortcut is Ctrl + Shift + 9.

2. Can I unhide multiple rows at once?

Yes. Select a range that includes the hidden rows, then press Ctrl + Shift + 9.

3. What if Ctrl + Shift + 9 does not work?

Select the rows around the hidden rows, right-click the selection, and choose Unhide. You can also use Home > Format > Hide & Unhide > Unhide Rows.

Final Thoughts:

The Ctrl + Shift + 9 shortcut is a quick way to display hidden rows in Excel.

It saves you from opening the right-click menu whenever you need to restore hidden information.

For more details, read our guide on Hide and Unhide in Excel

For more useful shortcuts, visit our Excel Keyboard Shortcuts page.