How to Add Numbers 1 2 3 in Excel (2 Suitable Cases)

If you are searching for the solution or some special tricks to add numbers in Excel with 1 2 3 pattern, then you have landed in the right place. There are some quick and easy ways to add numbers in Excel. You may need to add numbers serially in Excel sometimes or you may need to repeat numbers after an interval. You will find solutions for both situations in this article. This article will show you each step with proper illustrations so you can easily apply them for your purpose. Let’s get into the main part of the article.


Download Practice Workbook

You can download the practice workbook from here:


4 Methods to Add Numbers 1 2 3 Serially in Excel Column

You may need to add numbers in Excel sometimes. In this section, I will show you 4 quick and easy methods to add numbers in Excel columns on Windows operating system. You will find detailed explanations of methods and formulas here. I have used Microsoft 365 version here. But you can use any other versions as of your availability. If any methods don’t work in your version then leave us a comment.

Suppose, you have a dataset that contains the sales forecast and actual quantity per month. Now, you want to add serial numbers in a column. I will show you 4 easy methods to add numbers serially in Excel.

How to Add Numbers 1 2 3 in Excel


1. Use Excel Fill Handle Tool to Add Numbers 1 2 3

You can use the Fill Handle feature of Excel to add numbers to the Excel column. To do this, follow the steps below.

📌 Steps:

  • First, insert 1 in cell B5 and 2 in cell B6. This is to initiate a pattern thus the fill handle will work.
  • Then, select cells B5 and B6.

How to Add Numbers 1 2 3 in Excel

  • Now, place the mouse cursor on the leftbottom corner of cell B6. And you will see the mouse cursor will turn into a plus This is known as the fill handle icon.
  • Then, drag the fill handle icon with the mouse to the last cell of the column. Alternatively, you can just doubleclick on the fill handle icon.

How to Add Numbers 1 2 3 in Excel

  • As a result, you will see that there have been added numbers serially in the column.

How to Add Numbers 1 2 3 in Excel

Read More: How to Increment Row Number in Excel Formula (6 Handy Ways)


2. Use Fill Series Feature

In Excel, there is one more feature that will help you to add numbers serially in a column in Excel. And this is the Fill Series feature. Follow the steps below to use the Fill Series feature to add numbers to a column.

📌 Steps:

  • At first, insert 1 in cell B5.
  • Then, by select the cell B5, go to Home tab >> Editing option >> Fill >> Series option

How to Add Numbers 1 2 3 in Excel

  • Now, the Series window will appear.
  • Select Columns in the Series in option
  • Keep 1 as the Step Value and insert 8 as the Stop Value as you have 8 rows only.
  • Finally, press OK.

How to Add Numbers 1 2 3 in Excel

  • As a result, you will see there have been added numbers serially in the column till number 8.

How to Add Numbers 1 2 3 in Excel

Read More: How to Create a Number Sequence in Excel Without Dragging


3. Utilize ROW Function to Add Numbers Serially

Alternatively, you can use the ROW function to add numbers serially in Excel. To use this function to add numbers in an Excel column, follow the steps below.

📌 Steps:

  • First, insert this formula in the first cell of the column.
=ROW() - 4

Here, the ROW function will give the row number of the cell which is 5. So you have to subtract 4 from this to make it 1.

How to Add Numbers 1 2 3 in Excel

  • Now, drag the fill handle icon to copy and paste the formula to the other cells of the column.

How to Add Numbers 1 2 3 in Excel

  • As a result, you will find the column is filled with serial numbers from 1 to 8.

Read More: Auto Numbering in Excel After Row Insert (5 Suitable Examples)


4. Apply a Cumulative Sum Formula

Also, you can add serial numbers by adding 1 to the previous number. Follow the steps below to do this.

📌 Steps:

  • First, insert 1 in cell B5.

Apply a Cumulative Sum Formula

  • Then, insert this formula in cell B6
=B5+1
  • So, it will add 1 with cell B5.

Apply a Cumulative Sum Formula

  • Now, drag the fill handle icon to the last cell of the column.

