Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change a cell reference from relative to absolute
Excel 2000
When I "automatically" generate a cell reference in a formula by clicking on the source cell, the reference is generated as a relative reference rather than an absolute reference. This is OK when the source cell is in the same worksheet in the workbook, but is "not useful" when the source cell is in a different worksheet. Currently I am editing the cell reference manually. Is there a way to change the cell reference generation to absolute, or to flip (with a keystroke or a toolbar button, etc.) the reference from relative to absolute? e.g., in R1C1 notation. change: =[other sheet]!R[-4]C[-3] which is what is generated automatically to =[other sheet]!R47C5 I seem to recall reading about doing this in the past, but I can't find a search term to use in the help system to bring it up. TIA Fred Holmes |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change a cell reference from relative to absolute
While entering/editing the formula pressing F4 cycles through the four
posssibilities ... R[-4]C[-3] R4C3 R4C[-3] R[-4]C3 "Fred Holmes" wrote: Excel 2000 When I "automatically" generate a cell reference in a formula by clicking on the source cell, the reference is generated as a relative reference rather than an absolute reference. This is OK when the source cell is in the same worksheet in the workbook, but is "not useful" when the source cell is in a different worksheet. Currently I am editing the cell reference manually. Is there a way to change the cell reference generation to absolute, or to flip (with a keystroke or a toolbar button, etc.) the reference from relative to absolute? e.g., in R1C1 notation. change: =[other sheet]!R[-4]C[-3] which is what is generated automatically to =[other sheet]!R47C5 I seem to recall reading about doing this in the past, but I can't find a search term to use in the help system to bring it up. TIA Fred Holmes |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change a cell reference from relative to absolute
Select the cell with the formula
Select the entire formula in the formula bar. Hit F4 to cycle through the absolute and relative references. Fred Holmes wrote: Excel 2000 When I "automatically" generate a cell reference in a formula by clicking on the source cell, the reference is generated as a relative reference rather than an absolute reference. This is OK when the source cell is in the same worksheet in the workbook, but is "not useful" when the source cell is in a different worksheet. Currently I am editing the cell reference manually. Is there a way to change the cell reference generation to absolute, or to flip (with a keystroke or a toolbar button, etc.) the reference from relative to absolute? e.g., in R1C1 notation. change: =[other sheet]!R[-4]C[-3] which is what is generated automatically to =[other sheet]!R47C5 I seem to recall reading about doing this in the past, but I can't find a search term to use in the help system to bring it up. TIA Fred Holmes -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CAN A HYPERLINK HAVE AN ABSOLUTE COLUMN & RELATIVE CELL REFERENCE. | Excel Worksheet Functions | |||
changing from relative to absolute cell reference in multiple form | Excel Worksheet Functions | |||
Copying a work sheet cell reference as relative not absolute? | Excel Discussion (Misc queries) | |||
How do I change a cell from absolute reference to relative referen | Excel Discussion (Misc queries) | |||
Explanation Relative/Absolute Cell Reference | Excel Worksheet Functions |