Microsoft Office Tutorials and References
In Depth Information
To Copy 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.
1
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 Offi ce
Clipboard.
Paste button
Cut button
Click cell A19, the top cell in the
destination area (Figure 3–12).
Copy button
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 destina-
tion 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.
source area
surrounded
by marquee
top cell of
destination area
Figure 3–12
 
 
Search JabSto ::




Custom Search