Dreevoo.com | Online Learning and Knowledge Sharing

English | Login & Registration

CONTRIBUTE

FORUM

INFO

| Programs | Microsoft Office | Microsoft Excel | How to copy the cell value in Excel 2013

Guest

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 |

Comment ( 3 )

Create or open any spreadsheet where any formula is used.

I have created spreadsheet with SUM formula.

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.

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

Click Paste icon and under Paste Values select Values.

Now only value will be pasted not the whole formula.

Also recommended:

Copy same formula into entire column in Excel 2013

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

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

online learning made for people

Dreevoo.com | CONTRIBUTE | FORUM | INFO

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.

Create or open any spreadsheet where any formula is used.I have created spreadsheet with SUM formula.

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.

The solution is simple, you only have to paste the value of the cell.Click Paste icon and under Paste Values select Values.

Now only value will be pasted not the whole formula.Also recommended: Copy same formula into entire column in Excel 2013

Create or open any spreadsheet where any formula is used.

I have created spreadsheet with SUM formula.

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.

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

Click Paste icon and under Paste Values select Values.

Now only value will be pasted not the whole formula.

Also recommended:

Copy same formula into entire column in Excel 2013