How to Quickly Make Automatic Sequential Numbers in Excel
In this tutorial, we will explain a trick that can be done to sort serial numbers in Excel quickly and easily. The Fill feature available in Excel is used to add serial numbers automatically, so this method will simplify and speed up the process.
To find out how, see the tutorial in the following article!
How to Make Automatic Numbering (Sequential Number) in Excel
- First, type the number one in the table column, then click menu Fill that’s on the tab Editing on the right, and select Series to set the serial number in order.
 |
| click and zoom the image to enlarge |
- Then in the settings, select column And set Stop Value according to the desired number. (For example, if you want to make a serial number from 1 – 50, enter the number 50 in the Stop Value column. Click OK to save.
 |
| click and zoom the image to enlarge |
After following the method above, the serial numbers will be sorted automatically without manual typing.
So, that’s how to make automatic numbering in Excel so that it is sorted.
Hope it is useful!
Other Articles
