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

range

■

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

formulas themselves

■

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.