Data Sort

S

SJT

I have a database of four columns. The first column is product type and the
second column is client name. The first product type consumes approximately
the first 20 rows. If I wanted to just sort those first twenty clients
alphabetically w/o affecting the rest of the data can I do that? or does the
entire table have to be sorted? Thank you in advance for your assistance.
 
B

Bob Umlas

If you select more than one cell, Excel will sort the selection. Otherwise
it will sort the current region. Therefore, select A1:A20 (or whatever the
range is you want to sort).
 
S

SJT

Thank you for your hlep.

Bob Umlas said:
If you select more than one cell, Excel will sort the selection. Otherwise
it will sort the current region. Therefore, select A1:A20 (or whatever the
range is you want to sort).
Click to expand...
 
D

Dave Peterson

I never let excel guess what I want sorted. I always explicitly select the
range.
 
Top