Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How to automatically fill increment cells in Excel?

In our daily Excel work, it’s quite frequent to automatically fill increment cells, for instance, auto fill cells down with 1, 2, 3…. But in some times, you need to fill increment cells with a fixed interval, for instance, 10001, 10012, 10023…, how can you quickly automatically fill increment these cells? Now this tutorial can tell you the solutions.

Automatically fill increment cells with Autofill function

Automatically fill increment cells with formula

Automatically fill increment cells with Kutools for Excel good idea3


arrow blue right bubble Automatically fill increment cells with Autofill function


Actually, in Excel, you can use the Autofill function to quickly fill the increment cells.

Kutools for Excel, with more than 120 handy Excel functions, enhance working efficiency and save working time.

1. Select the cell you want to place your starting number, for instance, in A1, I type 10001, see screenshot:

doc increment number 1

2. Then in the cell below the starting number, here is A2, and type the second number you want into it.

doc increment number 2

3. Then select the A1 and A2, and drag the autofill handle down until below cells are filled with the increment numbers as you need. See screenshots:

doc increment number 3


arrow blue right bubble Automatically fill increment cells with formula

Besides, you can use a formula to solve this autofill.

Kutools for Excel, with more than 120 handy Excel functions, enhance working efficiency and save working time.

1. Select a blank cell and type the starting number into it, and then in the cell below the starting number, type this formula =A1+11 (A1 is the starting number, and 11 is the interval, you can change them as you need). See screenshot:

doc increment number 4

2. Then press Enter key, and drag this formula down to the cells you want to fill with the numbers with fixed interval.

doc increment number 5


arrow blue right bubble Automatically fill increment cells with Kutools for Excel

With Kutools for Excel’s Insert Sequence Number utility, you also can quickly automatically fill increment numbers, and moreover, you can add the prefix or suffix to every number.

Kutools for Excel, with more than 120 handy Excel functions, enhance your working efficiency and save your working time.

After free installing Kutools for Excel, please do as below:

1. Select a list or a range you want to fill the increment cells, then click Kutools > Insert > Insert Sequence Number. See screenshot:

doc increment number 6

2. In the popping Insert Sequence Number dialog, click New to add a new sequence into the dialog. See screenshot:

doc increment number 7

3. In the expanding dialog, do below operations:

1) Name the sequence;

2) Enter the starting number of your increment numbers in Start number textbox;

3) Type the interval number into the Increment textbox;

4) Specify the number of digits of your filled numbers in No. of digits textbox;

5) Type the prefix or suffix into the Prefix (optional) or Suffix (optional) textbox as you need.

doc increment number 8

4. Click Add to add this new incremental sequence number in to the dialog, and then click Fill Range. See screenshot:

doc increment number 9

Now you can see the selected cells are filled with increment number.

doc increment number 10

Note:

1. If you want to reset this incremental sequences, and insert it from the start number again, you can go to the Insert Sequence Number dialog, and select this sequence, and click Reset > Ok.

2. If you want to end the sequence number at a specific number, then repeat insert this sequence from starting number, check End number in the dialog, and type the ending number you want into below textbox, and you can preview that the numbers is end with this number, and then restart the sequence.

doc increment number 11

Click here to free download Kutools for Excel


Insert Workbook Information(insert sheet name, path, user name and so on to a cell, header or footer.)

doc 1

Recommended Productivity Tools

Ribbon of Excel (with Kutools for Excel installed)

300+ Advanced Features Increase Your Productivity by 71%, and Help You To Stand Out From Crowd!

Would you like to complete your daily work quickly and perfectly? Kutools For Excel brings 300+ cool and powerful advanced features (Combine workbooks, sum by color, split cell contents, convert date, and so on...) for 1500+ work scenarios, helps you solve 82% Excel problems.

  •  Deal with all complicated tasks in seconds, help to enhance your work ability, get success from the fierce competition, and never worry about being fired.
  •  Save a lot of work time, leave much time for you to love and care the family and enjoy a comfortable life now.
  •  Reduce thousands of keyboard and mouse clicks every day, relieve your tired eyes and hands, and give you a healthy body.
  •  Become an Excel expert in 3 minutes, and get admiring glance from your colleagues or friends.
  •  No longer need to remember any painful formulas and VBA codes, have a relaxing and pleasant mind, give you a thrill you've never had before.
  •  Spend only $39, but worth than $4000 training of others. Being used by 110,000 elites and 300+ well-known companies.
  •  60-day unlimited free trial. 60-day money back guarantee. Free upgrade and support for 2 years. Buy once, use forever.
  •  Change the way you work now, and give you a better life immediately!

Office Tab Brings Efficient And Handy Tabs to Office (include Excel), Just Like Chrome, Firefox, And New IE

  • Increases your productivity by 50% when viewing and editing multiple documents.
  • Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
  • Open and create documents in new tabs of same window, rather than in new windows.
  • Help you work faster and easily stand out from the crowd! One second to switch between dozens of open documents!
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.