Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excell spread sheet: reinstate number of rows to 50 | New Users to Excel | |||
Formula for serial number | Excel Discussion (Misc queries) | |||
Formula for serial number | Excel Discussion (Misc queries) | |||
Serial number allocation - Array formula | Excel Worksheet Functions | |||
automatic new serial number for each new sheet within one file | Excel Worksheet Functions |