Thursday, May 26, 2011

How to Make an Address Book in Excel


1. Click the 'Start' menu and go to 'All Programs.' Select 'Microsoft Office' followed by 'Microsoft Excel' to open Excel.
2. Type 'Name' in cell A1 of the spreadsheet, type 'Address' in cell B1 and type 'Phone Number' in cell C1.
3. Enter the data for your address book, starting in the second row. Enter the information based on the headers you create in Steps 2 through 4, so column A has the person's name, column B has the person's address and column C has the person's phone number. If you plan to alphabetize your address book, you may want to enter the names in a last-name-first format.
4. Click and hold the left mouse button on column A and move the cursor to column C to highlight columns A, B and C. Click 'Home' and 'Format.' Select 'AutoFit Column Width.' This makes all the columns fit to the longest text in a cell in the column.
5. Highlight A, B and C again. Click the 'Data' tab. Click the button with an A above a Z and the arrow pointing down. This sorts the data by the person's name in alphabetical order.
6. Click the 'Office' button and 'Save' to save your address book.

Blogger news