Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can you change the function of the fill handle on a cell in Excel
I have a problem when dragging formulas across. Every cell is holding the
figure from that of the one i am dragging from but when you look at the cell it says it is adding up the correct cells. When you double click on that cell then it amends the figure to be correct. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can you change the function of the fill handle on a cell in Excel
Check to see that your calc mode is set to auto:
<Tools <Options <Calculation tab, And make sure "Automatic" *is checked*. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "AndreaRaRa" wrote in message ... I have a problem when dragging formulas across. Every cell is holding the figure from that of the one i am dragging from but when you look at the cell it says it is adding up the correct cells. When you double click on that cell then it amends the figure to be correct. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can you change the function of the fill handle on a cell in Excel
Have you perhaps turned off auto-calculation? (Tools / Options, on the
Calculation tab). You could either set this to Automatic or, when you need calcs updated, hit function key F9. "AndreaRaRa" wrote: I have a problem when dragging formulas across. Every cell is holding the figure from that of the one i am dragging from but when you look at the cell it says it is adding up the correct cells. When you double click on that cell then it amends the figure to be correct. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change fill color in excel based on data in the cell | Excel Worksheet Functions | |||
Excel printing problem - won't print cell under a "fill effect" bo | Excel Discussion (Misc queries) | |||
How do I change color of active cell in Excel | Excel Discussion (Misc queries) | |||
Can an excel cell automatically change fill colors based on values | Excel Discussion (Misc queries) | |||
Excel should have a quick and simple "change case" function like . | Excel Worksheet Functions |