Microsoft Office Tutorials and References
In Depth Information
Using the Paste Special dialog box
All Except Borders: Pastes everything except borders that appear in the source
Column Widths: Pastes only column width information
Formulas and Number Formats: Pastes all values, formulas, and number formats
(but no other formatting)
Values and Number Formats: Pastes all values and numeric formats but not the
All merging conditional formats: Merges the copied conditional formatting with
any conditional formatting in the destination range. This option is enabled only
when you’re copying a range that contains conditional formatting.
In addition, the Paste Special dialog box enables you to perform other operations, described
in the following sections.
Performing mathematical operations without formulas
The option buttons in the Operation section of the Paste Special dialog box let you perform
an arithmetic operation on values and formulas in the destination range. For example, you
can copy a range to another range and select the Multiply operation. Excel multiplies the
corresponding values in the source range and the destination range and replaces the
destination range with the new values.
This feature also works with a single copied cell, pasted to a multi-cell range. Assume that
you have a range of values, and you want to increase each value by 5 percent. Enter 105%
into any blank cell and copy that cell to the Clipboard. Then select the range of values and
bring up the Paste Special dialog box. Select the Multiply option, and each value in the
range is multiplied by 105%.
If the destination range contains formulas, the formulas are also modii ed. In many cases, this is not what you want.
Skipping blanks when pasting
The Skip Blanks option in the Paste Special dialog box prevents Excel from overwriting cell
contents in your paste area with blank cells from the copied range. This option is useful if
you’re copying a range to another area but don’t want the blank cells in the copied range to
overwrite existing data.
Transposing a range
The Transpose option in the Paste Special dialog box changes the orientation of the copied
range. Rows become columns, and columns become rows. Any formulas in the copied range
are adjusted so that they work properly when transposed. Note that you can use this check
box with the other options in the Paste Special dialog box.