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.