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
Fitting Entries in
An alternative to increasing
column widths or row
heights is to shrink the
characters in a cell to t the
current width of the column.
To shrink to t, tap or click
Format Cells: Alignment
Dialog Box Button Launcher
(HOME tab | Alignment
group) and then place a
check mark in the ‘Shrink
to t’ check box in the Text
control area (Format Cells
dialog box). After shrinking
entries to t in cells, consider
using the Zoom slider on the
status bar to make the entries
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 133, the What-If Assumptions will be placed below
the calculations in the worksheet. This will allow the reader to see the main section
of the worksheet when rst opening the workbook. 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 A19 (Margin) and A21 (Sales Revenue
for Bonus). Hence, the What-If Assumptions table row titles can be created by copying
the range A9:A13 to the range A19:A23 and then inserting two rows for the additional
entries in cells A19 and A21. The source area (range A9:A13) is not adjacent to the
destination area (range A19:A23). Thus, you cannot use the fill handle to copy the area.
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.
To Copy a Range of Cells to a
Nonadjacent Destination Area
1 ENTER HEADINGS & DATA | 2 ENTER FORMULAS & FUNCTIONS | 3 CREATE SPARKLINE CHARTS
4 FORMAT WORKSHEET | 5 CREATE COLUMN CHART | 6 CHANGE VIEWS | 7 ASK WHAT - IF QUESTIONS
The Copy button copies the contents and format of the source area to the Of ce Clipboard , a temporary
storage area in the computer’s memory that allows you to collect text and graphics from an office document and
then paste them into almost any other type of document. The Paste button pastes a copy of the contents of the
office Clipboard in the destination area. Why? Copying the range of cells rather than reentering the content assures
consistency within the worksheet.
The following steps enter the what-if area row heading and use the Copy and Paste buttons to copy the
range A9:A13 to the nonadjacent range A19:A23.
• With cell A18 selected, type
What-If Assumptions as
the new row title and then tap or
click the Enter box.
• Select the range A9:A13 and
then tap or click the Copy button
(HOME tab | Clipboard group) to
copy the values and formats of
the selected range, A9:A13 in this
case, to the office Clipboard.
• Select 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:23) before tapping or 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
A19:A23, the top cell of the destination
area (cell A19) also is the upper-left cell of the destination area.
top cell of
Figure 3 – 12