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.