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.  

Dave Bruns

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.