Dreevoo.com | Online Learning and Knowledge Sharing
 
Home | Programs | Microsoft Office | Microsoft Excel | How to copy the cell value in Excel 2013
Guest
Click to view your profile
Topics
Programs Programs
Languages Languages
Recipes Recipes
Home Home
Shortcuts
 
 

How to copy the cell value in Excel 2013

When you want to copy the result of the cell to another cell in Excel, the target displays an invalid references error messag. This error can be avoided by copying cell value into target cell and not the whole formulas.

 
  Author: Pena | Version: Microsoft Excel 2013 | 19th January 2014 |  
 
 
1.
 

Create or open any spreadsheet where any formula is used.

I have created spreadsheet with SUM formula.

  
 
2.
 

Now if you want to copy the content of the cell with formula to any other cell, you will probably get an error or wrong value in the other cell.

The cause for that is that you copy the whole formula in the other cell.


  
 
3.
 

The solution is simple, you only have to paste the value of the cell.

Click Paste icon and under Paste Values select Values.

  
 
4.
 

Now only value will be pasted not the whole formula.

Also recommended:


  
 
 
   
  Please login to post a comment
  Click to open user profile  
propharmacyst, 26th Jan 2023, 11:06 AM
We also offer Vidalista 80, a high-strength version of generic Cialis. This medication is ideal for men who need a higher dose to achieve and maintain an erection. Like our other generic Cialis products, Vidalista 80 is just as effective as the brand-name version but much more affordable.Vidalista 80 from ProPharmacyStores store. Visit at: https://propharmacystores.com/product/bu....
 
   
 
 
online learning made for people
Dreevoo.com | CONTRIBUTE | FORUM | INFO