Microsoft Office Tutorials and References
In Depth Information
More About Pasting
• Click Formulas on
the Paste button
menu to copy the
SUM function in
cell B5 to the range
B6:B11 (Figure 6–48)
adjust the cell refer-
ences in the SUM
function to refer-
ence the correspond-
ing cells on the
three sheets in the
• Press the ESC key to
clear the marquee
surrounding cell B5
and then select
cell A14 to deselect
the range B6:B11.
total units on hand at
the three stores for each
brand of DVR
• Click the Save button
on the Quick Access
Toolbar to save
the NextDVR Proﬁ t
total units on
hand for entire
company proﬁ t
potential based on
current units on hand
of all three regions
If you click the Paste button on the Ribbon to complete the paste operation, rather
than using the Formulas command as shown in Figure 6–47 on the previous page, then any
formats assigned to cell B5 also will be copied to the range B6:B11. Completing the paste
operation by using the ﬁ ll handle or by pressing the ENTER key also will copy any formats
from the source area to the destination area. When you use the Formulas command on the
Paste button menu, Excel copies the SUM function, but not the format, assigned to cell B5.
In this example, the format assigned to cell B5 is the same as the format assigned to the
range B6:B11, so it does not matter if you use the Paste button or the Formulas command.
In many cases, however, the formats of the source area and destination area differ; the Paste
button menu, thus, is a useful option to complete the copy and paste operation. Table 6–8
summarizes the commands available on the Paste button menu, as shown in Figure 6–47.
Table 6–8 Paste Button Menu Commands
Pastes in the same manner as clicking the Paste button.
Pastes the formulas from the source area, but not the formats.
Pastes the value of the formula from the source area, but not the formulas or formats.
Pastes the formula and all formats from the source area, except for borders.