During the sorting process, Excel will compare the top rows of your worksheet for formatting differences. If the top row is formatted differently from the subsequent rows, then Microsoft Excel will identify it as a column label and will exclude it from the sort.

To sort columns of data alphabetically or numerically, either in ascending or descending order, follow the instructions below.

1. Enter your data in a column.
2. Select the cells containing the data to be sorted.
3. Click on the Sort Ascending icon in the Standard toolbar to sort your data in ascending order.
4. Click on theSort Descending icon in the Standard toolbar to sort your data in descending order.

Note: You can perform a basic sort on numbers, as well.

Click HERE to return to the Table of Contents.