Select all columns then Data>Sort.
Choose the column to sort on.
To input a - into a text field, F2 to edit, move the insertion point to where you want the - and hit the - key.
Gord Dibben MS Excel MVP
On Sun, 24 Sep 2006 10:35:01 -0700, chipster <chipster[ at ]discussions.microsoft.com> wrote:
[Quoted Text] > how do I sort a worksheet based on one column? > >How di I input a - into a text field >
|