Lines on your worksheet can be sorted by one column or by multiple columns.
To sort by one column:
-
Click the column heading, for example, Part Number.
-
You will be prompted to confirm the sort so you don't sort your worksheet accidentally, since sorting will remove any subtotals in the worksheet. Click Yes.
This will sort your worksheet by number (1-9) then letter (A-Z).
A second click will reverse the sort by letter (Z-A) then by number (9-1). You will notice an arrow next to the column heading, indicating that records are sorted by this column.
Note: You can also sort your worksheet by right-clicking any column header, selecting Sort then the column name.
Related articles