How to add serial numbers in excel? [4 methods]

The most common underrated entity in business is the Excel spreadsheet. Created by Microsoft, Excel is a powerful software that allows users to input, manipulate, and visualize data. One of the most important aspects of data is tracking, which is often done through the use of serial numbers. In this article, we’ll show you how to add serial numbers in Excel so that you can keep track of your data more effectively.

Let’s started!

Method 1: Fill Series

The most rudimentary technique to add serial numbers in Excel is by using the “Fill Series” feature. This method is suitable for small data sets that don’t require much manipulation. To use Fill Series, simply select the first serial numbers in the desired column until the cursor turns into a Plus (+) sign and drag it until it reaches the point of the tabulation. Excel will automatically fill in the rest of the serial numbers for you. 

In the example below, the formula is looking for data in cell A2.

To create a cell reference, simply click on the cell you want to reference. In this case, we would click on cell A2 until the cursor turns into a Plus (+) sign as shown below.

Selecting cell

To use Flash Fill, click on the desired position and drag it until it reaches the point of the tabulation, as shown below. 

Fill Series

Now, select “Fill Series” this will automatically fill the serial number in the excel cell. 

Complete filled serial numbers

Method 2: Inserting a Column

You can insert a column next to your data and use a simple formula to fill in the serial numbers. To do this, first, insert a column next to the column where your data is located. Then, in the first cell of the new column, input the following formula: =ROW(). This formula will return the row number of the cell it’s in, which will be created as your serial number. Copy and paste this formula down the column and you should have a column of serial numbers. For example: Here I select A2 cell.

Add the formula

Now, Press enter, this will automatically calculate the number in A2 cell. Click on the desired position and drag it until it reaches the point of the tabulation.

Add the value

Now, selecting “insert a column” will automatically fill the serial number in the excel cell.

Completely Fill the Serial Number

Method 3: Selecting numbers

Select the cell A2, A3 or more (1, 2) and drag it until it reaches your serial number on the cell. See the below example:

Selecting Group Number

Here’s, Complete the numbering

Complete filled Serial Number

Method 4: Continue a series from the menu bar

Open your excel documents, click the Home menu and select “fill” from the Home menu.

Select the menu

Now, Select your cell CTRL + SHIFT + ↑ (Up Arrow)

Selecting the fill option

Click on the Series

Selecting the series

Select step value and stop value. Here I select A2 to A11, After clicking “OK” the selecting cells will fill serial numbers automatically.

Selecting Step value and Stop Value

Finally, I hope this article will help you in adding serial numbers in excel.