Excel 2002: changing link formula from absolute to relative
F4 while you are editing the formula. This will toggle through the 4
options in turn.
--
David Biddulph
"Mr. Low" wrote in message
...
Hi,
I notice that all the formulas link from one work book to another are in
form of "absolute" cell refrence.
Eg. ='[Budget 2010.xls]jh'!$E$222
This does not serve my need as I need to copy the formulas across the
spreasheet.
Usually I would remove the $ manually before copying across.
May I know if there is a way of changing the formula from absolute to
relative, i.e. removing the $ in row only, column only or both
automatically?
Thanks
Low
--
A36B58K641
|