How to Move Data on an Excel 2007 Worksheet

You often create worksheets--or spreadsheets--and then find that you want the data displayed in a different way. You could create a new worksheet in the format you want; alternatively you can move the data around until you get the desired effect. Read on to learn how to move data in an Excel 2007 worksheet.

Instructions

Difficulty: Moderately Easy

1. Open the worksheet you want to change. Find the document in your saved documents and select it--double click twice on it. The worksheet will then open in Excel.
2. Decide what actions you want to do. For example, you may have made a file that is your address book. When you first put the file together, you put in columns in the following order: first name, last name, phone number, address, city, state and zip code. You now see that it would be easier if you had arranged the data this way: last name, first name, address, city, state, zip code and phone number.
3. Add a column. Put your cursor anywhere in column A. Go to "Insert" and choose "Column." A new column will appear and your data will now start in column B.
4. Select the column with last names in it by clicking on the letter that has your data in it. This will select the whole column of data--for example, if your last names are in column C by selecting C at the top of the column all the data will be highlighted.
5. Right click your mouse and a menu will come up where you can "Cut" the data. This will make the data disappear from column C. Move your cursor to column A row 1 and right click. Select "Paste" and your data will be moved to that column.
6. Delete column C to reposition the data. Your data now appears this way: last name, first name, phone number, address, city, state and zip code.
7. Repeat Steps 4 to 6 to move phone number from column C to column G and the data will be in the proper columns.
8. Save your data by either selecting "Save" or "Save as."

Tips & Warnings

• When you save the file, you may want to use "Save as" to create a new file rather than overwrite your other file.
• Remember you have an undo button--use it if you accidentally do something that you didn't want to do.
• Data can also be moved between cells or rows as easily as it is done in columns.

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.