By default once you copy (or cut) and also paste in Excel, every little thing in the source cell or range—data, formatting, formulas, validation, comments—is pasted come the destination cell(s). This is what happens when you push CTRL+V come paste. Because that could not be what friend want, friend have many other dough options, depending on what girlfriend copy.

You are watching: Pastes the contents and format of the source area

For example, you could want to dough the components of a cell, yet not that is formatting. Or perhaps you want to transpose the pasted data indigenous rows to columns. Or, you can need to dough the an outcome of a formula instead of the formula itself.


Important: When girlfriend copy and also paste formulas, you can need to solve cell references. However, references are not changed when you cut and also paste formulas.


Tip: You can also use the fill manage to copy a formula into nearby cells on the worksheet.


*


WindowsWeb

Paste menu options (on the ribbon)

Select Home, choose the clipboard icon (Paste) and also pick the details paste choice you want. For example, come paste just formatting native the copied cell, select Formatting . This table reflects the options easily accessible in the dough menu:

Icon

Option name

What is pasted

Paste

All cell contents.

*

Keep resource Column Widths

Copied cabinet content in addition to its obelisk width.

Transpose

Reorients the contents of duplicated cells once pasting. Data in rows is pasted into columns and vice versa.

Formulas

Formula(s), without formatting or comments.

Values

Formula results, without formatting or comments.

Formatting

Only the formatting indigenous the copied cells.

*

Values & resource Formatting

Values and also formatting from duplicated cells.

*

Paste Link

Reference come the source cells instead of the copied cell contents.

*

Picture

Copied image.

*

Linked Picture

Copied image with a connect to the initial cells (if friend make any kind of changes to the original cells those transforms are reflect in the pasted image).

Paste Special

To use alternatives from the Paste one-of-a-kind box, select Home, pick the clipboard icon (Paste), and select Paste Special.

Keyboard Shortcut: press Ctrl+Alt+V.

*

In the Paste Special box, choose the attribute you want to paste.


Note: Depending top top the kind of data girlfriend copied and also the Paste choice you picked, some other alternatives might be grayed out.


Paste option

Action

All

Pastes every cell contents and also formatting that the duplicated data.

Formulas

Pastes only the recipe of the duplicated data as entered in the formula bar.

Values

Pastes only the worths of the copied data as shown in the cells.

Formats

Pastes just cell formatting that the duplicated data.

Comments and Notes

Pastes just comments and also notes attached come the duplicated cell.

Validation

Pastes data validation rules because that the duplicated cells come the dough area.

All using source theme

Pastes all cell components in the paper theme formatting the is used to the duplicated data.

All except borders

Pastes all cell contents and also formatting used to the copied cell except borders.

Column widths

Pastes the width of one replicated column or range of columns to another column or variety of columns.

Formulas and also number formats

Pastes only formulas and also all number formatting choices from the replicated cells.

Values and number formats

Pastes just values and all number formatting choices from the replicated cells.

All merger conditional formats

Pastes the contents and conditional formatting alternatives from the duplicated cells.

You can also specify a mathematical procedure to use to the replicated data.

Operation

Action

None

Specifies the no mathematical procedure will be applied to the copied data.

Add

Adds the duplicated data come the data in the location cell or variety of cells.

Subtract

Subtracts the duplicated data from the data in the location cell or variety of cells.

Multiply

Multiplies the duplicated data with the data in the destination cell or variety of cells.

Divide

Divides the duplicated data by the data in the location cell or range of cells.

Other options

Action

Skip blanks

Avoids replacing worths in your dough area when blank cells occur in the copy area when you choose this examine box.

Transpose

Changes columns of duplicated data come rows and also vice versa once you select this check box.

Paste Link

Click to create a attach to the duplicated cell(s).

Verify and fix cell references in a pasted formula


After you paste a copied formula, you have to verify that all cell recommendations are exactly in the new location. The cabinet references might have readjusted based ~ above the reference kind (absolute, relative, or mixed) offered in the formula.

*
 

For example, if girlfriend copy a formula in cabinet A1 and paste it 2 cells down and to the appropriate (C3), cell references in the pasted formula will adjust as follows:

This reference:

Changes to:

$A$1 (absolute column and absolute row)

$A$1

A$1 (relative column and absolute row)

C$1

$A1 (absolute column and relative row)

$A3

A1 (relative column and also relative row)

C3

If cell referrals in the formula don’t provide you the an outcome you want, shot switching to different reference types:

Select the cell containing the formula.

In the formula bar

*
, pick the reference you desire to change.

Press F4 come switch in between the reference combinations, and also choose the one girlfriend want.

For more information around cell references, see outline of formulas.


When friend copy in Excel for the web, you can pick paste choices in the destination cells.

Select Home, select the clipboard icon, select Paste, and also pick the details paste choice you want. Because that example, come paste just formatting native the copied cell, select Paste Formatting . This table shows the options obtainable in the dough menu:

Icon

Option name

What is pasted

Paste

All cabinet contents.

Paste Formulas

Formula(s), without formatting.

Paste Values

Formula results, there is no formatting.

Paste Formatting

Only the formatting native the copied cells.

Paste Transpose

All cabinet content, yet reorients the content as soon as pasting. Data in rows is pasted right into columns and vice versa.

See more: Who Wrote The Song Sara Smile


Need an ext help?

You can always ask an expert in the Excel technology Community or get dearteassociazione.org in the answers community.