Lock cell as reference not value

[Guest]

Hi my name susy,

I'm working on a finacial structure("balance") which I will have to lock for
otheruser. but my formulas keep changing if a move, copy or paste a value in
the worksheet.

please tell me how do I keep the link to the cell A1 if I copy or move
values from A1 to B1? Without getting #REF!,....

because every time I add rows or move some data I have to fix most of my
formulas.

 

[Guest]

please tell me how do I keep the link to the cell A1 if I copy or move

values from A1 to B1? Without getting #REF!,....

In say, C2: =INDIRECT("A1")
instead of: =A1
will always point to cell A1

---

 

[Guest]

thanx max ,.....you really did help me. This is my internship project and it
adquire more knowlegde of excell that I what I've tought.

Another Question, How do I formulate a formula to be able to insert rows in
a section and that it will be automatically added to a sum of that section.

With other words: th formula =sum (E13:E15) and I insert 3 more rows an it
had to become =sum(E13: E18)AUTOMATICALLY.

 

[Guest]

Let me see if I understood,

my Formula is for example C1=A1/1.82 if I write =("A1")/1.82 it will always
refer to cell A1?

Because If it is like that I've already try it and is not working. it saidf
#VALUE!

help pls

susy

 

[Pete_UK]

I can't see the other replies on this thread, but I think you want:

=$A$1/1.82

This will always refer to cell A1, even if you copy it elsewhere.

Hope this helps.

Pete

 

[David Biddulph]

You'd better read Max's post again, Susy.

 

[Guest]

hi thnx for the post but I figure out my problem with MAX post.

Would you know maybe how to make a formula in which I can include new rows
automatically into a "formula".
example: sum=(A12:A16) I include 3 more rows and automatically it become
sum=(A12:A19)

Susy

 

[Gord Dibben]

=SUM(A12:INDEX(A:A,ROW()-1))



Gord Dibben MS Excel MVP

 

[Guest]

Thnx very much it work just the way I wanted to.

susy