Microsoft Office Tutorials and References
In Depth Information
Copying a Range of Cells to a Nonadjacent Destination Area
Copying a Range of Cells to a Nonadjacent
The What-If Assumptions section should be placed in an area of the worksheet that is
accessible easily yet does not impair the view of the main section of the worksheet. As
shown in Figure 3 – 3a on page EX 142, the What-If Assumptions should be placed above
the calculations in the worksheet. Additionally, the row titles in the Expenses area are
the same as the row titles in the What-If Assumptions table, with the exception of the
two additional entries in cells A4 (Margin) and A7 (Sales Revenue for Bonus). Hence, the
What-If Assumptions table row titles can be created by copying the range A16:A20
to the range A2:A6 and then inserting two rows for the additional entries in cells A4
and A7. The source area (range A16:A20) is not adjacent to the destination area (range
A2:A6). The i rst two chapters used the i ll handle to copy a source area to an adjacent
destination area. To copy a source area to a nonadjacent destination area, however, you
cannot use the i ll handle.
A more versatile method of copying a source area is to use the Copy button and
Paste button (Home tab | Clipboard group). You can use these two buttons to copy a
source area to an adjacent or nonadjacent destination area.
Fitting Entries in a Cell
An alternative to
increasing column widths
or row heights is to shrink
the characters in a cell
to i t the current width
of the column. To shrink
to i t, click Format Cells:
Alignment Dialog Box
Button Launcher (Home
tab | Alignment group),
and click Shrink to i t in
the Text control area.
After shrinking entries to
i t in cells, consider using
the Zoom slider on the
status bar to make the
entries more readable.
To Copy a Range of Cells to a Nonadjacent Destination Area
The Copy button copies the contents and format of the source area to the Ofi ce Clipboard , a reserved place
in the computer’s memory that allows you to collect text and graphics from an Ofi ce document and then paste
them into almost any other type of document. The Paste button copies the item from the Ofi ce Clipboard to the
The following steps enter the what-if area row heading and use the Copy and Paste buttons to copy the range
A16:A20 to the nonadjacent range A2:A6.
With cell A1 selected, type
as the new row title.
• click the Copy button (Home tab |
Clipboard group) to copy the values
and formats of the selected range,
A16:A20 in this case, to the Ofi ce
Select the range A16:A20 and then
top cell of destination area
Select cell A2, 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
A2:A6) before clicking the Paste
button (Home tab | Clipboard
group). Excel needs to know only
the upper-left cell of the destination
area. In the case of a single column
range, such as A2:A6, the top cell
of the destination area (cell A2)
also is the upper-left cell of the
Figure 3 –12