Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying cell formula newbie.
Hi,
I added a formual to a cell, which just multiplies a a different cell by 0.90. Now when I use the mouse to copy mouse clicking and dragging it to all the other cells below it remembers the first cell amount even though it has updated the cell number. It works properly on other spreadsheets without any problem.What am I doing wrong ? for example cell a6 = 100 (a1*0.90) cell b6 = 100 (b1*0.90) even though a1 and a2 contain different values. I hope I have explained it well enough for any one to help me. Thank You. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying cell formula newbie.
Tools/ Options/ Calculation
Set to Automatic, rather than Manual. -- David Biddulph wrote in message ... Hi, I added a formual to a cell, which just multiplies a a different cell by 0.90. Now when I use the mouse to copy mouse clicking and dragging it to all the other cells below it remembers the first cell amount even though it has updated the cell number. It works properly on other spreadsheets without any problem.What am I doing wrong ? for example cell a6 = 100 (a1*0.90) cell b6 = 100 (b1*0.90) even though a1 and a2 contain different values. I hope I have explained it well enough for any one to help me. Thank You. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying a formula to column using a value from a particular cell | Excel Discussion (Misc queries) | |||
copying formula to another cell | Excel Discussion (Misc queries) | |||
How do I keep one cell constant in a formula even when copying | Excel Discussion (Misc queries) | |||
Newbie question: Matching data/2 wkshts copying info over | Excel Worksheet Functions | |||
Formula for copying a sequence for every 8th cell | Excel Worksheet Functions |