Excel Hack

Unhide rows in Excel shortcut

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 cells across hidden rows

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

Redisplay hidden rows

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 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.

Comments

Please send us your comments on this article.

0 comments
Inline Feedbacks
View all comments