Microsoft Office Tutorials and References
In Depth Information
Specify how to paste with
You can use the Format Painter to copy formats from
one cell to another. You can also use Paste Special.
Simply copy a cell with the format you want, and
then use Paste Special to paste the format into other
cells. See Chapter 7 to learn more about the Format
You can use the same steps to copy formulas or
values from one location in your worksheet to
another. When you want to use a cell’s formula in
other cells in your worksheet, paste the formula.
When you want the results of a formula but not the
formula itself, paste the value.
You can also use Paste Special to perform simple
arithmetic operations on each cell in a range. For
example, in a list of prices, you may want to increase
every price by 10 percent. You can use Paste Special
to make the change quickly. Just type 1.10 in a
cell and then select Multiply in the Paste Special
Click in a cell with the format,
formula, or value you want to
Click the Copy button.
Place the cursor in the cell(s)
into which you want to paste.
A menu appears.
Click Paste Special.
The Paste Special dialog box
Click to select a Paste option
( changes to ).
This example copies a formula.