How To Copy Data From One Cell To Another In Excel Using Formula

Excel for Microsoft 365 for Mac Excel 2021 for Mac Excel 2019 for Mac Excel 2016 for Mac More...Less

When y'all copy formulas to another location, you tin choose formula-specific paste options in the destination cells.

Hither'south how you copy and paste a formula:

Select the cell with the formula y'all desire to copy.
Press + C.
Click the cell where you lot desire to paste the formula.

If that cell is on another worksheet, go to that worksheet and click the cell you want.
To rapidly paste the formula with its formatting, press + Five. Or, you can click the pointer next to the Paste push:
Clicking the pointer gives you a list of options. Here are the near commonly used ones:
- Formulas — to paste just the formula and not the formatting of the original jail cell.
- Formulas & Number Formatting — to paste but the formula, and the number formatting (for example: percent format, currency format, and so on).
- Continue Source Formatting — to paste the formula, the number formatting, font, font size, edge, and shading of the original cell.
- Paste Values — to exclude the formula and paste just the result.
Other options available to you that might be useful:
- No Borders — to paste the formula, the number formatting, font, font size, shading--but not the edge of the original.
- Go along Source Column Widths — to paste the formula, the number formatting, font, font size, shading, edge, and the width of the original.
- Transpose — Use this selection when copying more than one cell. If you copy cells that are side-past-side in a row, and then this option will paste them in a cavalcade. If the cells are in a cavalcade, they'll exist pasted into side-past-side in a row. This choice pastes the formula, the number formatting, font, font size, shading, edge.

Verify and fix prison cell references in the new location

Afterwards copying a formula to a new location, information technology'due south important to check that its jail cell references are correct. The prison cell references may have inverse according to the absolute or relative reference type that you use.

Formula being copied from A1, to two cells down and to the right

For case, if you lot copy a formula 2 cells down and to the right of cell A1, so the cells references you used will exist updated like this:

This reference:	Changes to:
$A$ane (absolute column and absolute row)	$A$ane
A$ane (relative column and absolute row)	C$one
$A1 (absolute column and relative row)	$A3
A1 (relative column and relative row)	C3

If prison cell references in the formula don't give you the result you want, endeavor switching to different reference types.

Select the prison cell with the formula.
Select the reference you desire to change in the formula bar:
Press F4 to switch between the accented and relative reference combinations, and choice the ane you want.

Motion a formula to another location

Different copying a formula, when yous move a formula to another location in the same or another worksheet, the cell references in the formula don't change, regardless of what type of cell reference y'all used.

Select the cell that has the formula you want to move.
Press + X.
Click the cell where you lot want to paste the formula.

If that cell is on another worksheet, become to that worksheet and click the cell you want.
To paste the formula with its formatting, on the Home tab, click Paste or printing + V.

For other formula paste options, click the arrow below Paste. You accept many options here, but the most normally used ones are:
- Go on Source Formatting to paste the formula, the number formatting, font, font size, border, and shading of the original cell.
- Values & Source Formatting to paste the values and the formatting only. The formula volition exist excluded.

Demand more help?