need help with a formula on Excel

[Jade Fertig]

I'm trying to create a formula on excel on B2 through B1000 that takes the average of each individual row starting on row 2 so for the first row in B2 it would be =AVERAGE(C2:Z2) . Then B3 would be =AVERAGE(C3:Z3) and so on, what i would like to do is select all of row B 2-1000 at once and put one formula instead of going to each line. I have 450 lines per spread sheet that I have to make is there a formula that with allow me to do so?

[#2]

Hi Jade,

I can imagine that the data in your spreadsheet looks like this:

So, you can put this formula into cell B2:

=AVERAGE(C2:Z2)

And then copy it down using the Fill Handle.

Regards

[#3]

Or you can copy che first cell, then with the arrows of the keybord you go right (to the column with data); then click ctrl+down_arrow and you should arrive at the last data. Then back to the left (in the now empty column in which you want the average); ctrl + shift + up_arrow and ctrl+v to paste that formula in all the selected cells.