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.
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.
To use Flash Fill, click on the desired position and drag it until it reaches the point of the tabulation, as shown below.
Now, select “Fill Series” this will automatically fill the serial number in the excel cell.
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.
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.
Now, selecting “insert a column” will automatically fill the serial number in the excel cell.
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:
Here’s, Complete the numbering
Open your excel documents, click the Home menu and select “fill” from the Home menu.
Now, Select your cell CTRL + SHIFT + ↑ (Up Arrow)
Click on 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.
Finally, I hope this article will help you in adding serial numbers in excel.