Ctrl + 9 in Excel: Hide a Row

Have you ever wanted to hide a row in Excel without right-clicking the row number?

You can do this quickly using a simple keyboard shortcut: Ctrl + 9.

Let’s see how it works.

Keyboard Shortcut to Hide a Row in Excel:

The keyboard shortcut to hide a row in Excel is:

Ctrl + 9

How to Hide a Row Using Ctrl + 9?

Follow these steps:

1. Open your Excel worksheet.

2. Click any cell in the row you want to hide.

3. Press Ctrl + 9 on your keyboard.

Excel hides the selected row.

For example, if you click cell C3 and press Ctrl + 9, Excel hides Row 3.

The data in the row is not deleted. It is simply hidden from view.

Practical Example:

Suppose you have the following sales data:

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

If you want to hide the row containing Priya’s details:

1. Click any cell in Priya’s row.
2. Press Ctrl + 9.

Excel hides the entire row containing Priya’s details.

The other rows remain visible.

You can use this shortcut when you want to temporarily hide specific records without deleting them.

Can You Hide Multiple Rows Using Ctrl + 9?

Yes. You can hide multiple rows using the same shortcut.

1. Select the rows you want to hide.

2. Press Ctrl + 9.

Excel hides the selected rows.

For example, if you select Rows 3 to 5 and press Ctrl + 9, Excel hides those rows.

Important Things to Remember

• Ctrl + 9 hides rows; it does not delete them.
• You can hide one row or multiple selected rows.
• Hidden row data remains in the worksheet and can still be used in formulas.
• If the shortcut does not work, check whether your keyboard settings or system shortcuts are interfering.

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 hide a row in Excel?

Press Ctrl + 9 to hide the selected row or rows.

2. Does hiding a row delete its data?

No. Hiding a row only removes it from view. The data remains in the worksheet.

3. How do I unhide a row in Excel?

Select the rows above and below the hidden row, then right-click the selection and choose Unhide.

You can also read our guide on Hide and Unhide in Excel.

Final Thoughts:

The Ctrl + 9 shortcut is a quick way to hide rows in Excel without opening a menu.

It is useful when you want to temporarily hide records that are not needed in your current view.

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