Monday, July 23, 2012

How to Move Columns in Excel


1. Choose the column heading (1, 2, 3 and so forth) that you want to move and highlight it. You can also select several columns by holding down your left mouse button and sliding it across the columns which you would like to select, in case you want to move more than one column at a time.
2. Leave your mouse placed on the highlighted column(s) and right click your mouse button. This will bring up a pop up menu with several options to choose from.
3. Pick 'Cut' from the menu that pops up. This will make the column you want to move disappear, but your computer will store it in its temporary memory. As long as you don't cut anything else or close the program, your information will not be lost.
4. Select the column that is directly to the right of where you want your selected column to be placed, so that it is highlighted. This is how you let your computer know where you want to place the row that you are moving.
5. Go to the 'Insert' menu and click on the 'Cut Cells' option. The column(s) that you chose to cut will be pasted into your selected area.

Blogger news