Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel
I need to put together an address book in excel, but I dont know how to do it
alphabetically. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel
Put your headers in row 1 (nice descriptions)
Each person gets their own row (and just one row per person) Each field gets its own column. Salutation in column A First Name in column B middle name/initial in column C last name in column D Street address in E Second address in F City in G state in H zip in I Add as many fields as you want, but make it as granular as it can be. (You can always use a formula to combine fields: =a2 & " " & b2 Then do your data entry. When you want to sort it, select all the columns that you used. Data|Sort click the header row option at the bottom sort by the field(s) you want (you get up to 3 fields per sort) ==== Alternatively, you can select those columns and do Data|filter|autofilter You can use those dropdowns to show all the people who live in a certain city. Data|filter|show all to see everything Morgan wrote: I need to put together an address book in excel, but I dont know how to do it alphabetically. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel
Morgan
Across the top row(1) in A1 through E1 enter Name, Address, City, State, ZIP Enter your names and addresses below in these categories. When all entered, select Columns A through E and DataSortSort on Column A and Ascending. Either do the sorting part on a copy of the worksheet or use the undo button if the sort doesn't look right to you. By selecting all columns before the Sort, you eliminate Excel guessing which data stays with which row. Gord Dibben Excel MVP On Wed, 7 Dec 2005 13:48:02 -0800, Morgan wrote: I need to put together an address book in excel, but I dont know how to do it alphabetically. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |