Tuesday, February 12, 2013

How to Move Data on an Excel 2007 Worksheet


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.'

Blogger news