Page 231 - Excel 2013 All-in-One For Dummies

Copying and Moving Stuff Around 213
The options in the Paste Special dialog box are divided into two areas: Paste and Operation. The Paste option buttons (some of which duplicate the options on the drop-down menu on the Ribbon and the Paste Option’s palette in the worksheet) enable you to specify which components of the copied cell selection you want copied; see Table 3-1 for a list of options.
The Operation option buttons in the Paste Special dialog box enable you to specify which mathematical operation, if any, should be performed between the overlaying values in copy and paste ranges. Select the Skip Blanks check box when you don’t want Excel to replace existing entries in the paste range with overlaying blank cells in the copy range.
Table 3-1
Option
All
Formulas Values
Formats Comments Validation
All Using Source Theme
All Except Borders Column Widths
The Paste Special Dialog Box Options
What It Does
Pastes all types of entries (numbers, formulas, and text), their formats, and comments from the selection in the paste area
Pastes only the entries (numbers, formulas, and text) from the selection in the paste area
Pastes only numbers and text from the selection in the paste area, converting all formulas to their current cal- culated values so they’re pasted into the worksheet as numbers
Pastes only the formats from the selection into the paste area
Pastes only the comments from the selection into the paste area
Pastes only the entries in cells that use Data Validation in the paste area (see Book II, Chapter 1 for info on Data Validation)
Pastes all types of entries (numbers, formulas, and text), their formats, and comments from the selection in the paste area and uses the colors, fonts, and graphic effects in the theme assigned to their source worksheet (see Book V, Chapter 2)
Pastes everything but the borders assigned to the cell selection into the paste area
Pastes everything into the paste area and adjusts the column widths in this area to match those of the original cell selection
(continued)
Book II Chapter 3
Editing and Proofing Worksheets