Create a list with Name and Address & additional columns that can be sorted by Last Name

[rosindabow]

Hi, I am new user to Excel and cannot fiugre out how to do what seems
to me to be a fundamental thing. I want to create a list with Name and
Address & additional columns that can be sorted by Last Name. Is there
some document with clear, simple instructions that I can follow? It
does not need to be fancy but sorting by surname is a must.

I am running Excel under OS X v 10.3.9 on a Dual PowerMac 2.5MHz..

Please send help. Thanks!

 

[Bob Greenblatt]

Just set up your list with separate columns for the first and last name.

 

[rosindabow]

There's not a more elegant way to do it, so it looks more like an
address book? Like the Palm software and others that I've seen? I
want a list of about 100 to 150 names that if I add one it can get
sorted into the list without losing any information. There are at
least 10 columns that I would like so I would also love the address to
look more like a standard 3 line addressadn not take up so much
left-to-right room. At least one of the columns needs to have a
Yes/No option. Is excel the program to do it in or is there something
better out there? Also, if this is possible, is there a template for
lists that exist besides the one that comes with Excel (the gas
station). That one has nothing that I need. Thanks for the help.

 

[rosindabow]

There's not a more elegant way to do it, so it looks more like an
address book? Like the Palm software and others that I've seen? I
want a list of about 100 to 150 names that if I add one it can get
sorted into the list without losing any information. There are at
least 10 columns that I would like so I would also love the address to
look more like a standard 3 line addressadn not take up so much
left-to-right room. At least one of the columns needs to have a
Yes/No option. Is excel the program to do it in or is there something
better out there? Also, if this is possible, is there a template for
lists that exist besides the one that comes with Excel (the gas
station). That one has nothing that I need. Thanks for the help.

 

[rosindabow]

There's not a more elegant way to do it, so it looks more like an
address book? Like the Palm software and others that I've seen? I
want a list of about 100 to 150 names that if I add one it can get
sorted into the list without losing any information. There are at
least 10 columns that I would like so I would also love the address to
look more like a standard 3 line addressadn not take up so much
left-to-right room. At least one of the columns needs to have a
Yes/No option. Is excel the program to do it in or is there something
better out there? Also, if this is possible, is there a template for
lists that exist besides the one that comes with Excel (the gas
station). That one has nothing that I need. Thanks for the help.

 

[Paul Berkowitz]

There's not a more elegant way to do it, so it looks more like an
address book? Like the Palm software and others that I've seen? I
want a list of about 100 to 150 names that if I add one it can get
sorted into the list without losing any information. There are at
least 10 columns that I would like so I would also love the address to
look more like a standard 3 line addressadn not take up so much
left-to-right room. At least one of the columns needs to have a
Yes/No option. Is excel the program to do it in or is there something
better out there? Also, if this is possible, is there a template for
lists that exist besides the one that comes with Excel (the gas
station). That one has nothing that I need. Thanks for the help.

Put your data into Excel, then go make a Catalog in the Data Merge Manager
in Word, using the Excel file as your data source. You can format it
beautifully, and a million ways, in Word. I'm not quite sure what a Yes/No
option is, but it sounds like it might be am IfŠThenŠElse "Word Field" (an
IF MergeField). If so, check the "Suppressing Blank Lines" thread in the the
Word Mac newsgroup (today) to see how it's done.

--
Paul Berkowitz
MVP MacOffice
Entourage FAQ Page: <http://www.entourage.mvps.org/faq/index.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Microsoft Office you are using -
**2004**, X or 2001. It's often impossible to answer your questions
otherwise.

 

[rosindabow]

I am running Office 2004. This is way too complicated. Is there any
place for me to go to find clear simple directions? Something that
will go step by step, exactly as it needs to be done. I tried the Data
Merge Manager and it was completely confusing. I'm sorry. I am very
facile with other computer programs but a complete novice when it comes
to Office. It is an extremely powerfull program. Probably more than I
need. I am trying to make a list of names and addresses with some
other columns like will be there, has replied, etc... I though it
would be easy but... Is there any simple program to basically enter and
arrange names and addresses.

 

[tanir]

Hi, it would be good if you can segregate your name column into 2
columns i.e. 1st name and last name. This way you can sort them by
last name column. Open a new spreadsheet, create your column
labels/field titles i.e. 1st name, last name, address, city, zipcode,
country, etc. etc. on the first row. Highlight them, go to Data,
select forms and you can start data-entry in an easier format. Hope
this helps.