Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with autofill
Hi-
Previously I was able to make column c= column 1 + column b. When I selected column 3 and dragged it down it would continue to add the two columns for each row. Now when I drag down it only copies the selected cell. Has anyone had this problem or know of a solution? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with autofill
I wonder if your calculation is set to MANUAL. Check Tools - Options -
Calculation and change to Automatic. -- HTH, Barb Reinhardt " wrote: Hi- Previously I was able to make column c= column 1 + column b. When I selected column 3 and dragged it down it would continue to add the two columns for each row. Now when I drag down it only copies the selected cell. Has anyone had this problem or know of a solution? Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with autofill
On Sep 7, 10:48 pm, Barb Reinhardt
wrote: I wonder if your calculation is set to MANUAL. Check Tools - Options - Calculation and change to Automatic. -- HTH, Barb Reinhardt Thanks- that did it... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofill Problem | Excel Discussion (Misc queries) | |||
Autofill Problem | Excel Discussion (Misc queries) | |||
Autofill problem | Excel Discussion (Misc queries) | |||
Autofill problem | Excel Discussion (Misc queries) | |||
Autofill problem | Excel Worksheet Functions |