7 ways to insert Automatic Serial Numbers in Excel

In this video we talk about 7 different ways to add serial numbers in excel.
Serial numbers are like salt. You never feel their presence but their absence makes your data tasteless.

Because with a serial number you can have a unique identity to each entry of your data and you also get a sense of how big or small is your dataset.

But the sad news is, adding them manually is a pain. It’s really hard to add a number in every row one after another.

The good news is, there are some ways which we can use to automatically add serial numbers in a column.

Download the practice file from the link below

Chapters in the video

00:00 Intro
00:58 Fill Handle
01:27 Fill Series
02:11 Add 1 to the previous cell
03:00 ROW Function
03:48 COUNTA Function
04:35 SUBTOTAL with COUNTA
05:45 SEQUENCE Function
07:13 Subscribe, Like , Share

Also, check these videos if you want to learn more

1 Min Excel: If you enjoy short videos check this section

Excel: Check this playlist for Excel-related things

Keyboard Shortcuts: Check this section to save some time in everyday excel work

Pivot Tables: Check this playlist for Pivot Table, Slicers, and Auto refreshing reports

Power Query: Check the Power Query playlist for Data Preparation & its Automation

Power BI: Check the PowerBI related videos for Business Intelligence, Dashboard & Visualisations

Please subscribe to our channel and Follow us on other social media platforms for regular updates :

[robh.]

I want excel to assign a unique number to each row and i want that number to NOT change if I sort my table or if I delete a row. In other words if I have 15 rows and I enter a 16th row I want Excel to auto name it serial number 16 and that serial number will stay with that row no matter if other rows are added or deleted and no mater how I sort those rows. How can I do that?