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 numbers or values without copying formulas in cells with Paste Special command

Amazing! Using Tabs in Excel like Firefox, Chrome, Internet Explore 10!

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:

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

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

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.

After installing Kutools for Excel, please do as follows:

1. Copy and paste the cell values and formulas to another place you need.

2. Then select the pasted data you want to remove the formulas, and click Kutools > To Actual, see screenshot:

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

Click here to know more information about To Actual.

Download and free trial Kutools for Excel Now !

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:

2. In the Exact Formula Copy dialog box, click 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:

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:

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…  

Download and free trial Kutools for Excel Now !

Demo: Copy data without fromulas or without chnaging formula cell refrences by Kutools for Excel

Recommended Productivity Tools

Office Tab

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

Kutools for Excel

Add comment