a-z sorting

[dosset]

can anybody take me through the procedure for compiling a two or  three column list then sorting them all alphabetically(by that i mean all lists are in  a-z order so when printed out they all appear fully alphabetical).I believe excel should do it but how?

[Oor Wullie]

On the toolbar (at the top) in Excel you will see a button with a A above a Z with an arrow pointing down. Press this when you have made your list and it will sort your stuff alphabeticaly. It works for me.

Will

[dosset]

that will only sort out each column singularly not multiple columns

[Sammy Snake]

I don't think you can do multiple columns in the way that I think you mean.

[Sequin]

Highlight the multiple colums by dragging across the header colums, then choose the Sort option from the Data menu - you can then sort by up to three columns

[dosset]

thanks for all answers

[mxyzptlk]

Use columns a,c,e as your data cols and leave b and d blank. Then sort individual colums and the blank columns will buffer the ones not to be sorted. This is the method I use to sort out league tables where col A is always the positions 1- 20. Another method, i believe is to use different fonts in the columns. I think the theory is that XL will only sort the same font.