Exceljet

Quick, clean, and to the point

This video comes from our online video training for Excel.

Shortcuts to hide/unhide rows and columns

Tags 
Summary 
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.
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
Author 
Dave Bruns

Related shortcuts

Ctrl0
0
Ctrl9
9
CtrlShift9
9
CtrlShift0
0
Thank you, and thank you so very much for your videos, they are sooooo helpful. - Elizabeth
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course