Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 24th 09, 01:45 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2009
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

  #2   Report Post  
Old June 24th 09, 01:52 PM posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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   Report Post  
Old June 24th 09, 01:52 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2009
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   Report Post  
Old June 24th 09, 09:38 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,909
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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


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 12:49 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017