Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How can I subtract cells in a row
I need to be ablt ro do d=b-c on each row, but not have it give a cumulative
total. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How can I subtract cells in a row
If you want to start in Row 1, put this in D1:
=b1-c1 And copy that formula down as far as you need. wildfyre wrote: I need to be ablt ro do d=b-c on each row, but not have it give a cumulative total. -- Dave Peterson |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How can I subtract cells in a row
Is there a way to do it at the top, so that it will automatically do it on
every row? "Dave Peterson" wrote: If you want to start in Row 1, put this in D1: =b1-c1 And copy that formula down as far as you need. wildfyre wrote: I need to be ablt ro do d=b-c on each row, but not have it give a cumulative total. -- Dave Peterson |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How can I subtract cells in a row
Nope. But you can use that little autofill button at the bottom right of the
selected cell to drag down the column. http://www.contextures.com/xlDataEntry01.html#Mouse (From Debra Dalgleish's site) Or you could select your range first: Edit|goto type the address (say) D1:D9932 type the formula once for that top cell: =b1-c1 But hit ctrl-enter to fill all the selected cells. http://www.contextures.com/xlDataEntry01.html#Quick (still from Debra's site.) wildfyre wrote: Is there a way to do it at the top, so that it will automatically do it on every row? "Dave Peterson" wrote: If you want to start in Row 1, put this in D1: =b1-c1 And copy that formula down as far as you need. wildfyre wrote: I need to be ablt ro do d=b-c on each row, but not have it give a cumulative total. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need to add and subtract time cells. ie. 13:45 minus 13:58 | Excel Discussion (Misc queries) | |||
how do i protect cells in a shared worksheet | Excel Discussion (Misc queries) | |||
how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
Fill cells from non-adjacent cells | Excel Discussion (Misc queries) | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |