Excel tools to demonstrate

Moving (Cutting and Pasting)

Often you would like to move information from one place in the sheet to another.

To move (cut and paste):

Select the range to be cut, press Ctrl-x (for cutting), select the upper left corner of the paste range, and press Ctrl-v. (The little finger-index finger combination in your left hand is also good for pressing Ctrl-x.)

As with copying and pasting, ribbon buttons can be used instead of key combinations, but either is more efficient than selecting menu items. Also, note that you need only select the upper left cell of the paste range. Excel knows that the shape of the paste range must be the same as the shape of the cut range.

Try it! Move the range A2:C8 to the range D2:F8. (Watch how relative addresses affect the eventual formulas in column F.)