I'm trying to make a spreadsheet that displays the average of a row, i.e. =average(c3:al3)
and the function is in column AN3.
I want to copy that function down a row (but need to do this for 560 rows) and I need it to auto change from C3:AL3 to C4:AL4 (if this makes sense). I know I can do it by hand but that would be prohibitively time consuming. I can insert a row into a column wide formula (such as =average(c3:c560)
and it will auto change it to =average(c3:561)
) just want to know if can do the same or do it as a bulk action for rows.
Best Answer
The easiest thing is to copy and paste; the change from
c3:al3
toc4:al4
, etc, will happen automatically. I would proceed as follows:=average(c3:al3)
inAN3
.AN3
, press CTRL+C (or CMD+C on Mac) to copy it (the cell itself, not the formula from the formula line).AN3:AN562
(or whichever range you want to paste to).The formula that will actually appear in the cells will have appropriate row numbers.
A mouse-based way to do the same is to drag the formula down using the dot in the bottom right corner of the cell.