View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 618
Default Can I sort by more than 3 columns?

"ArcticWolf" wrote in message
...
I have six columns all with data in. I would like to sort all 6 columns
together but Excel only lets you sort by 3.
Can I sort by all six or is there another way?


One option is to sort by the 3 lowest priority columns first, and then the 3
highest priority. So if you want to sort by columns A to F in that order of
priority, sort by D to F (in that priority order), then by A to C (in that
priority order).
--
David Biddulph