automatic copying of cells ?

Hello

I have a simple spreadsheet which monitors my car's fuel costs, mpg etc.
Each row has 4 cells with input data (date, mileometer reading, litres,
cost) and 8 calculated cells (eg. mpg, cost/mile, pence/litre,12 month
average mpg, etc. etc.).

Whenever I add a new row I type in the 4 input cells and find that 2 of the
calculated cells seem to automatically 'copy down' . The other calculated
cells have to be copied down 'manually'.

Can anybody tell me what is going on ?

Thanks

KK

KK,

Do you have any hidden columns in between the two that do and the two that don't 'copy down'
automatically?

HTH,
Bernie
MS Excel MVP


"KK" wrote in message
...
Hello

I have a simple spreadsheet which monitors my car's fuel costs, mpg etc.
Each row has 4 cells with input data (date, mileometer reading, litres,
cost) and 8 calculated cells (eg. mpg, cost/mile, pence/litre,12 month
average mpg, etc. etc.).

Whenever I add a new row I type in the 4 input cells and find that 2 of the
calculated cells seem to automatically 'copy down' . The other calculated
cells have to be copied down 'manually'.

Can anybody tell me what is going on ?

Thanks

KK