Yeah, click the Options button in the Sort dialog, and there is an option
there to sort by rows.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"choice" wrote in message
...
is it possible to sort range a1:g20, but sort by columns instead of rows?

thanks in advance