Excel - Create serial numbers

April 2018


I have an Excel file that shows different values of schedule of correspondence and some of the mails are gone to different addresses and the mail ref. colum (showed only once). I want to count the mails serially. How to create exact serial numbers?

I want to skip the rows that have no values i.e. ref of the mails.

Example :

04/02/2010	C. Fox	Al-Futtaim Carillion	M. LEWIS 

04/02/2010	A. Simp	Al-Futtaim Carillion	I. AL-QUDAH 
04/02/2010	R. Pal	Al-Futtaim Carillion	A. Kumar 

Please provide a formula.


You Can Use ROW() function for generating serial numbers,
for example,

In A1 cell write:

=ROW() and press Enter,that will give 1 as answer.

Now click on A1(i.e. Select it)-> Press Ctrl+Shift+Down(to select the below fields which will get its serial now..) -> After selecting the column Goto--EDIT->FILL->DOWN

This will fill all the cells with the respective ROW number...

Thanks to Jyot Patel for this tip.
Published by aakai1056. Latest update on May 1, 2012 at 12:28 PM by aakai1056.
This document, titled "Excel - Create serial numbers ," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (https://ccm.net/).
Excel - Concatenate cells "line by line"
Excel - A macro to set and autofill a range