Sorting Data Lists

graphics/09inf14.jpg

graphics/one_icon.jpg

Select a cell in the column you want sorted alphabetically or numerically (depending on whether the sort column contains text data or numeric data).

graphics/tow_icon.jpg

Click the Sort Ascending button on the Standard toolbar.

graphics/three_icon.jpg

The data is sorted alphabetically from A to Z or numerically from the lowest amount to the highest. Click the Sort Descending button.

graphics/foure_icon.jpg

This sorts the data alphabetically from Z to A, or numerically from the highest amount to the lowest.

INTRODUCTION

You can easily change the order of the data in your worksheet. If, for example, you want to alphabetically arrange the names in a data list of sales representatives, you can sort on Last Name. Alternatively, you might want to sort your sales representatives by the region in which they work or by YTD sales.

TIP

Sorting on Multiple Columns

To sort on multiple columns of data, select Data, Sort to open the Sort dialog box. Select the first Sort by column name (for example, Region) from the drop-down list box; then choose up to two more options from the Then by drop-down list box (for example, YTD Sales). Make sure you indicate whether you have a header row (if not, the columns will list as Column1, Column2, and so on), and click the OK button to perform the sort on your data.



Easy Microsoft Office 2003
Easy Microsoft Office 2003
ISBN: 0789729628
EAN: 2147483647
Year: 2003
Pages: 281
Authors: Nancy Lewis

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net