How to copy numbers or values without formulas in Excel?

When you copy numbers that are calculated results of formulas to other cells, those numbers will be changed after you pasting, because normally you copy those formulas instead of their calculated results. This article will guide you to copy the calculated results of formulas without changing values in Excel.

Copy numbers or values without copying formulas in cells with Paste Special command

Copy numbers or values without copying formulas in cells with Kutools for Excel

Copy numbers or formulas without changing cell references with Kutools for Excel


Copy and paste formulas without changing cell references:

With Kutools for Excel's Exact Copy utility, you can quickly copy and paste the formulas into any cells without changing the calculated results.

doc copy without formulas 9


arrow blue right bubble Copy numbers or values without copying formulas in cells with Paste Special command


If you just want to copy the calculated results without copying their formulas, you can use Paste Special command as follows to copy numbers without copying formulas, but it will clear any formulas and formatting.

1. Select and copy numbers which you want to paste without formulas.

2. Select a cell, and right click on it. Then click the Values option under Paste Option item in the context menu, see the following screen shot:

doc copy without formulas 1

3. Then you will see all numbers are pasted in the destination cells without formulas.

doc copy without formulas 2

Note: Paste Special command clears not only formulas, but also formatting, such as bold, color, etc.


arrow blue right bubble Copy numbers or values without copying formulas in cells with Kutools for Excel

With above method, you may lose the cell formatting, if you like to paste without formulas but keep the cell formatting, Kutools for Excel’s To Actual utility may do you a favor.

Kutools for Excel : with more than 120 handy Excel add-ins, free to try with no limitation in 60 days. 

After installing Kutools for Excel, please do as follows:

1. Select the numbers and formulas you want to copy, and then click Kutools > To Actual, see screenshot:

doc copy without formulas 7

2. And all the values and formulas in the range will be changed to actual values, the cell formatting is kept as well, see screenshot:

doc copy without formulas 8

3. Then you can copy and paste the data range to any location as you need.

Click here to know more information about To Actual.

Free Download Kutools for Excel Now!


arrow blue right bubble Copy numbers or formulas without changing cell references with Kutools for Excel

If you want to copy both calculated results and the formulas to other cells without changing their values, Kutools for Excel's Exact Copy tool can help you quickly copy both numbers and their formulas without changing their values to other cells in Excel.

After installing Kutools for Excel, please do as follows:

1. Click Kutools > Exact Copy, see screenshot:

doc copy without formulas 3

2. In the Exact Formula Copy dialog box, click doc copy without formulas 5 button to select the data range that you want to copy and paste without formulas,(to keep the cell formatting, please just check Copy formatting option) see screenshot:

doc copy without formulas 4

3. And then click Ok button, and another prompt box is popped out to remind you select a cell to put the pasted result. See screenshot:

doc copy without formulas 6

4. Then click OK button, you will see both numbers and formulas in selected cells are copied to destination cell without changing their values.

Kutools for Excel's Exact Copy tool can easily copy all the formulas without adjusting the relative cell references. Click to know more…  

Free Download Kutools for Excel Now!


Recommended Productivity Tools

Office Tab

gold star1 Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.

Kutools for Excel

gold star1 Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!

gold star1 200 New Features for Excel, Make Excel Much Easy and Powerful:

  • Merge Cell/Rows/Columns without Losing Data.
  • Combine and Consolidate Multiple Sheets and Workbooks.
  • Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion.
  • Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,
  • More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools...

Screen shot of Kutools for Excel

btn read more      btn download     btn purchase

Add comment


Security code
Refresh