If you work with large data then it’s better to add a serial number column to it. For me, the best way to do this is to apply the table (Control + T) to the data and then add 1 in the above serial number, just like below.
![excel tips tricks to add serial numbers](https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/images/optimized/rev-a53ee6c/wp-content/uploads/2018/01/1-excel-tips-tricks-to-add-serial-numbers.png)
To do this, you simply need to add 1 to the first cell of the column and then create a formula to add 1 to the above cell’s value. As you are using a table, whenever you create a new entry in the table, Excel will automatically drop down the formula and you will get the serial number.
No comments:
Post a Comment