How to AutoFill in Excel with Repeated Sequential Numbers

Autofill is an amazing feature of Excel. Using the Autofill feature, we can fill a large range of cells within a short period in several ways. In this article, we are going to demonstrate four easy approaches to autofill in Excel with repeated sequential numbers. If you are curious about the methods, download our practice workbook and follow us.

AutoFill in Excel with Repeated Sequential Numbers: 4 Quick Ways

To demonstrate the approaches, we consider a dataset of 3 sequential numbers in the range of cells B5:B7. We will repeat the series twice and autofill the range of cells B8:B13.

1. Using IF Function

In this method, we are going to use the IF function to autofill with repeated sequential numbers. Through we had 3 sequential numbers in the range of cells B5:B7, we have to apply the formula in cell B6, and we will get the value of cells B6 and B7 using this formula. The steps of this method are given below:

📌 Steps:

• First of all, select cell B6.
• Now, write down the following formula into the cell.

`=IF(B5=3,1,B5+1)`

• Press Enter.

• After that, drag the Fill Handle icon to copy the formula up to cell B13.

• You will get the set of sequential numbers at our desired cells.

Thus, we can say that our formula worked perfectly, and we are able to autofill with repeated sequential numbers in Excel.

2. Applying MOD Function

In this process, we will use the MOD function to autofill with repeated sequential numbers. The procedure is quite similar to the previous one. We have to apply the formula in cell B6, and then we will copy the formula up to cell B13. Follow the steps below to generate auto number sequence with the MOD function in Excel.

📌 Steps:

• First, select cell B6.
• Then, write down the following formula into the cell.

`=MOD(B5,3)+1`

• Press Enter.

• Now, drag the Fill Handle icon to copy the formula up to cell B13.

• Thus, you will get the set of sequential numbers at our desired cells.

Finally, we can say that our formula worked successfully, and we are able to autofill with repeated sequential numbers in Excel.

3. Utilizing Copy Cells from Auto Fill Options

In the following process, we will use Excelâ€™s Copy Cells option from the drop-down of the Auto Fill options to autofill with repeated sequential numbers. Let’s follow the instructions below to add numbers 1 2 3 sequentially in Excel.

📌 Steps:

• At first, select the range of cells B5:B7.

• After that, drag the Fill Handle icon up to cell B13.
• You may notice that all the cells are filled with 1-9 numbers sequentially.

• Now, click on the Auto Fill options at the right-bottom corner of the dataset.
• Then, select the Copy Cells option.

• You will get the set of sequential numbers.

In the end, we can say that our working method worked perfectly, and we are able to autofill with repeated sequential numbers in Excel.

4. Use of Keyboard Command

In this approach, we are going to use the keyboard command to autofill repeated sequential numbers. The procedure of this approach is explained below step-by-step:

📌 Steps:

• At the beginning of this process, select the range of cells B5:B7.

• Now, wild press the â€˜Ctrlâ€™ key and drag the Fill Handle icon up to cell B13.
• You will see those 3 sequential numbers repeated in the whole range of cells within a second.

At last, we can say that our working method worked successfully, and we are able to autofill with repeated sequential numbers in Excel.

Conclusion

Thatâ€™s the end of this article. I hope that this article will be helpful for you and you will be able to autofill in Excel with repeated sequential numbers in Excel. Please share any further queries or recommendations with us in the comments section below if you have any further questions or recommendations.

Related ArticlesÂ

<< Go Back to Serial Number in Excel | Numbering in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Soumik Dutta

Soumik Dutta, having earned a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, plays a key role as an Excel & VBA Content Developer at ExcelDemy. Driven by a profound passion for research and innovation, he actively immerses himself in Excel. In his role, Soumik not only skillfully addresses complex challenges but also demonstrates enthusiasm and expertise in gracefully navigating tough situations, underscoring his unwavering commitment to consistently deliver exceptional, high-quality content that... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF