Excel
I need to put together an address book in excel, but I dont know how to do it
alphabetically. |
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 |
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. |
All times are GMT +1. The time now is 05:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com