Part I: Getting Started with Excel
88
l (^) Formats: Copies only the formatting.
l Comments: Copies only the cell comments from a cell or range. This option doesn’t copy
cell contents or formatting.
l Validation: Copies the validation criteria so the same data validation will apply. Data vali-
dation is applied by choosing Data ➪ Data Tools ➪ Data Validation.
l All Using Source Theme: Pastes everything, but uses the formatting from the document
theme of the source. This option is relevant only if you’re pasting information from a dif-
ferent workbook, and the workbook uses a different document theme than the active
workbook.
l All Except Borders: Pastes everything except borders that appear in the source range.
l (^) Column Widths: Pastes only column width information.
l Formulas and Number Formats: Pastes all values, formulas and number formats (but no
other formatting).
l Values and Number Formats: Pastes all values and numeric formats, but not the formu-
las themselves.
l All merging conditional formats: Merges the copied conditional formatting with any
conditional formatting in the destination range. This option is enabled only when you are
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 arith-
metic 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 percent.Warning
If the destination range contains formulas, the formulas are also modified. In many cases, this is not what
you want. n