Moving Reference Cells, Keeping Formula Pointers Constant

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to keep the references in a formula constant when the cells they point to are moved

For example
On Sheet 1, cell A1 contains the number 50. On Sheet 2, cell A1 contains the formula "=Sheet1!$A$1"
If I move the 50 on Sheet 1 to cell B1 (cut-and-paste), the formula on Sheet 2 changes to "=Sheet1!$B$1"

Can I force the formula to point to Sheet1!$A$1 even when I move that cell's contents

Thanks
~J
 
You must log in or register to reply here.

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

SUMIF function and cell /sheet reference 3
Fill formula down for cells 74 rows apart 3
Copy reference cell with alternate column 4
Excel Import Comments 3
Hyperlink via indirect cell reference 8
Code to format cells on several worksheets 2
Ref Formula Query 1
Can I sort and not lose reference to the cell? 3

Back
Top