Excel table numbering This is a useful tip to support your statistical work. It helps you easily manage and track information on Excel spreadsheets. At the same time, this tip helps you show professionalism at work. However, not everyone knows the trick of numbering in Excel. In the article below we will tell you How to Number Sequentially in Excel the quickest, the simplest.
How to number sequentially in Excel by dragging the mouse
Drag-and-drop numbering in the spreadsheet is very quick and easy. Simply follow the steps below:
Step 1: Manually enter the first 2 consecutive digits in the STT column.
Number Excel worksheet by dragging
2nd step: Select the 2 cells containing the serial numbers you just entered in cells A2 and A3. Then drag the mouse along the plus icon in the lower right corner of cell A3. Hold down the plus sign and drag the mouse to the end of the worksheet or to the desired cell. Accordingly, you will number them sequentially in your spreadsheet.
Hold and drag the plus sign to fill the sequential number in the worksheet
Numbering using a simple formula
You follow these simple steps:
Step 1: Enter the serial number in the first cell of the worksheet or column that needs to be numbered.
Step 2: In the next box, enter the formula:
= A2+1 (in which A2 is the first cell number entered; 1 is the distance between 2 consecutive numbers). Then by pressing Enter you will get the second cell number.
Enter the formula to number the next cell
Step 3: To number the following cells, move your mouse to the plus icon in the lower right corner of cell A3. Hold down the key and drag the mouse to the cell you want to number.
So, with a simple formula, you have done the automatic numbering of your spreadsheet. And get the result as shown below.
Enter the serial number using a simple formula
How to number Excel worksheets using Fill Series
Numbering Excel spreadsheets using Fill Series is also quite simple to do. You perform the following operations:
Step 1: Similar to the two methods above, enter the serial number of the first cell. Then, on the Home tab, select Fill. The Fill Section window appears, choose to click Series, displayed as shown below:
Select Columns if you are numbering by column
In the “Series in” window, select Rows if you are numbering in rows and Columns if you are numbering in columns. Continue, complete the step “Step Value” and the last value “Stop Value” is the sequential number you need to enter in the box shown in the image.
Step 2: After selecting and filling in all the desired parameters, click OK to finalize the spreadsheet order.
Results are numbered sequentially using autofill
How to Number Sequentially in Excel Worksheets Using the Row Function
Numbering with Fill Series is quite simple. However, this is a static-valued function. So when you add or remove rows, the value will not change in the worksheet. You must enter the correct order number again.
But instead of retyping with Auto Fill, you can use the ROW function to automatically number the Excel table. How to enter ordinal numbers using the ROW function is as follows:
Step 1: Enter the function formula ROW= ROW()- 1 (where: 1 is the distance between two consecutive numbers, called jump).
Enter the formula for the ROW function in column A3 of the Excel table
Step 2: Hold the plus sign at the bottom right corner of cell A3 and drag the mouse to the cells you want to number.
The numbering method using the ROW function will help you automatically adjust when adding or removing rows. The operation is also quite simple and easy to understand.
Above, here are these How to Number Sequentially in Excel Super fast and simple operation that we share with you. Hope these automatic numbering methods will be useful for your work.