Microsoft Office Tutorials and References

In Depth Information

**Fancy Pasting Tricks**

Moving Cells Around

•
Keep Source Column Widths
. This option copies all the data and formatting

(just like an ordinary paste), but it also adjusts the columns in the paste region

so that it has the same widths as the source columns.

•
Transpose
. This option inverts your information before it pastes it, so that all

the columns become rows and the rows become columns. Figure 15-8 shows

an example.

Figure 15-8:

With the Transpose

option (from the

Paste Special dialog

box), Excel pastes the

table at the top and

transposes it on the

bottom.

The second group of paste options, called Paste Values, includes three choices:

•
Values
. This option pastes only cell content—numbers, dates, and text—with-

out any formatting. If your source range includes any formulas, Excel pastes the

result
of those formulas (the calculated number) but not the actual formulas.

(You’ll learn everything you need to know about formulas in Chapter 17.)

•
Values and Number Formatting
. This option pastes the cell content and the

formatting settings that control how numbers appear. If your source range

includes any formulas, Excel pastes the calculated result of those formulas but not

the actual formulas.

•
Values and Source Formatting
. This option is the same as a normal paste

operation, except it doesn’t copy formulas. Instead, it pastes the calculated result

of any formulas.

The third group of paste options, called Other Paste Options, includes four choices

that are little more specialized and a little less common:

•
Formatting
. This option applies the formatting from the source selection, but it

doesn’t actually copy any data.

•
Paste Link
This option pastes a
link
in each cell that refers to the original data.
.

(By comparison, an ordinary paste creates a duplicate
copy
of the source

content.) If you use this option and then modify a value in one of the source cells,

Excel automatically modifies the copy, too. (In fact, if you take a closer look at

the copied cells in the formula bar, you’ll find that they don’t contain the actual

data. Instead, they contain a formula that points to the source cell. For example,