Skip to main content

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


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.


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 300 handy Excel add-ins, free to try with no limitation in 30 days. 

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:

doc copy without formulas 8

Click here to know more information about To Actual.

Download and free trial Kutools for Excel Now !


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 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…  

Download and free trial Kutools for Excel Now !


Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days. Download and free trial Now!

Best Office Productivity Tools

Popular Features: Find, Highlight or Identify Duplicates   |  Delete Blank Rows   |  Combine Columns or Cells without Losing Data   |   Round without Formula ...
Super Lookup: Multiple Criteria VLookup    Multiple Value VLookup  |   VLookup Across Multiple Sheets   |   Fuzzy Lookup ....
Advanced Drop-down List: Quickly Create Drop Down List   |  Dependent Drop Down List   |  Multi-select Drop Down List ....
Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Toggle Visibility Status of Hidden Columns  |  Compare Ranges & Columns ...
Featured Features: Grid Focus   |  Design View   |   Big Formula Bar    Workbook & Sheet Manager   |  Resource Library (Auto Text)   |  Date Picker   |  Combine Worksheets   |  Encrypt/Decrypt Cells    Send Emails by List   |  Super Filter   |   Special Filter (filter bold/italic/strikethrough...) ...
Top 15 Toolsets12 Text Tools (Add Text, Remove Characters, ...)   |   50+ Chart Types (Gantt Chart, ...)   |   40+ Practical Formulas (Calculate age based on birthday, ...)   |   19 Insertion Tools (Insert QR Code, Insert Picture from Path, ...)   |   12 Conversion Tools (Numbers to Words, Currency Conversion, ...)   |   7 Merge & Split Tools (Advanced Combine Rows, Split Cells, ...)   |   ... and more

Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time.  Click Here to Get The Feature You Need The Most...

kte tab 201905


Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
Comments (7)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
Thanks u'r awesome!
This comment was minimized by the moderator on the site
thanks for help.
This comment was minimized by the moderator on the site
hi thanku so much for your help.
This comment was minimized by the moderator on the site
So much time saved. Thank you
This comment was minimized by the moderator on the site
THANK YOU PLENTY OF TIME SAVED!
This comment was minimized by the moderator on the site
Thanks a lot :) :) appreciate the help a lot :)
This comment was minimized by the moderator on the site
THANK YOU SO MUCH!!!!!!!!!!!!!!!
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations