Unable to do autocomplete in Excel

Question

There are data:

AutoFill need it with this order. I change cell format to:

then made autocomplete, but the result is the number of filled not by 7 units, and 9 or 10 pieces:

how to make autocomplete in order to each number were 7 pieces?

Answer 1

Try the following in the top cell,

'EN-US
=INT((ROW(1:1)-1)/ 7)+1
'RU-RU
=ЦЕЛОЕ((СТРОКА(1:1)-1)/ 7)+1

Fill down as necessary.

Answer 2

Just use the formulas:

+--------+
| 1      |
| =A1    |
| =A2    |
| =A3    |
| =A4    |
| =A5    |
| =A6    |
| =A7+1  |
| =A8    |
| =A9    |
| =A10   |
| =A11   |
| =A12   |
| =A13   |
| =A14+1 |
| =A15   |
| =A16   |
| =A17   |
| =A18   |
| =A19   |
| =A20   |
| =A21+1 |
| =A22   |
| =A23   |
| =A24   |
| =A25   |
| =A26   |
| =A27   |
| =A28+1 |
| =A29   |
| =A30   |
| =A31   |
| =A32   |
| =A33   |
| =A34   |
| =A35+1 |
| =A36   |
| =A37   |
| =A38   |
| =A39   |
| =A40   |
| =A41   |
+--------+

Beginning in cell A1, where you put a 1, in A2 just =A1 to take the value of the above cell, to A7, and in A8 you put =A7+1. This way you get seven 1's, seven 2's and so on.