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.