Excel 2002: changing link formula from absolute to relative
If you wanted to use Find & Replace, and you have that same formula
repeated in many cells, then highlight the cells, do CTRL-H and use
the following:
Find What: !$E
Replace with: !E
click Replace All.
(removes the $ from the column reference)
Find What: E$
Replace with: E
click Replace All.
(removes the $ from the row reference)
Find What: $
Replace with: (leave blank)
click Replace All.
(removes all $)
Hope this helps.
Pete
On Jul 29, 3:32*pm, Mr. Low wrote:
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
|