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
  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....
 
 
  Click to open user profile  
activedetaili, 8th May 2024, 12:12 PM
Discover the lucrative franchise opportunity with Active Detailing, India's premier car detailing franchise. With a proven business model and pan-India presence, we offer unmatched support for entrepreneurs seeking success in the car wash and detailing franchise business. https://activedetailing.in

 
 
  Click to open user profile  
fredpeterson, 30th Jun 2025, 3:09 PM
To copy only the cell value (not the formula) in Excel 2013, use Copy > Paste Special > Values to avoid reference errors.Fix long path errors easily with Long Path Tool.
 
 
  Click to open user profile  
Zoyashah, Yesterday, 1st Jul 2025, 11:46 AM
Custom tote bags offer personalized function—just like copying a cell value in Excel 2013 enhances workflow with ease. Simply select the desired cell, press Ctrl+C, and paste it where needed using Ctrl+V. Just as a custom tote carries exactly what you need in style, Excel lets you carry over essential data effortlessly. Both combine simplicity with utility, helping you stay organized whether in the office or on the go. https://www.gopromotional.co.uk/branded-....
 
 
  Click to open user profile  
abbaskhan8008, Today, 2nd Jul 2025, 1:15 AM
Multilingual Support for a Truly Localized Experience 92pakvip takes pride in offering a truly localized gaming experience for Pakistani players by providing full support in both Urdu and English, ensuring that language is never a barrier when it comes to accessing and enjoying the platform. All guides, FAQs, game instructions, and customer support services are available in clear, easy-to-understand language, making it possible for players from all regions and backgrounds in Pakistan to engage confidently with the platform.
 
   
 
 
online learning made for people
Dreevoo.com | CONTRIBUTE | FORUM | INFO