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

Find Missing Sequence Number

Kutools for Excel's Find Missing Sequence Number utility can quickly find and fill the missing sequence number/date in a given sequnce list.

Save 50% of your time, and reduce thousands of mouse clicks for you every day!

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.

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

 with more than 300+ handy Excel functions, enhance your working efficiency and save your working time.

After 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.

Best Office Productivity Tools

Supports Office/Excel 2007-2021 and 365  |  Available in 44 Languages  |  Easy to Uninstall Completely

 Popular Features: Find/Highlight/Identify Duplicates   |  Delete Blank Rows   |  Combine Columns or Cells without Losing Data   |   Round without Formula ... Super Lookup: Multiple Criteria VLookup  |   Multiple Value VLookup  |   VLookup Across Multiple Sheets   |   Fuzzy Lookup .... Advanced Drop-down List: Quickly Create Drop Down List   |  Dependent Drop Down List   |  Multi-select Drop Down List .... Column Manager: Add a Specific Number of Columns   |   Move Columns   |   Unhide Columns   |   Compare Columns to Select Same & Different Cells ... Featured Features: Grid Focus   |  Design View   |   Big Formula Bar   |  Workbook & Sheet Manager   |  Resource Library (Auto Text)   |  Date Picker   |  Combine Worksheets   |  Encrypt/Decrypt Cells   |  Send Emails by List   |  Super Filter   |   Special Filter (filter bold/italic/strikethrough...) ... Top 15 Toolsets:  12 Text Tools (Add Text, Remove Characters, ...)   |   50+ Chart Types (Gantt Chart, ...)   |   40+ Practical Formulas (Calculate age based on birthday, ...)   |   19 Insertion Tools (Insert QR Code, Insert Picture from Path, ...)   |   12 Conversion Tools (Numbers to Words, Currency Conversion, ...)   |   7 Merge & Split Tools (Advanced Combine Rows, Split Cells, ...)   |   ... and more

Kutools for Excel Boasts Over 300 Features, Ensuring That What You Need Is Just A Click Away...

Supercharge Your Excel Skills: Experience Efficiency Like Never Before with Kutools for Excel  (Full-Featured 30-Day Free Trial)

60-Day Unconditional Money-Back Guarantee

Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

• Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
• Open and create multiple documents in new tabs of the same window, rather than in new windows.
• Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day! (Full-Featured 30-Day Free Trial)
60-Day Unconditional Money-Back Guarantee