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
---
"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.

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

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