Copy and paste specific cell contents

You can copy and paste specific cell contents or attributes (such as formulas, formats, or comments) by using the Paste Special command. Attributes other than what you select are excluded when you paste.

  1. Select the cells that contain the data or other attributes that you want to copy.

  2. On the Standard toolbar, click Copy  Copy button.

  3. Click the first cell in the area where you want to paste what you copied.

  4. On the Home tab, under Edit, click Paste, and then click Paste Special.

    Home tab, Edit group

  5. On the Paste Special dialog, under Paste, do any of the following:

Click

To

All

Paste all cell contents and formatting, including linked data.

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 and formatting except cell borders.

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.

Merge conditional formatting

Combine conditional formatting from the copied cells with conditional formatting present in the paste area.

  1. To mathematically combine values between the copy and paste areas, under Operation, click the mathematical operation that you want to apply to the data that you copied.

Click

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.

  1. Additional options determine how blank cells are handled when pasted, whether copied data is pasted as rows or columns, and linking the pasted data to the copied data.

Click

To

Skip blanks

Avoid replacing values in your paste area when blank cells occur in the copy area.

Transpose

Change columns of copied data to rows, or vice versa.

Paste Link

Link the pasted data to the original data. 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   This option is available only when you select All or All except borders under Paste in the Paste Special dialog box.

See also

Move or copy a sheet

Move or copy cells, rows, or columns



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