Yes - if it doesn't automatically do this, it's probably because there are
breaks in your data which make Excel think there are separate ranges.
Highlight all the columns you want to sort together, and put the current
selection in the column you want to use to sort (use tab so the current cell
is in the column), then sort.
Another method is to select all the columns, then choose Data | Sort..., and
you can then pick up to 3 columns to sort by, in decending order. (In fact
if you want to sort by more than 3 columns, use this method twice, sorting
the least significant sorts first, then the most significant ones.)
--
HTH -
-Frank Isaacs
Dolphin Technology Corp.
http://vbapro.com