For maximum flexibility in what gets pasted, choose Home?Clipboard?Paste (bottom half of button)?Paste Special to display the Paste Special dialog box (see Figure 14-19). You also can right-click and select Paste Special to display this dialog box. This dialog box has several options, which I explain in the following list.

FIGURE 14-19
The Paste Special dialog box.

• All: Pastes the cell’s contents, formats, and data validation from the Windows Clipboard.
• Formulas: Pastes values and formulas, with no formatting.
• Values: Pastes values and the results of formulas (no formatting). 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.
• Formats: Copies only the formatting.
• Comments: Copies only the cell comments from a cell or range. This option doesn’t copy cell contents or formatting.
• Validation: Copies the validation criteria so the same data validation will apply. Data validation is applied by choosing Data?Data Tools?Data Validation.
• All Using Source Theme: Pastes everything, but uses the formatting from the document theme of the source. This option is relevant only if you’re pasting information from a different workbook, and the workbook uses a different document theme than the active workbook.
• All Except Borders: Pastes everything except borders that appear in the source range.
• Column Widths: Pastes only column width information.
• Formulas And Number Formats: Pastes all values, formulas and number formats (but no other formatting).
• Values And Number Formats: Pastes all values and numeric formats, but not the formulas themselves.

In addition, the Paste Special dialog box enables you to perform other operations, described in the following sections.

• Top Best 100 Incredibly Useful & Free Mac Apps [/caption] Everyone loves free applications. One of the greatest things about Macs is the wealth of extremely talented developers that...
• Backtesting A Trading System The second method of Backtesting is performed manually and visually by the trader. The trader would take the historical data...
• Roger Federer and Credit Suisse Sponsorship In the long list of celebrities/sportspersons-corporate partnerships, the latest is the Roger Federer-Credit Suisse sponsorship joint program. The Credit Suisse...
• Excel How-to: Creating a Pivot Table A pivot table is a merely a summary of data in a format that you can manipulate to suit your...
• Backtesting With Backtesting, traders can actually test their trading strategies and how well they would have done if executed in the...