Monday, December 10, 2007

Creating an Address Book in Microsoft Excel

Before you begin you need to have some family, friends, and business associates that are worth writing to.  If you don't have any you can count me as a friend.

1. Click Start.

2. Click your mouse over All Programs.

3. Click Microsoft Excel. 

Before you continue I have been commanded by the class to put in some hints and tricks here.

• You will have to change the width of the column in Microsoft Excel.  Here is how you change the width.

  • Place the mouse on top of the column.  For this example I would place my mouse on top of the C. 

  • Click on >Format >Column >Auto FitSelection. 

• Here is how to make corrections.

  • Go up to the top next fx to make corrections. 

  • Click in the white box and make spelling corrections, deletions, or additions.

4. In the cell A1 type the words "First Name." 

5. In the cell B1 type the words "Last Name." 

6. In the cell C1 type the word "address."

7. In the cell D1 type the word "city."

8. In the cell E1 type the word "state."

9. In the cell F1 type the words "zip code."

10. In the cell G1 type the  word "relationship."

11. It should look like this. 

12. Fill in the boxes with at least 5 different people.

13. When you are done click file.

14. Click save.

15. Click Ok.