Excel Hack

Hide rows in Excel shortcut (Ctrl + 9)

Here are some useful shortcut keys for hiding any row in Excel. Use them to hide rows you may need later, so that you can edit the worksheet nicely. We will show you how to hide a single row and how to hide multiple rows with shortcuts.

Hide row shortcut

Windows
Ctrl + 9
Access Key: Alt + H + O + U + R

Mac
command + 9 or control + 9

Use shortcut keys to hide rows

Describes how to hide a row using the shortcut keys.

Total Time: 1 minute

Select a cell

Select a cell

Select one cell in the row you want to hide.

Row is hidden

Row is hidden

To hide a row, Press Ctrl + 9. Or Press Alt + H + O + U + R.

Hide a row in the context menu

Select a cell

Select the cell in the row you want to hide.

Select a row

Press Shift + Space. The entire row will be selected.

Press H

Press Shift + F10 to bring up the context menu.

Press H. This H refers to Hide.

Row is hidden

The selected row is now hidden.

Hide multiple rows

Select a cell

Select the cell in the row you want to hide.

select a cell

Press Shift + (Down Arrow key) allows you to select multiple cells.

Row is hidden

Press Ctrl + 9 to hide the selected multiple rows.

Hide distant rows

Select a cell

Select the cell in the row you want to hide.

Select a cell

Hold down Ctrl and click on the cells.

Row is hidden

Press Ctrl + 9. Or Press Alt + H + O + U + R.

We can now hide the distant rows.