Page 129 - Excel 2007 Bible

09_044039 ch05.qxp 11/21/06 10:56 AM Page 86
Part I
Getting Started with Excel
n Formulas And Number Formats: Pastes all values, formulas and number formats (but no other
formatting).
n Values And Number Formats: Pastes all values and numeric formats, but not the formulas
themselves.
In addition, the Paste Special dialog box enables you to perform other operations, described in the follow-
ing 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. 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 destina-
tion range with the new values.
This feature also works with a single copied cell, pasted to a 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
WARNING
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. Figure 5.11 shows an example of a horizontal range (A1:F1) that was transposed to a
vertical range (A3:A8).
FIGURE 5.11
Transposing a range changes the orientation as the information is pasted into the worksheet.

86