Term of the Moment

knowledge worker


Look Up Another Term


Definition: XL Sort lists


Columns in Excel can be sorted into ascending (A to Z) or descending (Z to A) order. To sort a list, highlight the cells and select Data/Sort. Rows can also be sorted if required.




Sort the States
This example sorts the list of cities into state order. After highlighting the cells and selecting Data/Sort, the dialog asks for the column and sort order.





A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
misc