Exceljet

Quick, clean, and to the point

Unhide rows

Windows shortcut 
CtrlShift9
Mac shortcut 
9

Unhide any hidden rows that intersect the current selection.

Related videos

Tip: Shortcuts to hide/unhide rows and columns
In this video, we look at the shortcuts you can use to hide and unhide both columns and rows. These are very handy for hiding data you don't need to see, and just a taste of Excel's 200+ shortcuts.
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course
Video training for Excel Tables