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