| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Stopping a constant variable cell from being copied.
Let's say I have a constant variable in cell A1
Then let's say that C1 = B1+A1, and C2 = B2+A1, and C3=B3+A1. Well if I want to copy C3 and paste it into C4 to C50, Excel will add to the A1 cell (eg. C4=B4+A2, etc), but I want that to be a constant variable (like an interest rate). How can I 'lock it in' so that when a reference of it is copied, the reference remains the same? Any advice gratefully received. Cheers, Link. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stopping the Fx Window from dropping down when clicking in a cell | Excel Discussion (Misc queries) | |||
| How to average one constant # to variable #s? A1:A2 A1:A3 A1:A4 | Excel Worksheet Functions | |||
| Constant cell | Excel Worksheet Functions | |||
| Stopping free text entry in validation cell | Excel Discussion (Misc queries) | |||
| calc constant date from variable date & return with ability to rn. | Excel Worksheet Functions | |||
Threaded Mode
