serial number formula for excell sheet
 

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

serial number formula for excell sheet
 

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
---
"Rizwan" wrote:
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.

serial number formula for excell sheet
 

If you have XL2003, use the List feature in the Data Menu...

If you have XL2007, use the Table feature in the Insert Tab from the
main Ribbon....


--
NBVC

Where there is a will there are many ways.
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=109635

serial number formula for excell sheet
 

Enter 1 in A1

In namebox type A1:A34000 and hit ENTER

EditfillSeriesLinear and OK


Gord Dibben MS Excel MVP

On Wed, 24 Jun 2009 05:45:03 -0700, Rizwan
wrote:

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