| 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. |
| 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 | |||
Threaded Mode
