View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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