Microsoft Office Tutorials and References
In Depth Information
Using the Paste Special dialog box
The paste options are:
Paste (P): Pastes the cell’s contents, formats, and data validation from the
Windows Clipboard.
Formulas (F): Pastes formulas but not formatting.
Formulas & Number Formatting (O): Pastes formulas and number formatting only.
Keep Source Formatting (K): Pastes formulas and all formatting.
No Borders (B): Pastes everything except borders that appear in the source range.
Keep Source Column Width (W): Pastes formulas and duplicates the column width
of the copied cells.
Transpose (T): 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.
Merge Conditional Formatting (G): This icon is displayed only when the copied
cells contain conditional formatting. When clicked, it merges the copied
conditional formatting with any conditional formatting in the destination range.
Values (V): Pastes the results of formulas. The destination for the copy can be a
new range or the original range. In the latter case, Excel replaces the original
formulas with their current values.
Values & Number Formatting (A): Pastes the results of formulas plus the number
formatting.
Values & Source Formatting (E): Pastes the results of formulas plus all formatting.
Formatting (R): Pastes only the formatting of the source range.
Paste Link (N): Creates formulas in the destination range that refer to the cells in
the copied range.
Picture (U): Pastes the copied information as a picture.
Linked Picture (I): Pastes the copied information as a “live” picture that is
updated if the source range is changed.
Paste Special: Displays the Paste Special dialog box (described in the next section).
After you paste, you’re offered another chance to change your mind. A Paste Options button appears at the lower
right of the pasted range. Click it (or press Ctrl), and you see the paste option icons again.
Using the Paste Special dialog box
For yet another pasting method, choose Home
Paste Special to
display the Paste Special dialog box (see Figure 14.20). You can also right-click and choose
Paste Special from the shortcut menu to display this dialog box. This dialog box has several
options, explained next.
Clipboard
Paste
Search JabSto ::




Custom Search