Excel® 2013 On Demand

Creating Groups and Outlines

A sales report that displays daily, weekly, and monthly totals in a hierarchical format, such as an outline, helps your reader to sift through and interpret the pertinent information. In outline format, a single item can have several topics or levels of information within it. An outline in Excel indicates multiple layers of content by displaying a plus sign (+) on its left side. A minus sign (-) indicates that the item has no contents, is fully expanded, or both.

Create an Outline or Group

Organize data in a hierarchical fashion—place summary rows below detail rows and summary columns to the right of detail columns. ...