How to repeat a sequence of numbers in Excel?

In Excel, you can type a starting number then drag autofill handle down to auto fill a series of numbers. But in some cases, you need to insert a sequence of numbers which ends with a specific number then repeat this sequence again and again as below screenshot shown, how can you quickly insert it? This tutorial can give you a satisfied answer.
Repeat a series of numbers in a column with formula
Repeat a series of numbers in a column or multiple columns with Kutools for Excel

Repeat a series of numbers in a column with formula

1. Select a cell to type the beginning number of the sequence into it. See screenshot:

2. In next below cell, type this formula =IF(A1=4,1,A1+1), and press Enter key, then drag autofill handle down to the cells as you need. See screenshots:

Tip:

1. In above formula =IF(A1=4,1,A1+1), 4 indicates the ending number of the sequence, 1 indicates the beginning number of sequence, and A1 is the first cell that you will insert repeated sequence at.

2. If you want to insert a repeated sequence of number beginning with number 1, you can use this formula =MOD(A1,4)+1, too.

Repeat a series of numbers in a column or multiple columns with Kutools for Excel

If you want to repeat a series of number in a range, you can use Kutools for Excel’s Insert Sequence Number utility.

After free installing Kutools for Excel, please do as below:

1. Select a column range of multiple columns range, click Kutools > Insert > Insert Sequence Number. See screenshot:

2. In the popping dialog, click New to expand the dialog, see screenshot:

3. Then in the Insert Sequence Number dialog, do as below:

(1) Name the sequence;

(2) Specify the Start number of the sequence;

(3) Specify the Increment of the sequence;

(4) Specify the digits of the sequence, if you need, 1, 2 …, just type 1 into the No. of digits text box, if you need 01, 02…, type 2 into it;

(5) Check End number, and type the ending number of series into below textbox. See screenshot:

4. Click Add, and then click Fill Range button, the repeated series of numbers are inserted.

Demo: Repeat Sequence Number