fill down problem

  • Thread starter Thread starter cal
  • Start date Start date
C

cal

the spreadsheet on which i am currently working doesn't seem to fill down
properly for any formulae, when i drag the handle down.
instead it just copies the data from the original cell, rather than
calculating new values for each cell below.

any thoughts welcome.

thanks
cal
 
cal

Tools>Options>Calculation. Make sure your settings are on "Automatic"


Gord Dibben MS Excel MVP
 
bang on gord - thanks mate.

cal

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
| cal
|
| Tools>Options>Calculation. Make sure your settings are on "Automatic"
|
|
| Gord Dibben MS Excel MVP
|
|
| >the spreadsheet on which i am currently working doesn't seem to fill down
| >properly for any formulae, when i drag the handle down.
| >instead it just copies the data from the original cell, rather than
| >calculating new values for each cell below.
| >
| >any thoughts welcome.
| >
| >thanks
| >cal
| >
|
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fill cells increment row number i fomula 1
Incrementing, Even Though Formatted As Text: Why ? 6
Macro to fill down automatically the number of rows in a spreadsheet 1
is Retrieving a Cell address from a cell containing a SUMPRODUCTformula a problem ? 5
Drag down to fill in, but copy, not increment? 10
drag down, not by series 4
#VALUE! 11
Fill rows with column information 2

Back
Top