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.
Read More: How to Add Automatic Serial Number with Formula 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.
Download Practice Workbook
Download this practice workbook for practice while you are reading this article.
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Â
- How to Do Automatic Numbering in Excel
- Auto Numbering in Excel After Row Insert
- Automatically Number Rows in Excel
- How to Number Columns in Excel Automatically
- Auto Serial Number in Excel Based on Another Column
- Auto Generate Invoice Number in Excel
- Auto Generate Serial Number in Excel VBA
<< Go Back to Serial Number in Excel | Numbering in Excel | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!