Microsoft Excel is an extremely popular Office application among students, offices, researchers. It facilitates a plethora of options to create a huge table. You can create graphs, pie charts, trends of a particular business or scientific model and so on. The numbers of features are almost endless.

One of the common functions, that almost everyone perform in MS Excel is creating serial number columns. While expert users are well aware of the minute details of Excel app, new users may not know these simple tips. If you are writing each and every number in a serial number column individually, then it is time to look at this tip.

Steps To Create A Serial Number Column In MS Excel Sheet Without Individually Typing The Numbers

  • First type numer 1 in the first number entry of the serial number column, then in the next cell of the same column, type 2 and you can write the next number for another cell as well.
serial number excel
  • Next, select these three columns, and take the cursor to the point as shown in the screenshot.
select cursor ms excel
  • As you take the cursor there, it changes into a black ‘‘+’ sign. Now drag anf drop the cursor up to the cell of your choice.
drag and drop
  • As you release the mouse or the touchpad, you will see the serial numbers have been created!
create serial number column

That’s all! Hope this small tip helped you!


Happiness is that best therapy. Use it to heal yourself and then others!


Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.