Sorting Data in a List

graphics/microsoft39.gif

After you enter records in a list, you can reorganize the information by sorting the records. For example, you might want to sort records in a client list alphabetically by last name or numerically by their last invoice date. Ascending order lists records from A to Z, earliest to latest, or lowest to highest. Descending order lists records from Z to A, latest to earliest, or highest to lowest. You can sort the entire list or use AutoFilter to select the part of the list you want to display in the column. You can also sort a list based on one or more sort fields ” fields you select to sort the list. A sort, for example, might be the telephone directory numerically by area code and then alphabetically by last name.

Sort Data Quickly

graphics/one_icon.jpg

Click the field name by which you want to sort.

graphics/tow_icon.jpg

Click the Sort Ascending or the Sort Descending button on the Standard toolbar.

graphics/10inf11.jpg

Did You Know?

You can sort data in rows . If the data you want to sort is listed across a row instead of down a column, click Options in the Sort dialog box, and then click the Sort Left To Right option.

Display Parts of a List

graphics/one_icon.jpg

Click in the list range.

graphics/tow_icon.jpg

Click the Data menu, point to Filter, and then click AutoFilter.

graphics/three_icon.jpg

Click the list arrow of the field you want to use.

graphics/foure_icon.jpg

Select the item that the records must match to be displayed.

graphics/five_icon.jpg

To redisplay all records in the list, click the Data menu, point to Filter, and then click Show All.

graphics/six_icon.jpg

To remove the field list arrows, click the Data menu, point to Filter, and then click AutoFilter.

graphics/10inf12.jpg

Sort a List Using More Than One Field

graphics/one_icon.jpg

Click anywhere within the list range.

graphics/tow_icon.jpg

Click the Data menu, and then click Sort.

graphics/three_icon.jpg

Click the Sort By list arrow, and then click the field on which the sort is based (the primary sort field ).

graphics/foure_icon.jpg

Click the Ascending or Descending option.

graphics/five_icon.jpg

Click the top Then By list arrow, select a second sort field, and then click Ascending or Descending.

graphics/six_icon.jpg

If you want, click the lower Then By list arrow, select a third sort field, and then click Ascending or Descending.

graphics/seven_icon.jpg If available, click the Header Row option to exclude the field names (in the first row) from the sort, or click the No Header Row option to include the field names (in the first row) in the sort.

The header row is the first row in your list that contains the column names or field labels.

graphics/eight_icon.jpg

Click OK.

graphics/10inf13.jpg

graphics/10inf14.jpg



Show Me Microsoft Office Excel 2003
Show Me Microsoft Office Excel 2003
ISBN: 0789730057
EAN: 2147483647
Year: 2002
Pages: 291

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