A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » New Users to Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

serial number formula for excell sheet



 
 
Thread Tools Display Modes
  #1  
Old June 24th 09, 01:45 PM posted to microsoft.public.excel.newusers
Rizwan[_3_]
external usenet poster
 
Posts: 1
Default 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
Ads
  #2  
Old June 24th 09, 01:52 PM posted to microsoft.public.excel.newusers
Max
external usenet poster
 
Posts: 9,221
Default 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  
Old June 24th 09, 01:52 PM posted to microsoft.public.excel.newusers
NBVC[_32_]
external usenet poster
 
Posts: 1
Default 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  
Old June 24th 09, 09:38 PM posted to microsoft.public.excel.newusers
Gord Dibben
external usenet poster
 
Posts: 22,911
Default serial number formula for excell sheet

Enter 1 in A1

In namebox type A1:A34000 and hit ENTER

Edit>fill>Series>Linear 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


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excell spread sheet: reinstate number of rows to 50 Monica New Users to Excel 3 February 13th 09 04:33 AM
Formula for serial number Vidya Excel Discussion (Misc queries) 0 August 5th 08 02:55 PM
Formula for serial number shaji Excel Discussion (Misc queries) 6 June 25th 07 01:22 PM
Serial number allocation - Array formula Space Ape Excel Worksheet Functions 0 July 3rd 05 07:32 AM
automatic new serial number for each new sheet within one file ahmed Excel Worksheet Functions 1 February 26th 05 01:49 PM


All times are GMT +1. The time now is 04:23 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.