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
With Kutools for Excel's Exact Copy utility, you can quickly copy and paste the formulas into any cells without changing the calculated results.
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:
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.
| 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:
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:
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!
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…
Free Download Kutools for Excel Now!
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
Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!
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...
