Lukegao1: 创建页面，内容为“ You can add an autonumber to Excel by using the "Fill" feature or by using a formula. Here are the steps: Method 1: Using the Fill feature 1. Enter the starting number in a cell (e.g., 1). 2. Select the cell and drag the fill handle (the small square in the bottom-right corner of the cell) down to the last row you want to number. 3. The numbers will be filled in automatically. Method 2: Using a formula 1. Enter the starting number in a cell (e.g., 1). 2. I…”

2023-03-21T15:58:11Z

创建页面，内容为“ You can add an autonumber to Excel by using the "Fill" feature or by using a formula. Here are the steps: Method 1: Using the Fill feature 1. Enter the starting number in a cell (e.g., 1). 2. Select the cell and drag the fill handle (the small square in the bottom-right corner of the cell) down to the last row you want to number. 3. The numbers will be filled in automatically. Method 2: Using a formula 1. Enter the starting number in a cell (e.g., 1). 2. I…”

New page

You can add an autonumber to Excel by using the "Fill" feature or by using a formula. Here are the steps:

Method 1: Using the Fill feature
1. Enter the starting number in a cell (e.g., 1).
2. Select the cell and drag the fill handle (the small square in the bottom-right corner of the cell) down to the last row you want to number.
3. The numbers will be filled in automatically.

Method 2: Using a formula
1. Enter the starting number in a cell (e.g., 1).
2. In the cell below the starting number, enter the formula "=A1+1" (assuming the starting number is in cell A1).
3. Select the cell with the formula and drag the fill handle down to the last row you want to number.
4. The numbers will be filled in automatically based on the formula.

Note: If you need to start the autonumber at a different value (e.g., 100), you can enter that value instead of 1 in step 1 and adjust the formula accordingly in step 2.

How to Add Autonumber in Excel - Revision history