Excel table numbering is a useful tip to support your statistical work. It helps you easily manage and track Excel spreadsheet information. At the same time, this tip helps you look professional at work. However, not everyone knows the numbering trick in Excel. The article below will tell you how to number ordinal in excel The fastest, the easiest.
How to number an ordinal in Excel by dragging the mouse
Numbering the order by dragging the mouse in the spreadsheet is very easy and fast. Just follow the steps below:
Step 1: Enter the first 2 consecutive digits in the No column.
Number excel worksheet by dragging mouse
2nd step: Select 2 cells containing the ordinal number entered in cells A2 and A3. Then drag the mouse along the plus icon in the lower corner, right 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 sequentially in your worksheet.
Hold and drag the plus sign to enter numbers into the worksheet
Sequential numbering with a simple formula
Follow these simple steps:
Step 1: Enter the ordinal number in the first cell of the worksheet or column to be numbered.
Step 2: In the next cell, enter the formula:
= A2+1 (where, A2 is the first entered cell number; 1 is the distance between two consecutive ordinal numbers). Then press Enter to get the second cell number.
Enter the formula to number the next cell
Step 3: To number subsequent cells, move your mouse over the plus icon in the lower right corner of cell A3. Hold and drag the mouse to the cell you want to number in order.
So, with a simple formula, you have completed the auto-numbering of your spreadsheet. And get the result as shown below.
Enter ordinal numbers using a simple formula
How to number Excel worksheet with Fill Series
Numbering Excel spreadsheets with Fill Series is also quite easy to do. You perform the following actions:
Step 1: Similar to the two methods above, enter the ordinal number of the first cell. Then, on the Home tab, select Fill. The Fill Element window appears, choose to click Series, displayed as shown below:
Select columns if they are numbered in column order
In the “Series in” window, select Rows if you are numbering by rows and Columns if you are numbering by columns. Continue, enter the jump “Step value” and the last value “Stop value” is the number you need to enter in the box shown in the image.
Step 2: After selecting and filling in the desired parameters, click OK to complete the spreadsheet order.
Number results with autofill
How to number an ordinal in an Excel worksheet with the Row function.
The numbering operation with Fill Series is quite simple. However, it is a static value function. So when you add or delete rows, the value does not change in the worksheet. You must re-enter the correct sequence number.
But instead of entering it again with autofill, you can use the LINE function to autonumber the Excel sheet. How to enter ordinal numbers using the LINE function as follows:
Step 1: Enter the formula for the function LINE = LINE () – 1 (where: 1 is the distance between 2 consecutive numbers, called a jump).
Enter the formula for the ROW function in column A3 of the Excel table
Step 2: Hold down the plus sign in the lower right corner of cell A3 and drag the mouse to the cells you want to number in ordinal.
With the ordinal numbering method using the ROW function, it will help you adjust automatically when adding or deleting rows. The operation is also quite simple and easy to understand.
here are the how to number ordinal in excel Super fast and simple operation that we share with you. I hope these auto number methods will be useful for your work.