See all How-To Articles

Copy Number Not Formula – Excel & Google Sheets

This tutorial demonstrates how to copy a number without its formula in Excel and Google Sheets.

copy number not formula initial data

 

Copy-Paste Values

In Excel, if you copy a cell containing a formula to another location, using the simple copy-paste method, you will copy the formula, not a number. Say you have the following formula in cell B4.

 

copy number not formula initial data

 

The result of the SUM Function in cell B4 is 30. If you want to copy this number to cell C4 and not the formula, follow these steps:

  1. Right-click the cell you want to copy (B4), and click Copy (or use the keyboard shortcut CTRL + C).

 

copy number not formula 1

 

  1. Right-click the cell where you want to paste the number (C4), and click the Paste values icon (or use the keyboard shortcut).

 

copy number not formula 2

 

As a result, only the number, and not the formula, is pasted.

 

copy number not formula final data

 

Note: If you use the simple paste (CTRL + V), the formula from B4 is copied with updated cell references (C1:C3), and the result would be 0.

 

copy number not formula 3

 

Copy-Paste Values in Google Sheets

In a similar way, you can copy just the number in Google Sheets.

  1. Right-click the cell you want to copy (B4), and click Copy (or use the keyboard shortcut CTRL + C).

 

google sheets copy number not formula 1

 

  1. Right-click the cell where you want to paste a number (C4), click Paste special, and choose Values only (or use the keyboard shortcut CTRL + SHIFT + V).

 

google sheets copy number not formula 2

 

As a result, only the result of the formula (30) is copied from B4 to C4.

 

google sheets copy number not formula 3