Sorting a list of names from A to Z on Excel

D

djmayers

Version: 2008 I'm trying to create a large list of names and addresses on excel and after done sort them from A to Z. I'm putting the last name first with the address indented below it then tried to sort from A to Z and nothing stayed together. can someone help me with this matter? Dennis
 
C

CyberTaz

No offense, but that is *not* the way to construct such a list :)

Follow the instructions here to construct your 'database' of records which
you can then Sort & Filter as necessary whenever you want. However, if you
intend to *print* the information (what you describe sounds like a mailing
label layout) use Word's Mail Merge Manager with your Excel file as the
Record Source:

Help menu> Create and Print Mailing Labels

Even if labels aren't your ultimate objective the manner of constructing a
list for almost *any* purpose is as described there.

HTH |:>)
Bob Jones
[MVP] Office:Mac
 

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

MS Word List Bug 0
Export BPMN Visio Chart to Excel 0
Insert name and adress from a list in a word document 1
Merging from an Excel file with graphics 1
Grouping Names in Mail Merge 0
Integrating information from Word to Excel (not mail merge) 1
Cannot sort a table containing text 5
Creating a Search using a combo box and then creating a report. 4

Top