Collapsing and expanding detail quickly with outlining shortcuts

- In this workbook, we're looking at a worksheet called…Proj Budget 2015.…If you are about to make a presentation…based on the data on this worksheet,…its projected budget for 2015,…you might consider displaying less information,…it's a lot of information to be throwing at people.…There's a technique referred to as Outlining,…it's available from the top menu on the Data menu,…it's called Group and Outline.…It's also available in the ribbon tabs on Data.…Without doing anything special or unusual,…I'm going to be using this…but I do want to point out something ahead of time.…

Wherever you see the yellow cells,…except for the actual labels,…these are formulas tabulating data from the left.…This is adding up these three cells,…same thing over here,…I also got some grand totals over on the right.…We have some totals also adding up data from above…like this is adding data from the two cells here.…So some of that's occurring as well.…And there's no real jury rigging out the data here…but we do have formulas in certain locations…