Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtraction Question
I am working on an excel spreadsheet that shows data from my students in the
fall, winter, and spring...then a column to show the growth. In the growth column I want to show the growth from fall to spring. I know I can use =sum(d3-b3) to get that number. I am wondering if there is a formula to be able to fill in one formula for 30 rows, so I don't have to type in the above formula for all 30 rows??? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtraction Question
You can start by using the help index for FILL
-- Don Guillett Microsoft MVP Excel SalesAid Software "kinderteacher101" wrote in message ... I am working on an excel spreadsheet that shows data from my students in the fall, winter, and spring...then a column to show the growth. In the growth column I want to show the growth from fall to spring. I know I can use =sum(d3-b3) to get that number. I am wondering if there is a formula to be able to fill in one formula for 30 rows, so I don't have to type in the above formula for all 30 rows??? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtraction Question
hi
you don't have to type the formula 30 times. Two ways... 1. copy the formula then high light the area under the formula down to row 30 or how ever far you want to to. then paste. excel will adjust the fromulas to fit each row. 2. click the cell with the formula. at the lower right of the cell pointer is a small square. hover the mouse pointer over the little square. the mouse pointer will turn into a small cross. click and hold the left mouse button and drag down. excel will fill in all the formulas and adjust each formula to fit each row. Regards FSt1 "kinderteacher101" wrote: I am working on an excel spreadsheet that shows data from my students in the fall, winter, and spring...then a column to show the growth. In the growth column I want to show the growth from fall to spring. I know I can use =sum(d3-b3) to get that number. I am wondering if there is a formula to be able to fill in one formula for 30 rows, so I don't have to type in the above formula for all 30 rows??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtraction | Excel Worksheet Functions | |||
Excel subtraction question | Excel Discussion (Misc queries) | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
Subtraction question | Excel Discussion (Misc queries) | |||
Subtraction Question | Excel Discussion (Misc queries) |