Method 1: Using the Fill Handle

1. Enter Initial Values: In the first cell (e.g., A1), type 1, and in the next cell (A2), type 2.
2. Select Cells: Highlight both cells.
3. Drag the Fill Handle: Move your cursor to the bottom-right corner of the selection until it turns into a small black cross (the Fill Handle). Click and drag down to fill the cells with sequential numbers.

   2
4. 2 Sources

   2

Method 2: Using Fill Series

1. Enter Starting Number: Type 1 in the first cell where you want the serial numbers to start.
2. Access Fill Series: Go to the Home tab, click on Fill in the Editing group, and select Series.
3. Configure Series: In the dialog box, choose Columns under Series in, set the Stop Value to your desired end number, and click OK. This will fill the column with numbers from 1 to your specified stop value.

   2
4. 2 Sources

   2

Method 3: Using the ROW Function

1. Enter Formula: In the first cell (e.g., A1), type the formula =ROW(A1). This will return the row number, starting from 1.
2. Drag Down: Use the Fill Handle to drag the formula down to fill the subsequent cells with increasing numbers. If you want to start from a different number, you can adjust the formula, for example, =ROW(A1) + 4 to start from 5.

   2
3. 2 Sources

   2

Method 4: Combining ROW with TEXT (for Custom Formats)

1. Enter Formula: In the first cell, type =TEXT(ROW(A1), "000-000") to create a serial number format like 001-001.
2. Drag Down: Use the Fill Handle to fill the rest of the cells with this format.

   1

   
   These methods provide flexible options for generating serial numbers in Excel, whether you need simple sequential numbers or more complex formats. Choose the one that best fits your needs!
3. 1 Source

   1