Bring those big spreadsheets down to size with outlining

Want to see how to use this feature the cool way?
Watch this video using your Windows Media PlayerCheckout the video for a step-by-step demonstration!
(And let me know if you experienced any difficulties)

Did you ever create a spreadsheet that got just a little too big and you had to scroll all over the place to see the numbers you needed? I suggest you learn about Excel’s “Outlining” feature. With it, you can select a collection of columns or rows that you’d like to be able to collapse (perhaps because they have a lot of detail that you might not want to see all the time) and then “outline” them. Once outlined, you can collapse or expand the rows or columns you’ve selected.

Outlining gives you the ability to setup your spreadsheet so that you can collapse it all down to show the big picture while giving you the ability to expand any specific parts you may want to zoom in to. It makes even the largest spreadsheets very, very manageable.

Now what’s really, really cool is that if you setup your spreadsheet properly in the first place, using functions like SUM and SUBTOTAL, you can automagically apply outlines by just clicking on the DATA menu, then Group and Outline, then choose Auto Outline. Download my demonstration spreadsheet and try it.

Use your favorite Podcatcher to automatically download new video and audio tips as they come! Subscribe to the Podcast and automatically download new video and audio tips as they come!