In a setup like this, you should group the numbers that add up to the total but not the row that reports Outlining worksheet information lets you view the bottom-line results at a glance or click a button to see all the figures behind the results. We created similar groups by highlighting theįigures for individual gizmo sales and each person’s total product sales. Click the minus sign (-) to hide the breakdown of widget sales or click the plus sign (+) to see the details. We chose Data, Group & Outline, and Group. Widgets, and the column that shows how many they sold. We highlighted the salespeople’s names, the column that indicates In our example, we grouped the cells that show the breakdown of who sold which widgets and gizmos. To set up your outline, highlight blocks of data you want to expand and collapse as a unit. Use summary rows (or columns,ĭepending on the format) under each subsection. We grouped the Burbank office’s widget sales and its gizmo sales, for example. The basic idea is that everything is organized in list format with similar pieces of data grouped together. You must set data up with outlining in mind. Search MS Office A-Z | Search Web Pages/ Design A-Z Excel 2002- Outline- Outlining Data Home Excel 2002 Outline Outlining Data
