Latest update on June 17, 2020 at 03:22 AM by David Webb .

Microsoft's office software Excel is a powerful tool to perform day-to-day activities with, like simple arithmetic, sorting, filtering, arranging and summarising data in various formats. Excel has a huge collection of formulas which can be used independently or in conjunction with each other to achieve desired results. This article will show you how to create serial numbers.

How to Create Serial Numbers

Logical formulas can be combined with text or numeric functions to segregate data in any desired way, for example, to exclude rows which do not have serial numbers. The same formula can be applied to multiple cells by simply dragging it to them, or by using paste-special with formulas and number formats.

Steps to Follow


1. You want series to appear in Column A

2. If a row has a data, then column B of that row would have data

3. Row 1 is a header

Write in Cell A2


Drag this formula down

Photo: 123rom

Tomasz David
Tomasz David

Leave a Comment