How to Add Autonumber in Excel: Revision history

Jump to navigation Jump to search

Diff selection: Mark the radio buttons of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with latest revision, (prev) = difference with preceding revision, m = minor edit.

21 March 2023

  • curprev 15:5815:58, 21 March 2023Lukegao1 talk contribs 917 bytes +917 创建页面,内容为“ 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…”