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

On May 23, 11:00*am, "Khalil handal" <khhan...@yahoo.com> wrote:
> 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

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

"Khalil handal" <khhandal@yahoo.com> wrote in message news:eSIgNvLvIHA.3780@TK2MSFTNGP03.phx.gbl...
|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

On May 23, 11:16*am, Pete_UK <pashu...@auditel.net> wrote:
> 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
>
> On May 23, 11:00*am, "Khalil handal" <khhan...@yahoo.com> wrote:
>
>
>
> > 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- Hide quoted text -
>
> - Show quoted text -

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



"Niek Otten" <nicolaus@xs4all.nl> wrote in message
news:Ok7q45LvIHA.6096@TK2MSFTNGP06.phx.gbl...
> 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
>
> "Khalil handal" <khhandal@yahoo.com> wrote in message
> news:eSIgNvLvIHA.3780@TK2MSFTNGP03.phx.gbl...
> |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
> |
> |
>
>

Well, thanks for feeding back.

Pete

On May 23, 8:55*pm, "Khalil Handal" <hand...@stthom.edu> wrote:
> Thank to both of you. It was more easy to do it with *John Walkenbach's
> Power Utility Pack
>