Can I automatically arrange a list of names in Excel alphabetically?

Highlight all the columns (major problems if you don't do this), then go to
Data, Sort, and select the column with the names in it. If you have a header
row, click on the lower left box that asks you that. If you are unsure of
doing this, copy the data (or save as) to another worksheet. FYI - if you
only highlight the name column, and have a Birthdate column next to it, the
names will be alphabetized, but the birthdate column will stay the same -
major, major problem!!



"Linds" wrote:

Can I automatically arrange a list of names in Excel alphabetically?

Linds, have a look at data sort
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Linds" wrote in message
...
Can I automatically arrange a list of names in Excel alphabetically?

DataSort does that job usually, assuming your names are in a column.

If names across a row note the "Options" button in DataSort where you can
change to "left to right"


Gord Dibben MS Excel MVP

On Wed, 28 Feb 2007 12:03:05 -0800, Linds
wrote:

Can I automatically arrange a list of names in Excel alphabetically?