formula auto-progression thru rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

=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
 
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
 
If the cells are contiguous in a column, try this:

Select the cell with the base formula
Edit>Copy
Select all the cells below that one that need the formula
Press [Enter]


Does that help?

***********
Regards,
Ron
 
nailed it!!! i can't tell you how much i appreciate your help.

Ron Coderre said:
If the cells are contiguous in a column, try this:

Select the cell with the base formula
Edit>Copy
Select all the cells below that one that need the formula
Press [Enter]


Does that help?

***********
Regards,
Ron


ayeFayze said:
=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
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

help with my if statement 3
Getting the Weekly Daily Average 2
help needed to compile a macro (replace only 8 cells of a row fromnext raw if one cell has value of 1
ArrayFunctions: How do I... ? 4
Interest Calculations 6
Sum of multiple rows, based on date criteria, separate sheets... 0
Macro 4
Formula question...I belive row is the answer...but need help 6

Back
Top