Thread: Formula
View Single Post
  #2   Report Post  
 
Posts: n/a
Default

Hi
Don't really understand the question - but here goes.
If you want a cell to always show the same as another, type = in the first
cell and then click the second with your mouse and press Enter. This will
'link' the two cells, and if you move the second, the first will stay linked
to it.
If you want to link to the cell that is always a row up and a column left
(for example) from the first, use the OFFSET function.
Hope this helps.

--
Andy.


"Trevor" wrote in message
...
Can any one help me, its simple if you know how. What is the formula to
make
one cell absolute to another.
--
Many Thanks
Trevor