Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula when copied into a new cell doesn't recalculate
I have a formula on my spreadsheet in cell C3, I want to have this
show in D3 so I goto D3 and say =C3, so whatever is in C3 will be also displayed in D3. This does not work unless I F2 every field. Any suggestions as to why I have to F2 every field in order for the proper numbers to display. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula when copied into a new cell doesn't recalculate
Tools/ Options/ Calculation. Make sure the mode is set to Automatic, not
Manual. -- David Biddulph "spmu" wrote in message oups.com... I have a formula on my spreadsheet in cell C3, I want to have this show in D3 so I goto D3 and say =C3, so whatever is in C3 will be also displayed in D3. This does not work unless I F2 every field. Any suggestions as to why I have to F2 every field in order for the proper numbers to display. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unwanted formula being copied to cell | Excel Discussion (Misc queries) | |||
how to execute a formula copied into an excel cell | Excel Worksheet Functions | |||
cell format changes when formula copied? | Excel Worksheet Functions | |||
Date formula that adds 7 days to a cell when sheet is copied | Excel Worksheet Functions | |||
I get a 0 value when a formula is copied to another cell | Excel Discussion (Misc queries) |