Relative to Absolute

  • Thread starter Thread starter Khalil handal
  • Start date Start date
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
 
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
 
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
|
|
 
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
 
Thank to both of you. It was more easy to do it with John Walkenbach's
Power Utility Pack
 
Back
Top