ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   autofill (https://www.excelbanter.com/excel-discussion-misc-queries/113387-autofill.html)

grambo

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


Dave Peterson

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


All times are GMT +1. The time now is 11:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com