Cell referencing

J

John P

Hi. I have some Excel formulas that refer to some cells. When these cells are
moved, the formulas refer to the new cell position. How can I prevent this
from happening and have these formulas refer to the same cell position? I
have tried absolute cell reference but that does not help. Thanks
 

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

Cell Referencing 1
Excel - copy absolute cell references (within the range) as relati 1
External Data and Formulas 1
convert relative cell references to absolute cell references via amacro? 1
Copying formulas from one file to another 1
Using named formula in validation 8
Formula displays as formula, not as result 2
Excel 95 (sorry) 7

Top