Numbering in Excel 2016

Numbering in Excel is a great feature that Excel supports to help users work effectively and reach the fastest speed. The following article provides detailed instructions for Numbering in Excel 2016.

1. Numbering with the value being a numerical value

In the process of creating a numbered list is an indispensable operation. There are two ways to number with numbers as follows:

- Use drag and drop

For example, you want to number the table. Enter the starting number and next value in the first 2 cells of the ordinal column -> select the 2 recently entered values ​​move to the lower right corner of the selection when the mouse pointer changes to plus sign -> drag and drop to the last position to be numbered:

Numbering in Excel 2016 Picture 1

The result you have numbered in a simple operation:

Numbering in Excel 2016 Picture 2

- Use the Fill feature

In addition to drag and drop to number, you can use the Fill feature. Enter the first numbered value in the first cell of the ordinal column. For example, here the numbering starts with 1 -> on the Home tab -> Editing -> Fill -> Series:

Numbering in Excel 2016 Picture 3

A dialog box appears with the following values ​​selected:

- Series Series item : Select Columns

- Item Type: Select Linear value

- Step Value: Select the value to start numbering

- Stop vlaue: Enter the last value to number

Numbering in Excel 2016 Picture 4

Finally click OK you have numbered as you like:

Numbering in Excel 2016 Picture 5

In case you want to number by exponential select the Growth feature in the Type section . Example of numbering in powers of 2 to values ​​less than 20:

Numbering in Excel 2016 Picture 6

The results are numbered in powers:

Numbering in Excel 2016 Picture 7

2. Number the number with the date value

In case you have a monthly revenue report, you need to enter date values, as if you were simply entering data one by one so it takes time. For example, enter date values ​​in the table:

Step 1: Enter the value of the first day to calculate revenue:

Numbering in Excel 2016 Picture 8

Step 2: Go to the Home tab -> Editing -> Fill -> Series:

Numbering in Excel 2016 Picture 9

Step 3: A dialog box appears with the following options selected:

- Series Series item : Select Columns

- Item Type: Select Date value

- Date unit: select the Day value .

- Step Value: Choose the value to start with numbered

- Stop vlaue: Enter the value of the last day to number

Numbering in Excel 2016 Picture 10

- Click OK results you have numbered by the date:

Numbering in Excel 2016 Picture 11

With simple operation, you have numbered the number of different data types. Above is a detailed guide on numbering in Excel 2016. I wish you success!