View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default Sorting in Excel

Do you mean manually? If so, select the 10 columns, go to DataSort, then
the dropdowns give you the first item in each column, so you can select
which is the key column. You can the select two further sort columns.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"marko" wrote in message
oups.com...
Hy again!

I know how to sort from the last column or from the first column but
not from the middle column.
I have let's say 10 columns and I would like to sort the third column
and that all the other nine columns are sorted by that column! How can
that be done?
Thanks!

Marko Svaco