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.


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.

Using IF Function to Autofill with Repeated Sequential Numbers

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

Using IF Function to Autofill with Repeated Sequential Numbers

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.

Applying MOD Function to Autofill with Repeated Sequential Numbers

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

Applying MOD Function to Autofill with Repeated Sequential Numbers

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


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.

Utilizing Copy Cells from Auto Fill Options to Autofill with Repeated Sequential Numbers

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

Utilizing Copy Cells from Auto Fill Options to Autofill with Repeated Sequential Numbers

  • You will get the set of sequential numbers.

Utilizing Copy Cells from Auto Fill Options to Autofill with Repeated 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.

Use of Keyboard Command to Autofill with Repeated Sequential Numbers

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!


Related Articles 

Soumik Dutta

Soumik Dutta

Hi! I am Soumik. I have completed my Bachelor of Science in Naval Architecture and Marine Engineering. I have found my calling in Machine Learning and Data Science, and in pursuing so, I have realized the importance of Data Analysis. Excel is one excellent tool to fulfill the purpose. I am always trying to learn every day about different features of Excel and trying to share here what I am learning.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo