Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.
Microsoft Excel 2003’s List feature provides you with a
quick way of analyzing different views of your data. For example, suppose you
have a worksheet that lists sales of three products over the last three months.
You need to report on the total quarterly sales for one of those products, say
Product A. After sorting the data by Product, select only the rows that pertain
to Product A. Then, follow these steps:
to Data | List and choose Create List.
Toggle Total Row in the List toolbar.
A new row is appended to the list of data for Product A.
You’ll notice that the cells in the Total row display drop-down list arrows. To
prepare your summary report for Product A, simply click on the drop- down arrow
in the Sales column and select Sum.