See screenshots:īesides, you can use a formula to solve this autofill.ġ. Then select the A1 and A2, and drag the autofill handle down until below cells are filled with the increment numbers as you need. Then in the cell below the starting number, here is A2, and type the second number you want into it.ģ. Select the cell you want to place your starting number, for instance, in A1, I type 10001, see screenshot:Ģ. 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.Īutomatically fill increment cells with Autofill functionĪutomatically fill increment cells with formulaĪutomatically fill increment cells with Kutools for ExcelĪctually, in Excel, you can use the Autofill function to quickly fill the increment cells.ġ. In our daily Excel work, it’s quite frequent to automatically fill increment cells, for instance, auto fill cells down with 1, 2, 3…. How to automatically fill increment cells in Excel?
0 kommentar(er)
