HOW DO YOU ALPHABETIZE A LIST OF NAMES IN AN EXCELL SPREADSHEET?

S

sera

if anyone has used a list of names in an excel spreadsheet does anyone know
how to alphabetise the names in the spreadsheet?
 
G

Gord Dibben

Data>Sort>Ascending.

Be sure to select all columns you want sorted together before Data>Sort.

Never let Excel guess.


Gord Dibben MS Excel MVP
 
L

L. Howard Kittle

Select the list and click the Sort Ascending (A to Z) or Sort Decending (Z
to A) in the tool bar.

HTH
Regards,
Howard
 
B

bala_vb

'sera[_2_ said:
;949367']if anyone has used a list of names in an excel spreadsheet doe
anyone know
how to alphabetise the names in the spreadsheet?
Click to expand...



You can sort the names based on either first name or last name b
using, Data->sort->Sort on A-> Z or Z->A

Please let me know how many columns you have, how you want them to b
sorted?

Thanks
Bal
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HOW TO ARRANGE NAMES & ADDRESSES SAME LINE ALPHA? 1
alphabetize entire rows by first word of first column 5
How do I keep columns in my Excell spreadsheet seperated? 1
DROP DOWN LIST WHEN SPREAD SHEET OPENS 5
Excel 2 into 1 6
How do I alphabetize a list of names? 1
How do I set up an Excel file to be imported into Access 1
Alphabetize in multiple columns 2

Top