Tuesday, June 11, 2013

How to Move Rows in Excel


1. Select the row heading (A, B, C and so forth) that you wish to move and highlight it. You can also select several rows by holding down your left mouse button and sliding it across the rows which you would like to select, if you want to move more than one row at a time.
2. Keep your mouse placed on the highlighted row(s) and right click your mouse button. This will bring up a pop up menu with several options to choose from.
3. Choose 'Cut' from the menu that pops up. This will make the row 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. Pick the row that is directly below where you want your selected row 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. Locate the Insert menu and click on the 'Cut Cells' option. The row(s) that you chose to cut will be pasted into your selected area.

Blogger news