Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel: Format Control: 'cell link' reamins constant. How to copy
In Format Control, select control option. There is a min value; max value
and an incremental change value. Below that is a field called "Cell Link". Even though I remove the '$' signs the cell link value remains constant when copied to another row or column. In other words if formula is in D4 and I link it to C4 it will point to C4. But if I copy the formula to D5 the link will remain pointing to C4. How do I set it to point to C5? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Cell format in Excel 2003 | Excel Discussion (Misc queries) | |||
format a text cell in Excel | Setting up and Configuration of Excel | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Excel 2002: Format Cell Height/Width | Excel Discussion (Misc queries) |