Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula auto-progression thru rows
=I2/H2...any way to make this go I3/H3,I4/H4 thru I450/H450 with out maually
touching every cell? have spent hours finding no reference to this type of action. i know its got to be basic. thx |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula auto-progression thru rows
If you drag that formula down through a column, it should adjust the row
references automatically. Check your formula: is it i2/h2 as you indicated in your post? Or $i$2/$h$2 ? The latter uses absolute references which will NOT adjust automatically (that's the difference between relative and absolute references). HTH. --Bruce "ayeFayze" wrote: =I2/H2...any way to make this go I3/H3,I4/H4 thru I450/H450 with out maually touching every cell? have spent hours finding no reference to this type of action. i know its got to be basic. thx |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula auto-progression thru rows
If the cells are contiguous in a column, try this:
Select the cell with the base formula EditCopy Select all the cells below that one that need the formula Press [Enter] Does that help? *********** Regards, Ron "ayeFayze" wrote: =I2/H2...any way to make this go I3/H3,I4/H4 thru I450/H450 with out maually touching every cell? have spent hours finding no reference to this type of action. i know its got to be basic. thx |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula auto-progression thru rows
nailed it!!! i can't tell you how much i appreciate your help.
"Ron Coderre" wrote: If the cells are contiguous in a column, try this: Select the cell with the base formula EditCopy Select all the cells below that one that need the formula Press [Enter] Does that help? *********** Regards, Ron "ayeFayze" wrote: =I2/H2...any way to make this go I3/H3,I4/H4 thru I450/H450 with out maually touching every cell? have spent hours finding no reference to this type of action. i know its got to be basic. thx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What formula captures specified rows of data? | Excel Worksheet Functions | |||
Insert rows, keep a formula? | Excel Worksheet Functions | |||
can you hide rows with a formula? | Excel Discussion (Misc queries) | |||
Formula to compare multiple rows values based on another column? | Excel Worksheet Functions | |||
auto sum in formula | Excel Worksheet Functions |