software

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 MVPquot;KKquot; gt; wrote in message
...
gt; Hello
gt;
gt; I have a simple spreadsheet which monitors my car's fuel costs, mpg etc.
gt; Each row has 4 cells with input data (date, mileometer reading, litres,
gt; cost) and 8 calculated cells (eg. mpg, cost/mile, pence/litre,12 month
gt; average mpg, etc. etc.).
gt;
gt; Whenever I add a new row I type in the 4 input cells and find that 2 of the
gt; calculated cells seem to automatically 'copy down' . The other calculated
gt; cells have to be copied down 'manually'.
gt;
gt; Can anybody tell me what is going on ?
gt;
gt; Thanks
gt;
gt; KK
gt;
gt;