Unhide rows in Excel shortcut

• Release Jan 24, 2022Update Aug 24, 2022
• Written in Excel for Microsoft 365 version 2202

Just as you can quickly hide a row, you can also redisplay a hidden row. If you want to show the data of a temporarily hidden row later, you can use a convenient shortcut key to redisplay the row. In addition to how to redisplay rows using the shortcut keys, we also explain how to redisplay rows from the context menu and how to redisplay all rows in a worksheet.

Unhide row shortcut

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

Mac
command + shift + 9 or control + shift + 9

Use the shortcut key to unhide a row

Explains how to use the shortcut keys to unhide a row.

Total Time: 1 minute

Select a cell

Select the cell above the hidden row.

Select cells across hidden rows

Press Shift + ↓ (Down Arrow key) to select the cells above and below the hidden row.

Redisplay hidden rows

Press Ctrl + Shift + 9. Or Press Alt + H + O + U + O. The hidden rows are now reappearing.

Unhide a row from the context menu

Select the cell above the hidden row.

Press Shift + Space to select the entire row.

Press Shift + ↓ (Down Arrow key) to select the top and bottom of the hidden row.

Press Shift + F10 to bring up the context menu.

Press U. This U refers to Unhide.

The row has been redisplayed.

Unhide all rows in a worksheet

Press Ctrl + A twice. Select all the cells in the worksheet.

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

All rows in the worksheet have been redisplayed.