Sort a single column in a table
- Select the column or cells you want to sort.
- On the Table menu, click Sort.
- Select the sort options you want.
- Click Options.
- Select the Sort column only check box.
Sort by more than one word or field inside a table column
For example, if a column contains both last and first names, you can sort by either last name or first name.
-
Select the columns you want to sort.
-
On the Table menu, click Sort.
-
Under My list has, click an option.
-
Click Options.
-
Under Separate fields at, click the type of character that separates the words or fields you want to sort, and then click OK.
-
In the Sort by box, enter the column containing the data you want to sort by, and then in the Using box, select which word or field you want to sort by.
-
In the first Then by box, enter the column containing the data you want to sort by, and then in the Using box, select which words or field you want to sort by.
Repeat step 7 in the second Then by box if you want to sort by an additional column.
-
Click OK.