copying contents of a cell into another

  • Thread starter Thread starter alex10for2
  • Start date Start date
A

alex10for2

I want to reference a cell (A1) that has a link. What's a formula i ca
use to reference the value with the link so that everytime i update A
it will update A2 with the exact same info and format???

thanks!
 
To get the same format, the easiest way is to copy and paste A1 into A2,
then delete A2 and put =A1 into A2. Copy/pasting transfers the format over.
 
Or for the formatting you can use the Format Painter. It copies formatting
from cell to cell. Click A1, then turn on the Format Painter (paint brush
button on the standard toolbar), then click A2. This can be done after the
formula (link) has been put in A2, or before.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

Dave R. said:
To get the same format, the easiest way is to copy and paste A1 into A2,
then delete A2 and put =A1 into A2. Copy/pasting transfers the format over.
Click to expand...
 
Back
Top