Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formulas
Hello,
Can you tell me how to copy formulas and paste to another location without them changing? Thanks Colin |
#2
|
|||
|
|||
Hi
you may use absolute references such as $A$1 instead of A1 -- Regards Frank Kabel Frankfurt, Germany "Colin McLure" schrieb im Newsbeitrag ... Hello, Can you tell me how to copy formulas and paste to another location without them changing? Thanks Colin |
#3
|
|||
|
|||
Change to absolute by adding $ where desired.
=$a$1*3 -- Don Guillett SalesAid Software "Colin McLure" wrote in message ... Hello, Can you tell me how to copy formulas and paste to another location without them changing? Thanks Colin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas not working | Excel Discussion (Misc queries) | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
Why won't formulas obey vertical alignment commands? | Excel Discussion (Misc queries) | |||
Copying options: contents, results, formulas, etc. | New Users to Excel |