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

214 Copying and Moving Stuff Around
Table 3-1 (continued)
Option
Formulas and Number Formats
Values and Number Formats
All Merging Conditional Formats
None
Add Subtract Multiply Divide
Skip Blanks Transpose
Paste Link
What It Does
Pastes only the formulas and number formatting (omitting all text and numeric entries) from the cell selection into the paste area
Pastes only the numbers and number formatting (omit- ting all text and converting all formulas to their calculated values) from the cell selection into the paste area
Pastes only the numbers and number formatting that meets the conditions specified by conditional formatting in the cell selection (see Book II, Chapter 2)
Performs no mathematical operation between the values in the cell selection placed on the Clipboard and those in the destination range in the worksheet (the default)
Adds the values in the cell selection placed on the Clipboard to those in the destination range in the worksheet
Subtracts the values in the cell selection placed on the Clipboard from those in the destination range in the worksheet
Multiplies the values in the cell selection placed on the Clipboard with those in the destination range in the worksheet
Divides the values in the cell selection placed on the Clipboard by those in the destination range in the worksheet
Does not replace existing entries in the worksheet with any overlaying blank cells placed on the Clipboard as part of the cut or copied cell selection
Switches the orientation of the entries in the cell selec- tion placed on the Clipboard so that data that originally ran across the rows now runs down the columns in the new area of the worksheet and the data that ran down columns now runs across rows
Pastes links to the original cell selection placed on the Clipboard
The Transpose option, which appears on the Paste button’s drop-down menu and the Paste Options button (also duplicated by the Transpose