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

Newbie Help - IF Yes No Function 0
Copy addition formula of non-consecutive horizontal cells 2
Excel - Wich Function should I use? 1
Cell data entering slow! 0
Persistent "Formula refers to empty cells" error despite cells evidently NOT being em 2
Replace 1
Formula fill series? 1
Permanently link formula references to Column Names and not Column Cell Numbers 1

Top