Apply a Cumulative Sum Formula

  • As a result, the column is filled with the serial numbers from 1 to 8.

Apply a Cumulative Sum Formula

Read More: Auto Serial Number in Excel Based on Another Column


4 Methods to Repeatedly Add Numbers 1 2 3 in Excel

Sometimes, you may need to repeat numbers in serial after an interval. Suppose, you have a dataset like shown in the screenshot where you have taken only 1st three months of the year. So, you want to serial them from 1 to 3 and start from 1 again. I will show you 4 easy and quick methods to add repeating numbers in Excel.

Repeatedly Add Numbers 1 2 3 in Excel


1. Use AutoFill Options to Add Numbers 1 2 3 Repeatedly

You can use the Fill Handle icon also for adding repeating numbers. To do this, follow the steps below.

📌 Steps:

  • First, insert 1,2,3 serially in the first 3 cells of the column.
  • Then, select the cells from B5:B7.
  • And, drag the Fill Handle icon to the last cell of the column.

Repeatedly Add Numbers 1 2 3 in Excel

  • After dragging, you will find an icon that appeared at the bottom of the column named “Auto Fill Options”.
  • Then, click on the icon and select the “Copy Cells” option.

Repeatedly Add Numbers 1 2 3 in Excel

  • As a result, you will see that the serial numbers are repeating after 3.

Read More: How to Autofill in Excel with Repeated Sequential Numbers


2. Hold Ctrl Key and Drag Fill Handle

You can also use the fill handle icon to copy cells directly. For this, follow the steps below.

📌 Steps:

  • First, insert 1 to 3 serially in the first 3 cells and select them.
  • Then, holding the Ctrl key on the keyboard, place the mouse cursor on the right-bottom corner of cell B7.

Note:

You may notice that there will create two Plus icons – one large and one small and that denotes the copy cells function with the fill handle.

  • Now, drag the fill handle icon to the last cell of the column while holding the Ctrl key.

Repeatedly Add Numbers 1 2 3 in Excel

Read More: How to Create a Number Sequence in Excel Based on Criteria


3. Drag Fill Handle with Mouse Right-Key

You can add repeating numbers in the Excel column by dragging the fill handle icon by right-clicking on the mouse. Follow the steps below.

📌 Steps:

  • First, insert the numbers serially to the cell where you want to repeat.

Drag Fill Handle with Mouse Right-Key

  • Now, select the cells where inserted numbers and drag the fill handle icon with the right button of the mouse.

Drag Fill Handle with Mouse Right-Key

  • After dragging to the last cell of the column, there will appear some options.
  • Then, select the Copy Cells option.

Drag Fill Handle with Mouse Right-Key

  • Now, you will see the column is filled with serial numbers repeating after 3.

Drag Fill Handle with Mouse Right-Key


4. Use Source Cell References

As you want to repeat the serial numbers after an interval each time so you can use a simple formula to do this. Follow the steps below.

📌 Steps:

  • First, insert the numbers serially till the first interval.
  • Then, link the next cell to the first cell of the first interval. For Example, B5 is the first cell of the first interval and B8 is the first cell of the 2nd interval. So insert “=B5” in cell B8 so that cell B8 will show the same value as B5 which is 1.

Use Source Cell References

  • Now, drag the fill handle icon to the last cell of the column.

Use Source Cell References

  • Then, you have the Serial column filled with numbers repeating after 3.

Use Source Cell References


Conclusion

In this article. You have found how to add numbers in Excel 1 2 3 patterns. Also, you have found methods to add numbers serially and add repeating numbers after a certain interval each time. You can download the free workbook and practice yourself. I hope you found this article helpful. You can visit our website ExcelDemy to learn more Excel-related content. Please, drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles 

Osman Goni Ridwan

Osman Goni Ridwan

I am Ridwan, graduated from Naval Architecture and Marine Engineering Dept, BUET, currently residing in Dhaka, Bangladesh. And my passion is to grow up my skillsets with industry demands. My prime goal is to be a data analyst as I do love to solve problems and play with data.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo