Chapter 1 Getting Started with Excel 173 Drag the selected area down two cells, so that the new range is now
B6:F19, and release the mouse button.
Note that as you moved the selected range, Excel displayed a screen
tip with the new location of the range.
4 Click F19 to deselect the cell range.
When you look at the formula bar for cell F19, note that the formula is
now changed from =SUM(F4:F17) to =SUM(F7:F18). Excel will automati-
cally update the cell references in your formulas to account for the fact that
you moved the cell range.
You can also use the Cut, Copy, and Paste buttons to move a cell range.
These buttons are essential if you want to move a cell range to a new work-
book or worksheet (you can’t use the drag and drop technique to perform
that action). Try using the Cut and Paste method to move the table back to
its original location.
To cut and paste a range of cells:1 Select the range B6:F19.
2 Click the Cut button from the Clipboard group on the Home tab or
press CTRL+x.
A fl ashing border appears around the cell range, indicating that it
has been cut or copied from the worksheet.
3 Click B4.
4 Click the Paste button from the Clipboard group on the Home tab
or press CTRL+v.
The table now appears back in the cell range, B4:F17.
5 Click cell A1 to make A1 the active cell again.
If you want to copy a cell range rather than move it, you can use the Copy
button in the above steps, or if you prefer the drag and drop technique,
hold down the CTRL key while dragging the cell range to its new location;
this will create a copy of the original cell range at the new location. You can
refer to Excel’s online Help for more information.