Microsoft Office Tutorials and References
In Depth Information
Copying a Range of Cells to a Nonadjacent Destination Area
To Copy a Range of Cells to a Nonadjacent Destination Area
The following steps use the Copy and Paste buttons to copy the range A9:A13 to the nonadjacent range A19:A23.
• Select the range A9:A13 and
then click the Copy button on
the Home tab on the Ribbon to
copy the values and formats of
the range A9:A13 to the Ofﬁ ce
• Click cell A19, the top cell in the
destination area (Figure 3–12).
Why do I not need to select the
entire destination area?
You are not required to select the
entire destination area (range
A19:A23) before clicking the Paste
button. Excel needs to know only
the upper-left cell of the
destination area. In the case of a single
column range, such as A19:A23,
the top cell of the destination area
(cell A19) also is the upper-left cell
of the destination area.
top cell of