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!
You should read it
- Page numbering in Word 2016
- How to number columns automatically in Excel
- Complete tutorial of Excel 2016 (Part 5): Basics of cells and ranges
- Numbering in Excel
- Page numbering method of type 1/2 in Excel
- Instructions for numbering in Excel
- Guide to full Excel 2016 (Part 2): Learn about OneDrive
- Complete guide to Excel 2016 (Part 1): Get familiar with Microsoft Excel
- Complete guide to Excel 2016 (Part 10): Use the Find and Replace function
- Complete guide to Excel 2016 (Part 9): Working with multiple spreadsheets
- How to type page numbers in Word 2016
- Page numbering in Excel does not start with number 1
May be interested
How to draw a table - Add, edit, and delete column rows in a table in Excel 2016
How to draw a table - Add, edit, and delete columns in a table in Word 2016
Instructions on how to create drop down lists or drop-down lists in Excel
How to merge multiple messages on 1 page from an Excel table in Word 2016
How to merge messages that contain images in Word 2016
How to convert Inches to centimeters in Word 2016