K
Khalil handal
I have a sheet with a large number of formulas. A sample of these formulas
is:
='June 2006'!E$160+'July 2006'!F$160
Is there a way to change from relative cell reference to absolute cell
reference without having to do it manualy foreach cell.
In the example the formula should look like:
='June 2006'!$E$160+'July 2006'!$F$160
Any help is appreciated
is:
='June 2006'!E$160+'July 2006'!F$160
Is there a way to change from relative cell reference to absolute cell
reference without having to do it manualy foreach cell.
In the example the formula should look like:
='June 2006'!$E$160+'July 2006'!$F$160
Any help is appreciated