People who are new to Excel often opt for the solution of typing each sequence number. For tables with less than 20 lines, this operation is acceptable. However, with statistics and statistics up to several hundred or several thousand ordinal numbers, typing each number is indeed not feasible. Moreover, typing can lead to confusion with sequence numbers in Excel. So you need to know the sequence numbering formulas in Excel to save some time. There are up to 2 ways of numbering sequence in Excel, you can choose the simplest way to use.
Sequence numbering formula in Excel:
1. Sequential numbering in Excel by dragging mouse
Step 1: Open the Excel interface that wants to number the sequence.
Step 2: Enter 2 lines of numbers 1 and 2. Entering these 2 numbers is like a “primer” number for Excel to perform subsequent sequence numbers.
Step 3: Black out these 2 numbers and hover over the right corner of the number 2, until the plus symbol (+) appears, you gradually drag down to the bottom lines.
Step 4: When you can drag the line number corresponding to the sequence number in Excel you need, release the mouse. Immediately a series of sequence numbers in Excel will appear.
2. Excel sequence numbering formula
In addition to the manual method mentioned above, there is also a very effective numbering formula in Excel.
Step 1: Drag your mouse to the line number you want to number. Next, in the Formula bar, enter the formula =ROW(A:A)
Step 2: After entering the formula, press Ctrl + Shift + Enter , you will immediately receive the sequence numbers corresponding to the highlighted line numbers.
With these two ways, users have easily numbered the sequence in Excel. In addition to using sequence numbering formulas in excel, the manual way of dragging the mouse is also very effective. In addition, you can also refer to how
https://thuthuat.taimienphi.vn/cong-thuc-danh-so-thu-tu-trong-excel-23497n.aspx
In Excel, there is also another trick that is quite convenient is to split 1 excel cell into 2 diagonal triangle cells. You can understand simply when creating tables, we usually have the first, largest cell just to number and About the elements in the first horizontal row, so dividing 1 excel cell into 2 diagonal triangle cells helps to divide clearly, displays the separate, most visually pleasing order number and Introduction.