Sorting Data

It is often useful to sort data alphabetically or numerically when you have retrieved data into Excel. You can also find data immediately through placing it into a meaningful order.

To organize the data in the order you want it to display on the worksheet, you must define a sort. There are two ways to sort data:

• If you used an index to define the data selection criteria, the data displays in the worksheet in the same order that the fields display in the index.

• If you did not use an index, you can use the Sort tab to determine the order for the data to override the sort order defined in the index,

The sort options in the Query Wizard work similar with the sort options in Excel.