How to Modify a Worksheet in Excel 2007

1. Determine what you need to modify. You have just received correspondence from some of your friends that have changed their address. You now need to update their information in your workbook.
2. Open your worksheet and find the information that needs to be modified.
3. Click on 'Edit' and 'Find and Replace'. When the box appears type in the first or last name of the person you need to locate in the 'Find' box and click ok.
4. Let Excel find and take you to the information.
5. Select the columns that need to be updated. Fill in the new street, city, state and zip code with the new information.
6. Decide if you need to add more information. If your friends have included their phone number in the new information that they sent you, but you haven't put in a column for phone numbers, you can add this column now.
7. Add the new column. Go to the title row and type in a heading such as phone. You can then go back to the row you were in and add the phone number that you have just received.
8. Continue to add new information, by adding new columns or rows to the information that is already there. This is all it takes to modify your worksheet.