Hello!

I'm new to the forum, and really to Excel, so I need a little help. I'm using Excel 2007.

I'm trying to create a spreadsheet that totals the win/lose/draw records for a number of teams. After much experimentation, I've figured out the formulas to get the totals so that each team had a seperate row. So in column A I have the name, column B I have the win percentage, column C has wins, D has loses, E has draws and F has total games played, so B is C divided by F. I have those formulas.

However, since there are so many teams, I'm wondering if there is an easy way to copy the formulas for each of those cells into the cells below them, but get it to automatically change the row I am refering to. For example, my cell B2 has the formula "=C2/F2", thus giving me the total number of wins divided by the total number of games. Is there a way I can copy that several times, but have the formula change the row for me? So I could copy it to row three and have it automatically know it needs to be "=C3/F3", instead of giving me the same result as "+C2/F2?"

I just don't want to have to go into each one individually and change a number several hundred times.

Thanks!

Susie