| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas
when I create a formula using cells from a different workbook, excel
automatically uses absolute cell reference. Is there a setting that could change this to use relative cell refrence? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulas
I've never seen one. That's the way excel works.
If you select the formula (or parts of the formula) in the formula bar, you can hit F4 to cycle through 4 relative/absolulte addresses. Jega-OZ wrote: when I create a formula using cells from a different workbook, excel automatically uses absolute cell reference. Is there a setting that could change this to use relative cell refrence? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting # of Formulas in a column with formulas and entered data | Excel Worksheet Functions | |||
| CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
| automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
| Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
| formulas for changing formulas? | Excel Discussion (Misc queries) | |||
Linear Mode
