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.
Download Practice Workbook
Download this practice workbook for practice while you are reading this article.
4 Quick Ways to Autofill in Excel with Repeated Sequential Numbers
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 Create a Number Sequence 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. The steps of this approach are given below:
📌 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.
Read More: How to Create a Number Sequence in Excel Based on Criteria
Similar Readings
- Subtotal Formula in Excel for Serial Number (3 Suitable Examples)
- Auto Generate Serial Number in Excel VBA (4 Ways)
- How to Add Automatic Serial Number with Formula in Excel
- How to Find Repeated Numbers in Excel (5 Easy Methods)
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. The procedure of this process is given below:
📌 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.
Read More: How to Add Numbers 1 2 3 in Excel (2 Suitable Cases)
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.
Read More: Auto Numbering in Excel After Row Insert (5 Suitable Examples)
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.
Don’t forget to check our website ExcelDemy for several Excel-related problems and solutions. Keep learning new methods and keep growing!