Quick, clean, and to the point

Hide rows

Windows shortcut 
Mac shortcut 

Hide 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.
Internet is full of excel websites with excel classes but I have to say none of them is well made (at least for me). This instead is really great. It's now saved as first page in my browser... -Luca
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