Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
autofill
I have a very simple problem using autofill in Excel 2003; when I drag
down it copies the number in the cell instead of the formulas. The strange thing is the right formulas are in the copied cells, but they still have the original number from the first cell. What is the problem!? Thanks anyone, Grambo |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
autofill
My guess is that you have calculation set to manual.
Try tools|options|Calculation tab and select automatic. grambo wrote: I have a very simple problem using autofill in Excel 2003; when I drag down it copies the number in the cell instead of the formulas. The strange thing is the right formulas are in the copied cells, but they still have the original number from the first cell. What is the problem!? Thanks anyone, Grambo -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofill but with a custom rule?? | Excel Discussion (Misc queries) | |||
autofill | Excel Discussion (Misc queries) | |||
More- AutoFill with Non-Seqeuntial Cell References ? | Excel Worksheet Functions | |||
Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) | |||
Relative reference autofill increment other than +1 | Excel Discussion (Misc queries) |