When I copy an excel formula down to the cel below, the formula stays the same, for example if I copy the formula c1 + c2 down it should become c2 + c3, but it stays the same c1 + c2. Any help here? Maybe an add it?
When I copy an excel formula down to the cel below, the formula stays the same, for example if I copy the formula c1 + c2 down it should become c2 + c3, but it stays the same c1 + c2. Any help here? Maybe an add it?
Also if I hit f2, then enter, the formula is correct.
I am a dummy, my auto calc was off, the formula was correct, just not calculating, how do I set to calculate automatically, not just for one spreadsheet, but for all at once, thanks.
Hi,Originally Posted by JR573PUTT
I believe that the 'Automatic' is for the workbook, and the current setting will become the default for a newly created workbook.
hth
---
Si fractum non sit, noli id reficere.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks