From the course: Excel 2016 Essential Training

Unlock the full course today

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

Collapsing and expanding data views with outlining

Collapsing and expanding data views with outlining

From the course: Excel 2016 Essential Training

Start my 1-month free trial

Collapsing and expanding data views with outlining

“

- We're looking at a worksheet called Outlining. It's in the workbook 08 - Worksheet Views. It's a budget and as we scroll to the right here, you can begin to see we're covering all the months of the year with some quarterly totals and a grand total on the right. Not a huge worksheet. And as we scroll downward, we've got some Expenses starting in row 16. Row 35 is at the bottom. You're a budget analyst, you're about to make a presentation of this information and you don't want to hit your audience with all these numbers at once. You might want to collapse this and show only the quarters. Now what we could do ahead of time is drag across columns B, C, and D, and with the Control key F, G, and H, and so on. We could hide those columns ahead of time and then during the presentation, when necessary, expose that detail for each month. Now sometimes when you're making presentations, you really don't want the focus to be on how you're using Excel or what you're doing with Excel. You want the…

Contents