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.

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.

you can highlight all of the things you want to sort, and then use the tab
key to make the active cell be in the coulumn you want to sort by. Then you
can use the button to get all sorted. Whenever you have problems you should
probably use the <data<sort intstructions. There are a lot of useful
options with this.

"Ben" wrote:

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.