Microsoft Office Tutorials and References
In Depth Information
Copying or Moving Ranges
Copying or Moving Ranges
As you create a worksheet, you may fi nd it necessary to copy or move information from
one location to another. Excel makes copying or moving ranges of cells easy. Here are some
common things you might do:
Copy a cell to another location.
Copy a cell to a range of cells. The source cell is copied to every cell in the
destination range.
Copy a range to another range. Both ranges must be the same size.
Move a range of cells to another location.
The primary difference between copying and moving a range is the effect of the operation
on the source range. When you copy a range, the source range is unaffected. When you
move a range, the contents are removed from the source range.
Copying a cell normally copies the cell’s contents, any formatting that is applied to the original cell (including
conditional formatting and data validation), and the cell comment (if it has one). When you copy a cell that contains a
formula, the cell references in the copied formulas are changed automatically to be relative to their new destination.
Copying or moving consists of two steps (although shortcut methods are available):
1. Select the cell or range to copy (the source range), and copy it to the Clipboard.
To move the range instead of copying it, cut the range instead of copying it.
2. Move the cell pointer to the range that will hold the copy (the destination
range), and paste the Clipboard contents.
When you paste information, Excel overwrites any cells that get in the way without warning you. If you i nd that
pasting overwrote some essential cells, choose Undo from the Quick Access Toolbar (or press Ctrl+Z).
When you copy a cell or range, Excel surrounds the copied area with an animated border. As long as that border
remains animated, the copied information is available for pasting. If you press Esc to cancel the animated border,
Excel removes the information from the Clipboard.
Because copying (or moving) is used so often, Excel provides many different methods. I
discuss each method in the following sections. Copying and moving are similar operations, so
I point out only important differences between the two.
Search JabSto ::

Custom Search