Home |
Search |
Today's Posts |
#1
|
|||
|
|||
automatic copying
Hello,
I have a spreadsheet which monitors & calculates my car petrol costs, fuel consumption etc. Each row is a single entry, the first 4 cells are input data (date,milometer,litres,cost) and the next 5 are calculated results (mpg, etc etc) As I enter new data into the first 4 cells, some of the calculated cells seem to automatically copy themselves down from the previous row, other cells do not.and have to be copied manually. I can't find out why this is happening or how to control it. Why don't all the cells copy themselves automatically? Thanks for all help KK |
#2
|
|||
|
|||
Hi, Just to be sure, check in TOOLS - OPTIONS and choose tab CALCULATION. If 'AUTOMATIC' is not chosen and MANUAL is chosen, excel will not automatically calculate your formulas unless you use F9 button. Koen -- Koen_VN ------------------------------------------------------------------------ Koen_VN's Profile: http://www.excelforum.com/member.php...o&userid=25593 View this thread: http://www.excelforum.com/showthread...hreadid=401439 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I find automatic links in an Excel-sheet? | Excel Discussion (Misc queries) | |||
Problems copying street addresses and dates | Excel Discussion (Misc queries) | |||
Automatic copying of data cells | Excel Discussion (Misc queries) | |||
Automatic Copying | Excel Discussion (Misc queries) | |||
Automatic copying data excluding blank cells | Excel Worksheet Functions |