Forum Discussion
Copy values
I like to copy values from one cell into another in Excel for Android on my tablet, but fail.
Cannot find information on the internet
Thks
Walter
You still are incredibly brief in your descriptions. And what's with "f.i."? I Googled the term--are you using it to mean "for instance"? What happened to "e.g." which for years has been the abbreviation of "for example"? (And no, "i.e." does not mean "for example"'; it means "that is" or "in other words.")
So are you wanting to copy the formula exactly as it appears so that it looks exactly the same in the destination cell? Or are you wanting the cell references to change? I'm suspecting that the fact that it's Excel for Android is just a distraction. Your issue has to do, I suspect, with absolute and relative references.
It may be--although I'm forced by by the brevity of your descriptions to draw some inferences--that what you need to adapt are some absolute references, or a combination of absolute and relative references.
If, for example, you copy
=C15 +(0.12*K49)
from cell C2 to D5, it will become
=D18+(0.12*L52)
But if you copy
=$C$15+(0.12*$K$49) then it will copy over unchanged. Those $ dollar signs change the references from relative to absolute.
And there are several variations on that combination of relative and absolute. If, e.g., your C2 cell contains =$C15+(0.12*K$49) and you copy it to D5, it then becomes =$C18+(0.12*L$49)
You can read up on absolute and relative references in most Excel documentation. Here's one such resource.
And for all those reading over our shoulders and wondering about "e.g." and "i.e." here's a resource that clarifies those.
6 Replies
I like to copy values from one cell into another in Excel for Android on my tablet, but fail.
Cannot find information on the internet
The word "copy" in the context of Excel is a bit ambiguous. There's what is commonly referred to as Copy and Paste. I assume that's NOT what you're talking about. Then there are various methods via formulas or functions that can be used to get values from a cell, say A1 to, perhaps, Z1.
So what do you mean--put it into different words, with as much detail as you can--and what have you tried?
Hi
I would like to "copy" ( in Excel for Android) following f.i.
=C15 +(0,12*K49) F.i. from cell C2 to D5
Tks/rgds
Walter
You still are incredibly brief in your descriptions. And what's with "f.i."? I Googled the term--are you using it to mean "for instance"? What happened to "e.g." which for years has been the abbreviation of "for example"? (And no, "i.e." does not mean "for example"'; it means "that is" or "in other words.")
So are you wanting to copy the formula exactly as it appears so that it looks exactly the same in the destination cell? Or are you wanting the cell references to change? I'm suspecting that the fact that it's Excel for Android is just a distraction. Your issue has to do, I suspect, with absolute and relative references.
It may be--although I'm forced by by the brevity of your descriptions to draw some inferences--that what you need to adapt are some absolute references, or a combination of absolute and relative references.
If, for example, you copy
=C15 +(0.12*K49)
from cell C2 to D5, it will become
=D18+(0.12*L52)
But if you copy
=$C$15+(0.12*$K$49) then it will copy over unchanged. Those $ dollar signs change the references from relative to absolute.
And there are several variations on that combination of relative and absolute. If, e.g., your C2 cell contains =$C15+(0.12*K$49) and you copy it to D5, it then becomes =$C18+(0.12*L$49)
You can read up on absolute and relative references in most Excel documentation. Here's one such resource.
And for all those reading over our shoulders and wondering about "e.g." and "i.e." here's a resource that clarifies those.
