| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell references
If you do not intend to drag or copy a formula then it makes no difference.
If however you intend to drag or copy you need to think about the reference style. Absolute references will not change so if your formula always needs to reference a specific cell, column or row then you need to add absolute references. If on the other hand the formula depends on the relative position of another cell then you want relative references. -- HTH... Jim Thomlinson "amy howell" wrote: How do you know when to use a relative, absolute, or mixed reference? Are there certain instances to use each one? -- Amy Howell |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with converting a block of cells with Absolute and mixed references to relative references | Excel Worksheet Functions | |||
| Displaying multiple cell references in 1 cell | Excel Discussion (Misc queries) | |||
| How to rename references from range names to cell references | Excel Discussion (Misc queries) | |||
| Changing Cell References To a Different Worksheet in the Same Cell | Excel Worksheet Functions | |||
| Transferring cell content between workbooks using cell references | Excel Discussion (Misc queries) | |||
Threaded Mode
