Excel: Format Control: 'cell link' reamins constant. How to copy

G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying a forumula to many cells -but keeping one element static 2
how to auto increment cell location within formula 3
Copy Pasting formula's 1
How do I reference the same cell as I move through range of cells. 1
Is there a way to set a cell value to be constant in formulas? 4
Payment calculation 1
Removing the constant link from Spinner 1
Conditional Format & Formula 2

Top