Setting up data for outlining

- Excel has an outlining capability…that you easily overlook.…It's on the Data tab.…You'll notice the last group is called Outline,…and we see the icons Group,…Ungroup, and Subtotal.…All of these features give us the ability…to quickly collapse and expand a display.…Now, here's a budget projection for 2014.…As we look at the data here,…you can imagine how someone…about to make a presentation would be saying,…"This is way too much data to start off with.…"Let's not show the monthly data."…What you might do manually is,…drag across columns B, C and D,…that's the January, February, March,…and then, holding down the control key,…do this for columns F, G and H,…and J, K, and L,…and N, O, P.…

Right-click and Hide.…That's the more sensible display.…Similarly, we might want to hide the Expenses detail,…hide these rows here.…Right-click and Hide.…And maybe then, if our audience…is presented with this information,…expanded perhaps by zooming in,…it's not so much to absorb all at once.…But if we need to show some of the detail…