Datasort Function

[GS Roberts]

How Do I set a default for Datasort in Excel 2003.
Example if I want to datasort column AC, next time I
Datasort I would like that column (AC) to Datasort
automatically. Thanks for any help.
GSR

 

[Debra Dalgleish]

If you select a cell in column AC, within the list, and choose
List>Sort, the field name column AC should appear in the Sort by dropdown.

After you've sorted a list, it should retain the fields in the Sort
dialog box, until a different list is sorted, or until the file is closed.