| 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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Stopping a constant variable cell from being copied.
Put instead in C1: =B1+$A$1
Copy down. The dollar signs in $A$1 will fix it to A1 as required. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Link" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Stopping a constant variable cell from being copied.
Perfect! And so easy! Thanks very much Max, I wish I had asked this months
ago!;-) Cheers, Link. "Max" wrote in message ... Put instead in C1: =B1+$A$1 Copy down. The dollar signs in $A$1 will fix it to A1 as required. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Link" wrote in message ... 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. |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Stopping a constant variable cell from being copied.
welcome, glad to help.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Link" wrote in message ... Perfect! And so easy! Thanks very much Max, I wish I had asked this months ago!;-) Cheers, Link. |
| Reply |
| 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 | |||
Hybrid Mode
