How to Enter and Change Data in Excel 2007

To get started working in Excel you need to enter data. What data you enter depends on what you want to do with the spreadsheet. If you were working on an address book, you could be entering names and addresses or you may want to make a budget, which means you would be entering expense categories and numbers. Read on to learn how to enter and change data in Excel.

Instructions

Difficulty: Moderately Easy

1. Decide what to use the spreadsheet for. In the following steps, we will create an address book.
2. Put in the headings. Go to column A and row 1, put in first name, in the next column--B1--enter last name, continue moving to the right and put in address--one column for the street, one for the city, one for the state and one for the zip code. This will make sorting easier when the time comes.
3. Start entering the names and addresses of your friends, families and anyone else you would have in your address book.
4. Enter the data in whatever order you have it. There isn't any need to enter your data in alphabetical order--you can sort when you are done.
5. Complete the list and sort the data, by first name, last name, city, state or zip code. You can do this in any order. You may want to have the data by last name and then state, or just by last name or just by state. There are multiple filters you can apply to sort your data in any order you chose.
6. Save the spreadsheet so you will have it available whenever you may need it. It will be extremely handy at Christmas or if you are having a party.
7. Change the data when you receive information about the people you have listed in the spreadsheet. If you know someone has moved, you can open the spreadsheet, go to the person's name, and change it. It may be a new last name--if someone gets married--or a new address.
8. Add additional data at any time. You may realize that you overlooked putting in telephone numbers or birthdays, you can always add new columns at any time. Just open the spreadsheet, add new column headings, and add the data for each of the people. Additionally, as you meet new people you can add them to your spreadsheet.

Tips & Warnings

• Always make sure you save the data when you make changes. Excel should ask you if you want to save the data before it will let you close it.
• If you don't want to overwrite the original file, go to "File" and "Save as" and it will save as or create a new file.

Who Can Help:

• Find Computer, Electrical and Telephone Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.
• Find Electrical Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.