Quick, clean, and to the point

Shortcuts to hide/unhide rows and columns

In this video, we'll cover shortcuts for hiding and unhiding rows and columns.

To hide columns, use Control + 0.

You can also work with multiple columns at the same time.

To unhide columns again, make a selection that spans the hidden columns, and use Control Shift 0.

To hide rows, use Control + 9.

Again, you'll see a visual indication in row numbers to indicate that rows are hidden.

To unhide rows again, make a selection that spans hidden rows, and use Control Shift 9.

When you're hiding and unhiding rows and columns, you can make multiple selections before you use shortcuts.

So for example, I can hide ever other column in this table.

Or, every other row.

You can quickly unhide all rows and columns by using control + A to select the entire worksheet, and then using Control + Shift + 0, or Control + Shift + 9, or both.

Also, remember that you can use Select Special to make more complicated selections before you hide.

For example, to hide all rows that contain the divide by zero error in this table, I can use select special to select the errors, then Control + 9 to hide the rows.

Finally, you can hide extra rows and columns to focus attention on just the work area.

To do this, go to the the last cell in the work area using control + end in Windows and Fn Control right arrow on a Mac.

Then move one a couple cells down, select the row, then select all rows below, then hide.

Now go the the last cell again, move a couple columns to the right. Then select the entire column, then all columns to the right, and then hide.

To unhide all of these hidden rows and columns at once, select the entire worksheet, and then unhide rows and columns.


Related shortcuts

Dave Bruns

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.

Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Charts video training course
Video training for Excel Tables
Dynamic Array Formulas