Question Regarding Replacing Automated Row Variables

[Armadillo19]

Hello all,

First let me say I am extremely new to excel, so I apologize if this is a simple fix/has been asked in the past...unfortunately I am not even sure how to pose the question, so I will do my best in explaining it.

Here is my problem:

I have a spreadsheet, and I'm looking to create a simple formula, which is easy enough. Let's say for instance the formula, which will be shown in the G column is =(C1/82)*E1, as I have already entered values into the C1 column, and E1 column.

Now, the problem is that this spreadsheet is about 600 rows long. Essentially what I want to do is create an automated formula, were the following rows look like this: =(C2/82)*E2, =(C3/82)*E3, =(C4/82)*E4 and so on and so forth, all the way down to say, =(C600/82)*E600. Essentially what I want to do is replace each C and E row each time. The problem is, going back and changing the formula 600 times or so is very annoying/time consuming, and I'm hopeful there is an easier way to do this.

If anyone would be able to assist it would be greatly appreciated.

Thanks in advance.

 

[Armadillo19]

Oh and by the way, I'm using excel 2007 if that matters.

 

[Armadillo19]

Just want to give this a quick bump to make sure it doesn't get lost in the shuffle. Any advice would be helpful.

Thanks!