serial number formula for excell sheet

  • Thread starter Thread starter Rizwan
  • Start date Start date
R

Rizwan

hi,
when im making to much rows data like more than 30 thousand, i want to put
the serial number by puting formula and it put serial number with out scroll
or copy system. plz help if u got it.

thanks
 
Place this in the startcell,
say in A2: =ROWS($1:1)
Then just drag A2 down all the way
Or just double click on A2's fill handle (if the adjacent col is filled)

voila? clap it, click the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
 
Enter 1 in A1

In namebox type A1:A34000 and hit ENTER

Edit>fill>Series>Linear and OK


Gord Dibben MS Excel MVP
 
Back
Top