Excel Hack

Unhide rows in Excel shortcut

  • Release Update
  • Written in Excel for Microsoft 365 version 2201

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 a cell

Select the cell above the hidden row.

Select cells across hidden rows

Select a cell

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

Redisplay hidden rows

Row is unhidden

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 a cell

Select the cell above the hidden row.

Select a row

Press Shift + Space to select the entire row.

Select a row

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

Press U

Press Shift + F10 to bring up the context menu.

Press U. This U refers to Unhide.

Row is unhidden

The row has been redisplayed.

Unhide all rows in a worksheet

Select a cell

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

Row is unhidden

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

All rows in the worksheet have been redisplayed.