Exceljet

Quick, clean, and to the point

Hide rows

Windows shortcut

Ctrl9

Mac shortcut

⌃9

Hide rows that intersect the current selection.

222 Excel Shortcuts for Windows and Mac

Related videos

The videos below demonstrate this shortcut.

Shortcuts to hide/unhide rows and columns

In this lesson, we cover shortcuts you can use to hide and unhide, rows and columns.

form.antibot { display: none !important; } You must have JavaScript enabled to use this form.

Topics

Key functions

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts. Read more.

I have relied on your website on countless occasions throughout the course of my graduate level finance internship. Compared to a number of unnamed Excel tutorial sites and forums, yours is par-none. It is invariably the only source for consistently accurate and understandable formula functions and syntaxes. I say that as this page has solved an hours-long problem facing me during an all-night work session. Thanks a lot! -Nick

Hide rows

Related videos

Download 200+ Excel Shortcuts

Excel video training