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
Languages
Recipes
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
   
 
 
online learning made for people
Dreevoo.com | CONTRIBUTE | FORUM | INFO