Relative to Absolute

[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

 

[Pete_UK]

You could highlight the offending cells and then do Find & Replace
(CTRL-H) as follows:

Find what: E$
Replace with: $E$
click Replace All

CTRL-H again, then:
Find what: F$
Replace with: $F$
click Replace All

Hope this helps.

Pete

 

[Niek Otten]

John Walkenbach's Power Utility Pack contains a relative/absolute and vv converter

http://www.j-walk.com/ss/pup/

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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
|
|

 

[Pete_UK]

Actually, it might be quicker to highlight the cells, CTRL-H, then:

Find what: 06'!
Replace with: 06'!$
click Replace All

Hope this helps.

Pete

 

[Khalil Handal]

Thank to both of you. It was more easy to do it with John Walkenbach's
Power Utility Pack

 

[Pete_UK]

Well, thanks for feeding back.

Pete