Put any number in cell A1. In B1 type =A1

Now change A1 and see B1 change, too.

If you want to copy A1, but have the cell where you paste it REFER to A1,
then:
1) copy A1,
2) select the cell where you want the result
3) use Editpaste specialpaste link


"Jennifer Mcdermeit" wrote:

What formula do you need to add to the first or original cell to allow the
contents of the copied cells below in a column to change to the content of
the first or original cell?

How do you do this if only numbers are in the cell?
If only text?
If both mixed with numers and text?

Thank you,
Jen