Excel Function: How to Create Number Sequence in Excel - Populate Column With Numbers

Problem: If you want to generate number 1 to 2000 in column number A. Number will start from A2. How can you do it?

To generate numbers from 1 to 2000 in column A starting from cell A2 in Excel 2021, you can follow these steps:

1. Using Fill Handle:

   1. Type 1 in cell A2.
   2. Type 2 in cell A3.
   3. Select cells A2 and A3.
   4. Drag the fill handle (a small square at the bottom-right corner of the selection) down until you reach cell A2001.

2. Using the SEQUENCE Function:

   1. Click on cell A2.
   2. Enter the following formula:

      excel
      =SEQUENCE(2000, 1, 1, 1)
      

   3. Press Enter. This will generate numbers from 1 to 2000 in column A starting from A2.

3. Using VBA: If you prefer to use VBA, you can do so by following these steps:

   1. Press Alt + F11 to open the VBA editor.
   2. Insert a new module by clicking Insert > Module.
   3. Copy and paste the following code into the module:

      vba
      Sub GenerateNumbers()
          Dim i As Integer
          For i = 1 To 2000
              Cells(i + 1, 1).Value = i
          Next i
      End Sub
      

   4. Close the VBA editor.
   5. Press Alt + F8, select GenerateNumbers, and click Run.

These methods will help you populate column A with numbers from 1 to 2000 starting from cell A2.