Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lock cell as reference not value
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lock cell as reference not value
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 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "susy" wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lock cell as reference not value
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. "Max" wrote: 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 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "susy" wrote: 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lock cell as reference not value
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 "Max" wrote: 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 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "susy" wrote: 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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lock cell as reference not value
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 On Sep 21, 4:18 pm, susy wrote: 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 "Max" wrote: 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 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "susy" wrote: 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.- Hide quoted text - - Show quoted text - |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lock cell as reference not value
You'd better read Max's post again, Susy.
-- David Biddulph "susy" wrote in message ... 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 "Max" wrote: 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 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "susy" wrote: 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. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lock cell as reference not value
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 "Pete_UK" wrote: 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 On Sep 21, 4:18 pm, susy wrote: 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 "Max" wrote: 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 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "susy" wrote: 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.- Hide quoted text - - Show quoted text - |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lock cell as reference not value
=SUM(A12:INDEX(A:A,ROW()-1))
Gord Dibben MS Excel MVP On Wed, 26 Sep 2007 12:10:03 -0700, susy wrote: 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 "Pete_UK" wrote: 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 On Sep 21, 4:18 pm, susy wrote: 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 "Max" wrote: 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 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "susy" wrote: 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.- Hide quoted text - - Show quoted text - |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lock cell as reference not value
Thnx very much it work just the way I wanted to.
susy "Gord Dibben" wrote: =SUM(A12:INDEX(A:A,ROW()-1)) Gord Dibben MS Excel MVP On Wed, 26 Sep 2007 12:10:03 -0700, susy wrote: 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 "Pete_UK" wrote: 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 On Sep 21, 4:18 pm, susy wrote: 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 "Max" wrote: 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 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "susy" wrote: 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.- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock cell reference in formula, even when moved with click & drag | Excel Worksheet Functions | |||
I have lock a wookbook but one cell does not want to lock it | Excel Discussion (Misc queries) | |||
I have lock a wookbook but one cell does not want to lock it | Excel Discussion (Misc queries) | |||
Can I lock worksheet reference? | Excel Worksheet Functions | |||
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions |