Microsoft Office Tutorials and References
In Depth Information
Moving the selection to the range A5:G9
the new location
of the selected cells
cell reference of the new location
is displayed in a ScreenTip
3. When the ScreenTip displays “A5:G9,” release the left mouse button. The order data is now
moved to range A5:G9.
Trouble? If you selected the wrong range or moved the selection to the wrong location,
click the Undo button
on the Standard toolbar, and then repeat Steps 1 through 3.
4. Click cell A1 to remove the selection and to make cell A1 the active cell so you can enter
the new titles in the worksheet.
5. Type Dalton Food Co-op in cell A1, List of Orders in cell A2, April, 2006 in cell A3, and
then press the Enter key. Note that moving the cell range had no impact on the values in
the worksheet; the values shown by the formulas in column G are also unchanged. This is
because Excel automatically updated the cell references in the formulas to reflect the new
location of the data. To confirm this, you’ll examine the formula in cell G6.
6. Click cell G6 and observe what is displayed in the Formula bar. The formula in cell G6 is
now =E6*F6 . Recall that when you originally entered Alison Wilke’s order, the formula for
this cell was =E2*G2 because the order was originally placed in the second row of the
worksheet. When you moved the data, Excel automatically updated the formula to reflect
the new location of Alison Wilke’s order.
The technique you used to move the cell range is called “drag and drop.” You can also
use the drag-and-drop technique to copy a cell range. Copying a range of cells is similar
to moving a range, except that you must press the Ctrl key while you drag the selection to
its new location. A copy of the original data will then appear at the location of the pointer
when you release the mouse button. You’ll learn more about copying and pasting in the
next two tutorials.