From the course: Excel 2010 Essential Training
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Hiding or grouping rows and columns - Microsoft Excel Tutorial
From the course: Excel 2010 Essential Training
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.