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.
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.
Please send us your comments on this article.