| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with copying formula
I am entering the following formula into Cell L3.... =B4-E3 When I copy this down to the cells below with the drag handle, the formula is copied correctly (i.e =B5-E4, =B6-E5 etc..), but the result is the same in every cell which is clearly wrong. I'm stumped. Thanks.  -- jimbob ------------------------------------------------------------------------ jimbob's Profile: http://www.excelforum.com/member.php...o&userid=29107 View this thread: http://www.excelforum.com/showthread...hreadid=488480 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Problem with copying formula
Set calculation to automatic under toolscalculation or press F9 after you
have copied down if you for some reason need calculation set to manual -- Regards, Peo Sjoblom (No private emails please) "jimbob" wrote in message ... I am entering the following formula into Cell L3.... =B4-E3 When I copy this down to the cells below with the drag handle, the formula is copied correctly (i.e =B5-E4, =B6-E5 etc..), but the result is the same in every cell which is clearly wrong. I'm stumped. Thanks. -- jimbob ------------------------------------------------------------------------ jimbob's Profile: http://www.excelforum.com/member.php...o&userid=29107 View this thread: http://www.excelforum.com/showthread...hreadid=488480 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Problem with copying formula
Touch CNTRL-ALT-F9
-- Gary's Student "jimbob" wrote: I am entering the following formula into Cell L3.... =B4-E3 When I copy this down to the cells below with the drag handle, the formula is copied correctly (i.e =B5-E4, =B6-E5 etc..), but the result is the same in every cell which is clearly wrong. I'm stumped. Thanks. -- jimbob ------------------------------------------------------------------------ jimbob's Profile: http://www.excelforum.com/member.php...o&userid=29107 View this thread: http://www.excelforum.com/showthread...hreadid=488480 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Problem with copying formula
Thanks guys:) -- jimbob ------------------------------------------------------------------------ jimbob's Profile: http://www.excelforum.com/member.php...o&userid=29107 View this thread: http://www.excelforum.com/showthread...hreadid=488480 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Problem with Formula | Excel Worksheet Functions | |||
| problem with formula | Excel Discussion (Misc queries) | |||
| Trouble copying and pasting a formula | Excel Worksheet Functions | |||
| Precision problem with automated formula fill-in | Excel Worksheet Functions | |||
Linear Mode
