duplicating sums from dragging a cell

  • Thread starter Thread starter Rob Tonks
  • Start date Start date
R

Rob Tonks

I am simply clicking the bottom right of a cell and dragging it down
column so the sum is duplicated into all the selected cells.

However from time to time this will not work it will simply duplicat
the figure in the first cell selected into all the selected cells.
then have to select the sum for each cell manually for it to work. Wh
is this and is there a way to stop this happening?

Is it a bug?

:confused
 
Hi
maybe in this cases automatic calculation is disabled (do
you see the word 'calculate' in the left of your
statusbar?). If this is the case try:
- hitting F9 to re-calculate
- goto 'Tools - Options - Calculate' and enable automatic
calculation
 
Hi

It may be that your calculation is set to manual (Tools / Options /
Calculation) when this happens. This state is determined by the first
spreadsheet you open. If one of them has Calculation set to manual, and you
open it first, then the problem occurs.
 
Back
Top