M
Morgan
I need to put together an address book in excel, but I dont know how to do it
alphabetically.
alphabetically.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
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
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
G
Gord Dibben
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 Data>Sort>Sort 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
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 Data>Sort>Sort 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