sorting

[53StevieD]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

How do I link columns 1,2,3 when I sort by column 1?

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

How do I link columns 1,2,3 when I sort by column 1?

I'm not sure what you mean by link. Try selecting the area in columns 1,2
and three that you want to sort. Then sort them selecting column 1 as the
key.

 

[CyberTaz]

It sounds like you're selecting the content of "column 1" before you sort &
as a result that content sorts but the content in columns 1 & 2 are staying
put. You have to either a) Select the entire range of records in columns 1
through 3 (or however many columns there are), or b) *don't* select anything
at all - simply click in column 1, then click the A-Z or Z-A button.

HTH |:>)
Bob Jones
[MVP] Office:Mac