Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert Relative to absolute address
How can I convert a relative address to an absolute address in Excel?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert Relative to absolute address
How can I convert a relative address to an absolute address in Excel?
Put $ signs in front of the parts of the address that you want to be absolute. Rick |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert Relative to absolute address
The problem I have is that I have a number of formulas refering to a relative
address and I wish to have them refer to absolute. I am trying to avoid redoing all references by adding the $ to each one. "Rick Rothstein (MVP - VB)" wrote: How can I convert a relative address to an absolute address in Excel? Put $ signs in front of the parts of the address that you want to be absolute. Rick |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert Relative to absolute address
Look at EDIT=Replace
"Yorke" wrote: The problem I have is that I have a number of formulas refering to a relative address and I wish to have them refer to absolute. I am trying to avoid redoing all references by adding the $ to each one. "Rick Rothstein (MVP - VB)" wrote: How can I convert a relative address to an absolute address in Excel? Put $ signs in front of the parts of the address that you want to be absolute. Rick |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert Relative to absolute address
This is more easily accomplished by clicking in the cell with the formula
and then click in the formula bar on the cell address you wish to revise. Then hit <F4 and you will automatically add absolute attributes. Each time you hit <F4, you'll see the references rotate through the various absolute instances. If you select the *entire* formula in the formula bar, *every* reference will change at the same time. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Yorke" wrote in message ... The problem I have is that I have a number of formulas refering to a relative address and I wish to have them refer to absolute. I am trying to avoid redoing all references by adding the $ to each one. "Rick Rothstein (MVP - VB)" wrote: How can I convert a relative address to an absolute address in Excel? Put $ signs in front of the parts of the address that you want to be absolute. Rick |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert Relative to absolute address
This may give you waht you are needing.
http://exceltips.vitalnews.com/Pages..._Absolute.html Yorke wrote: The problem I have is that I have a number of formulas refering to a relative address and I wish to have them refer to absolute. I am trying to avoid redoing all references by adding the $ to each one. "Rick Rothstein (MVP - VB)" wrote: How can I convert a relative address to an absolute address in Excel? Put $ signs in front of the parts of the address that you want to be absolute. Rick |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert Relative to absolute address
Thanks all. problem solved
"JW" wrote: This may give you waht you are needing. http://exceltips.vitalnews.com/Pages..._Absolute.html Yorke wrote: The problem I have is that I have a number of formulas refering to a relative address and I wish to have them refer to absolute. I am trying to avoid redoing all references by adding the $ to each one. "Rick Rothstein (MVP - VB)" wrote: How can I convert a relative address to an absolute address in Excel? Put $ signs in front of the parts of the address that you want to be absolute. Rick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Relative and absolute hyperlinks | New Users to Excel | |||
How do I avoid excel change absolute address to relative address | Excel Discussion (Misc queries) | |||
what is difference between absolute address and relative address? | Excel Discussion (Misc queries) | |||
changing relative to absolute | Excel Discussion (Misc queries) | |||
How to convert relative to absolute addressing instantly in Excel | Excel Discussion (Misc queries) |