How to Hide or Group Rows and Columns in Excel


show more Hiding or grouping rows and columns provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training show less
please wait ...

Hiding or grouping rows and columns

There may be times when you don't want to display or print all your data. Maybe your worksheet is too big, or maybe you are presenting your work to someone who shouldn't have access to all your information. Rather than keeping track of separate worksheets, which I really advice against because just way too room for error, you can temporarily hide your rows and columns. Now there are two ways of doing this. First, I'll show you the standard way that I see most people using, but I will show you a better way that is a little more interactive. So let's say we want to show this worksheet to someone who shouldn't see what our Cost or Profit is.

So put your mouse-pointer up here on the header for Column F and you see the mouse-pointer is pointing down. And click-and-drag straight across to Column H so we have those three columns selected. Make sure your mouse pointer is still pointing down, right-click, and from the pop-up menu, choose Hide and they are hidden. You can deselect a...

Hiding or grouping rows and columns
Video duration: 5m 31s 6h 21m Beginner

Viewers:

Hiding or grouping rows and columns provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training

Subjects:
Business Education + Elearning
Software:
Excel
Author:
please wait ...