How can I get Excel to increment ranges arguments by more than one row when I fill down a formula?

For example, if I want Excel to keep averaging the next five numbers in a column, how do I set the average function to keep it in a pattern throughout, without changing it from an increment of one from the first and last number of the previous formula?

Excel keeps giving me this when I fill down:

```
=Average(A1:A5)
=Average(A2:A6)
=Average(A3:A7)
```

I want Excel to do this instead:

```
=Average(A1:A5)
=Average(A6:A10)
=Average(A11:A15)
```

How can I do this by filling down?

## Best Answer

I put this formula in B1, copied and pasted down column B.

It is performing an average on a range found using the offset formula.

If you wanted to paste this across row 1 starting at B1 change to