Arrange the Data by Product and Region Previous Topic

Previous Page 		Next Topic

Next Page

First group together the data you want to total. Click Sort (Data menu), and sort the data by region.

Screenshot shows sample data on Microsoft Excel worksheet, with data sorted.

Tip Icon

 You don’t have to select the list before sorting   Just click any cell in the column you want to sort, and then sort. Microsoft Excel automatically determines where your data starts and ends. For more information about setting up lists that are easy to sort, see Create a Business Contact List in Microsoft Excel.

Office Assistant button Office Assistant button

Cross Reference Icon

 Want to know more?   Look up Getting Results - Subtotals in Help.

Getting Around | Contents | Index

<< Previous Topic | < Previous Page | Next Page > | Next Topic >>

©1996 Office Getting Results Book.
©1997 Microsoft Corporation. All rights reserved. Legal Notices.