Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
How do I skip blank cells when copying over a range of cells? | Excel Discussion (Misc queries) | |||
copying content of cell automatically to multiple cells | Excel Worksheet Functions | |||
Excel should allow cloaking of certain cells when copying cells b. | Excel Worksheet Functions | |||
Automatic copying data excluding blank cells | Excel Worksheet Functions |