Data Sort

[Guest]

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.

 

[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).

 

[Guest]

Thank you for your hlep.

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).

 

[Dave Peterson]

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