If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Copy calculation formula to new cells - has gone
I am preparing some budget reports. I am able to use the auto sum key to add a line of figures, but when I try to copy this formula to all rows, it carries forward the same total, not creating individual totals. I have never had any problems before with this. Is this a virus problem? Is there a toggle switch that has been turned on without my knowledge? Im stumped.
Thanks -- PCAefar |
#2
|
|||
|
|||
Copy calculation formula to new cells - has gone
Look at the formula and see if there are any absolute signs in it ($) ie
=sum($A$1:$A$21) "aswf" wrote in message ... : I am preparing some budget reports. I am able to use the auto sum key to add a line of figures, but when I try to copy this formula to all rows, it carries forward the same total, not creating individual totals. I have never had any problems before with this. Is this a virus problem? Is there a toggle switch that has been turned on without my knowledge? Im stumped. : Thanks : -- : PCAefar |
#3
|
|||
|
|||
Copy calculation formula to new cells - has gone
"aswf" wrote in message ... I am preparing some budget reports. I am able to use the auto sum key to add a line of figures, but when I try to copy this formula to all rows, it carries forward the same total, not creating individual totals. I have never had any problems before with this. Is this a virus problem? Is there a toggle switch that has been turned on without my knowledge? Im stumped. Thanks -- PCAefar Select the cell with the formula. Put the mouse on the bottom right corner of that cell. The mouse icon will turn into a + symbol, click on that, and select all the cells below where you want to have sums. Bob |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
copy results of formula to another cell | ScheduleQueen | Worksheet Functions | 5 | June 28th, 2004 12:11 AM |
Copy / Paste Merged Cells | LPS | General Discussion | 1 | June 26th, 2004 01:54 AM |
Need formula to display info across cells | Domenic | Worksheet Functions | 2 | June 4th, 2004 06:29 PM |
Copy Formula Query | John | Worksheet Functions | 3 | April 17th, 2004 05:14 PM |
copy formula | Andy B | Worksheet Functions | 1 | January 25th, 2004 07:06 PM |