Need your help because I am not sure of the correct formula to use (if ever there is one!) in Excel 2010.

Say in column A, I have my figures (A1 to A1000). Suppose in column B I need to get the average of A1 to A10. So for B1 my formula is `=average(A1:A10)`

. Then for B2, next to get the average of the next 10 figures in column A, i.e., A11 to A20. Is there an easier way to do this? Because if I just copy/drag the formula, B2 becomes `=average(A2:A11)`

when what I need is for it to be `=average(A11:A20)`

.