Hide Rows

Using the Hide Rows Shortcut

Windows keyboard shortcut

 
Mac keyboard shortcut

This Excel shortcut hides rows that intersect the active selection.
Other useful Grid Operation keyboard shortcuts