automatic numbering of rows in excel, how to? in Excel Worksheet Functions  
 |  Edit my Profile  |  Help
 
     
   
 
 
 
Linda C. 8/30/2005 6:34 PM PST
  Question
  How can I set up the first column to automatically number each row as I go
down a list in excel?
Office 2000
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Don 8/30/2005 7:04 PM PST
  Answer
  Assuming the data will be entered in column B starting in B1 and the data
are numbers. Put this in cell A1 and copy down.

=IF(ISNUMBER(B1),ROW(),"")


If data are text then substatute ISTEXT for ISNUMBER

Don Pistulka

"Linda C." <Linda C.@discussions.microsoft.com> wrote in message
news:43A80153-3EFB-4541-A914-24518FC4BC46@microsoft.com...
> How can I set up the first column to automatically number each row as I go
> down a list in excel?
> Office 2000


 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Paperback Writer 11/29/2006 10:16 AM PST
   
  This works great, but what if the data can be either numbers or text?

Example:

5444
5445
5446
AXC XSLR
AXC XLLR

"Don" wrote:

> Assuming the data will be entered in column B starting in B1 and the data
> are numbers. Put this in cell A1 and copy down.
>
> =IF(ISNUMBER(B1),ROW(),"")
>
>
> If data are text then substatute ISTEXT for ISNUMBER
>
> Don Pistulka
>
> "Linda C." <Linda C.@discussions.microsoft.com> wrote in message
> news:43A80153-3EFB-4541-A914-24518FC4BC46@microsoft.com...
> > How can I set up the first column to automatically number each row as I go
> > down a list in excel?
> > Office 2000
>
>
>
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Six Sigma Blackbelt 9/3/2008 7:17 AM PST
   
  What I need
excel to do, is to insert numerical numbering into the cells starting at A19,
the formula in B15 multiples B9, B10 and B13, so whatever is the sum of B15,
I need Excel to start inserting numbers numerically at cell A19 to whatever
the sum of B15 is, so if B15 is 30, I need 1 thur 30 inserted starting at A19
thru A49.

Thanks MJS

"Don" wrote:

> Assuming the data will be entered in column B starting in B1 and the data
> are numbers. Put this in cell A1 and copy down.
>
> =IF(ISNUMBER(B1),ROW(),"")
>
>
> If data are text then substatute ISTEXT for ISNUMBER
>
> Don Pistulka
>
> "Linda C." <Linda C.@discussions.microsoft.com> wrote in message
> news:43A80153-3EFB-4541-A914-24518FC4BC46@microsoft.com...
> > How can I set up the first column to automatically number each row as I go
> > down a list in excel?
> > Office 2000
>
>
>
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Spiky 9/3/2008 8:25 AM PST
   
  Put in:
A19: 1
A20: =IF(A19+1>B15,"",A19+1)
Copy to A21 and down as far as you will ever need to go. You may want
to alter your print settings after this so it doesn't print the blank
cells.
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Spiky 9/3/2008 8:25 AM PST
   
  On Sep 3, 10:19 am, Spiky <jeff.thors...@gmail.com> wrote:
> Put in:
> A19: 1
> A20: =IF(A19+1>B15,"",A19+1)
> Copy to A21 and down as far as you will ever need to go. You may want
> to alter your print settings after this so it doesn't print the blank
> cells.

Oops. One change:
A20: =IF(A19+1>$B$15,"",A19+1)
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Six Sigma Blackbelt 9/4/2008 6:22 AM PST
   
  Thanks Spiky, it works just fine...

"Spiky" wrote:

> On Sep 3, 10:19 am, Spiky <jeff.thors...@gmail.com> wrote:
> > Put in:
> > A19: 1
> > A20: =IF(A19+1>B15,"",A19+1)
> > Copy to A21 and down as far as you will ever need to go. You may want
> > to alter your print settings after this so it doesn't print the blank
> > cells.
>
> Oops. One change:
> A20: =IF(A19+1>$B$15,"",A19+1)
>
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Robi 9/12/2008 7:00 PM PST
   
  Hi I'm using excel 2007 ..

I read this topic but FOR text it is not working =IF(ISTEXT(B1),ROW(),"")

but for numbers it is working =IF(ISNUMBER(B1),ROW(),"")

is there anything different for 2007
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Peo Sjoblom 9/12/2008 7:19 PM PST
   
  It certainly works for me, once can of course change it to either text or
numbers

=IF(LEN(B1)>0,ROW(),"")



--


Regards,


Peo Sjoblom




"Robi" <Robi@discussions.microsoft.com> wrote in message
news:1B0B69C1-EE18-43AA-A7BD-D6C9FE48CF35@microsoft.com...
> Hi I'm using excel 2007 ..
>
> I read this topic but FOR text it is not working =IF(ISTEXT(B1),ROW(),"")
>
> but for numbers it is working =IF(ISNUMBER(B1),ROW(),"")
>
> is there anything different for 2007


 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Robi 9/13/2008 12:00 AM PST
   
  Thank you Peo Sjoblm

every code is working for me.. =IF(LEN(B1)>0,ROW(),"")

can help me to say how to add auto number of rows by selecting some rows
which I need to number.. I've 6000 rows.. But they will be numbered by
selecting 200 rows or 300 rows. After 200 they will be counted or number from
1. Is there any way cell selection with mouse and number them?

"Peo Sjoblom" wrote:

> It certainly works for me, once can of course change it to either text or
> numbers
>
> =IF(LEN(B1)>0,ROW(),"")
>
>
>
> --
>
>
> Regards,
>
>
> Peo Sjoblom
>
>
>
>
> "Robi" <Robi@discussions.microsoft.com> wrote in message
> news:1B0B69C1-EE18-43AA-A7BD-D6C9FE48CF35@microsoft.com...
> > Hi I'm using excel 2007 ..
> >
> > I read this topic but FOR text it is not working =IF(ISTEXT(B1),ROW(),"")
> >
> > but for numbers it is working =IF(ISNUMBER(B1),ROW(),"")
> >
> > is there anything different for 2007
>
>
>
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
error 4/10/2009 5:01 AM PST
   
 

"Linda C." wrote:

> How can I set up the first column to automatically number each row as I go
> down a list in excel?
> Office 2000
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
  Return to Microsoft Communities  Notify me of replies