Paste sequential numbers in a column

You can insert sequential numbers in a column based on a specified starting value and increment.

  1. Click the Data Manipulation drop-down menu and select Sequential Numbering.
  2. In the Column field, select the column in which you want to insert sequential numbers.
  3. In the Starting Value field, enter the starting value for the sequential numbers.
  4. In the Increment field, enter the increment for the sequential numbers.
  5. To add leading zeros to the sequential numbers, select the Zero Fill checkbox.
  6. If you selected the Zero Fill checkbox, enter the total number of digits for the sequential numbers in the Fill Width field.
    Note: If you enter 0 in the Fill Width field, no leading zeros will be added to the sequential number.
  7. Click OK.