Hello Fellow ExcelForum-ers!

I am encountering an issue that I feel has a very easy fix.

Below are the equations in 3 cells. They are averaging intervals of 7 cells without overlap.

=AVERAGE(A2:A8)
=AVERAGE(A9:A15)
=AVERAGE(A16:A22)

If I autofill, Excel does not seem to be able to recognize that pattern. Instead, Excel adds 1 to each row so that the fourth cell is as follows:
=AVERAGE(A17:A23)

But rather, the fourth cell should be the following:
=AVERAGE(A23:A29)


Is there a way to autofill with the 7 cell intervals?

Thanks in advance for taking the time to read this!

Best,
Gray-ish