Copy specific cell contents or attributes in a worksheet

You can copy and paste specific cell contents or attributes (such as formulas, formats, or comments) from the Clipboard in a worksheet by using the Paste Special command.

Note    For more information about how to copy an entire worksheet (or sheet) to another location in the same workbook or to a different workbook, see Move or copy a worksheet. For more information about copying cells and their content, see Move or copy cells and cell contents.

  1. On a worksheet, select the cells that contain the data or attributes that you want to copy.

  2. On the Home tab, in the Clipboard group, click Copy Button image.

    Excel Ribbon Image

    Keyboard shortcut  You can also press CTRL+C.

  3. Select the upper-left cell of the paste area.

    Tip   To move or copy a selection to a different worksheet or workbook, click another worksheet tab or switch to another workbook, and then select the upper-left cell of the paste area.

  4. On the Home tab, in the Clipboard group, click Paste Button image, and then click Paste Special.

    Keyboard shortcut  You can also press CTRL+ALT+V.

  5. In the Paste Special dialog box, under Paste, do one of the following:

    • To paste static data, click the attribute of the copied data that you want.

Click this option

To

All

Paste all cell contents and formatting.

Formulas

Paste only the formulas as entered in the formula bar.

Values

Paste only the values as displayed in the cells.

Formats

Paste only cell formatting.

Comments

Paste only comments attached to the cell.

Validation

Paste data validation rules for the copied cells to the paste area.

All using Source theme

Paste all cell contents and formatting using the theme that was applied to the source data.

All except borders

Paste all cell contents in the document theme formatting that is applied to the copied data.

Column widths

Paste the width of one column or range of columns to another column or range of columns.

Formulas and number formats

Paste only formulas and number formatting options from the selected cells.

Values and number formats

Paste only values and number formatting options from the selected cells.

  • To paste linked data, click All or All except borders.

  • Do any of the following as needed:

    • To mathematically combine the contents of the with the contents of the paste area, under Operation, specify the mathematical operation that you want to apply to the copied data.

Click this option

To

None

Paste the contents of the copy area without a mathematical operation.

Add

Add the values in the copy area to the values in the paste area.

Subtract

Subtract the values in the copy area from the values in the paste area.

Multiply

Multiply the values in the paste area by the values in the copy area.

Divide

Divide the values in the paste area by the values in the copy area.

  • Note   Mathematical operations can be applied only to values. To use an option other than None, you must select All, Values, All except border, or Values and number formats under Paste.

  • To avoid replacing values in your paste area when blank cells occur in the copy area, select Skip blanks.

  • To change columns of copied data to rows, or vice versa, select Transpose.

    Note    Depending on the type of data that you copy and the Paste options that you select, specific options might be unavailable.

  • If you want to link the pasted data to the original data, click Paste Link.

    When you paste a link to the data that you copied, Excel enters an absolute reference to the copied cell or range of cells in the new location.

    Note    Paste Link is available only when you select All or All except borders under Paste in the Paste Special dialog box.

Tip   You can also insert copied formulas, values, or linked data in the paste area by clicking Paste (on the Home tab, in the Clipboard group), and then clicking Formulas, Paste Values, or Paste Link.

Applies To: Excel 2010



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language