From the course: Excel 2010 Essential Training

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Hiding or grouping rows and columns

Hiding or grouping rows and columns - Microsoft Excel Tutorial

From the course: Excel 2010 Essential Training

Start my 1-month free trial

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 and now we…

Contents