Using the Excel Outline Feature to Automatically Outline Data

Outlining is a means of viewing levels of detail as required by collapsing or expanding to hide or show information. You can identify subtotals and hide or collapse detail so that only subtotals appear on the screen. Outlining will also allow you to make detail data disappear so that only the higher level subtotals remain visible when you are using larger worksheets. An outlined Worksheet will print exactly as it appears on the screen. This makes Outlining an extremely useful presentation tool.