Quick, clean, and to the point

This video comes from our online video training for Excel.

Shortcuts to hide/unhide rows and columns

Video Transcript 

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

To hide columns, use Control + 0.

When you do this, you'll see the columns on either side bolded as a visual indicator that columns are hidden.

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

To unhide columns, 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, 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 that are hidden by using control + A to select the entire worksheet, then using Control + Shift + 0, or Control + Shift + 9, or both.

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

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 + 0 to hide the rows.

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

To do this, go to the the last cell in the workarea 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 right, select the column, then all columns right, then hide.

To undo, just select the entire worksheet, then unhide rows and columns.

 Download the practice worksheet
Dave Bruns
This is probably the best explanation I've ever read of an excel function, and I've read a lot! Thank you for making it so clear and easy to understand!!! :) - Marie
Excel foundational video course
Excel Pivot Table video training course
Excel conditional formatting video course
Excel formulas and functions video training course
Excel Shortcuts Video Course