automatic copying of cells ?

[KK]

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

[Bernie Deitrick]

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" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>