From the course: Excel 2016: Tips and Tricks

Unlock the full course today

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

Collapse and expand detail quickly with outlining shortcuts

Collapse and expand detail quickly with outlining shortcuts

From the course: Excel 2016: Tips and Tricks

Start my 1-month free trial

Collapse and expand detail quickly with outlining shortcuts

- [Voiceover] Excel has an outlining feature which could be ideal for presentations. We're looking at a worksheet called Projected Budget 2017. In this worksheet there are formulas in column E that tabulate data from the left, and in column I, column M, and farther off to the right, for the fourth quarter as well and also a grand total. There are formulas in row seven that are tabulating data from above. Same thing happening in row 13, 14, and then farther down the list here in row 33 and 35 as well. If you're about to present this data at a presentation, I think a lot of people would agree that's way too much information on the screen. So what you could do manually ahead of time is highlight these columns using the Control key, highlight these, and highlight all the monthly data. Just using the Control key, moving across. Right-click and hide. And that's certainly a lot less, and possibly we could even hide some rows, maybe we don't need to see the detail here. So we could do…

Contents