Numbering in Excel

This article provides a clear overview of Numbering in Excel, with the main facts, useful context, and practical details organized for easy reading.

The article shows you 2 ways to automatically numbered in Excel.

Method 1

Step 1: You enter the first order number in the first position to number. You can enter the first number you may need to start with, for example: 1 (can be 2, 3 or any number).

Step 2: Select the box you just entered the first order and select the tab Home on the toolbar. In the Editing section you choose Fill -> Series .

Step 3: Series dialog box appears, you set some options:

Series in: in Series has 2 options, you select Rows if you may need to number by the row, select Columns if you may need to number by the column.

Type: There are 4 options:

- Linear: numbering in ascending fashion.

- Growth: numbered in a progressive manner.

- Date: type of date.

- AutoFill: autofill type.

To number by ascending order you select Linear .

Step value: enter the space between two sequence numbers (hops). For example, if you enter 1, the sequence number will be 1, 2, 3. if you enter 2, the ordinal number will be 1, 3, 5.

Stop value: enter the last value, the stop number. For example, if you only want to number from 1 to 10, then you enter 10 in the Stop value box.

After making your selection, click OK .

You will then get the following result:

Method 2

Step 1: You enter at least the first 2 consecutive numbers.

- If you may need to type in the column, then you enter 2 numbers according to the column.

- If you may need to number by the line you enter 2 numbers in line.

- If you may need to sequentially increase by one unit, you enter 2 numbers 1 unit apart, if you may need to number each other, how many units you enter 2 numbers, respectively.

Step 2: You select (black out) 2 consecutive numbered boxes, then move the mouse to the bottom right corner position to appear the cursor in the form of the + sign as shown below:

Step 3: When the mouse pointer appears as you hold down the mouse, drag the mouse to the last position to be numbered.

Step 4: Release the mouse and the result is as follows:

So just with very simple manipulations, you quickly numbered all the data in Excel spreadsheets. Good luck!