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
With the Transpose
option (from the
Paste Special dialog
box), Excel pastes the
table at the top and
transposes it on the
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,