Hi Ben

when sorting i follow two rules
1) select either one cell in the data range, or the entire data range -
never a column
2) use data / sort from the menu, not those nasty toolbar icons :)

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Ben" wrote in message
...
I made a worksheet of a list of books for a classroom library. The first
column I named "Title"; the second one- "Author"; the third one "Genre";
...and so on. Now, once I finished, I clicked the first column (A-
"Title"),
and then clicked the A to Z function; this sorted all the Titles in
alphabetical order, but not any of the other columns. Now, what I then
did
after undoing this is to highlight all the rows of the columns to the
right
of "Title", and then clicked the A to Z function, this then put all the
Titles in alphabetical order, and also carried the correct, correponding
row
information with each title correctly. My question is, when I click the B
"Author" colunm, and click the A to Z function to get it in alphabetical
order, how do I sort it and carry all the other corresponding row
information
with it? When I tried clicking its column, it only aphabetized that row,
and
threw off the whole wirksheet, i.e. the information did not correctly
correspond to the information in the cells adjacent (row-wise) to it.
Thank
you. Ben J.