Using the same cell

[twwtww]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

If i have values in a column and want to copy those values over and over again how do I do it? Say that cell e6 has a value of cell e2 (it actually has "e2" in the cell) and the value in cell e2 is $100. I wish to copy the value of e6 to columns f thru z, but want the value copied to be e6 (otherwise they would change to f6, g6, etc). That way if I change the value of e2, every cell with e6 in it will change too.

 

[twwtww]

It seems to me that I used to enclose the value in quotes or parenthesis and that would copy over the actual value in the quotes or parenthesis and not change them. I want the cell value to remain constant no matter where I copy it.

 

[CyberTaz]

I think you may be confusing what a cell *displays* with what it actually
*contains*. There's also the distinction to be made between a *value* & the
result of a formula. If a cell contains a value, that's what it displays,
but if the cell contains a formula it displays the result of the formula.

What the cell actually contains (or stores) along with how you paste
determines what winds up in the cell you paste to.

If a cell contains a value the regular copy/paste action results in that
same value being pasted to & displayed in the target cell.

OTOH, If the cut/copied cell contains a formula the formula is what gets
pasted by default. That introduces the matter of Relative as opposed to
Absolute cell references in the formula as well as the distinction between
copying as opposed to cutting. Additionally, there is the availability of
the Edit> Paste Special options.

All of this information is available in Excel Help & the online tutorials.
It may be worth your while to review that information before you go any
further. Quite honestly - no insult intended - but I really can't tell from
your description what you're starting with or what you're trying to do with
it, so it's difficult to offer any suggestions. Perhaps if you have a more
comprehensive understanding of the program you'll be able to better
determine how to most effectively do what you need to do.

If you still have any questions please try to describe your data & state
your objective more clearly using specific examples. I'm certain someone
will be glad to lend a hand

Regards |:>)
Bob Jones
[MVP] Office:Mac