Help!

how to automatically number rows in an excel worksheet

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Worksheet Functions RSS
Next:  How do I assign a numerical value to a textual en..  
Author Message
NewKid
External


Since: Dec 21, 2005
Posts: 11



PostPosted: Mon Sep 11, 2006 3:17 pm    Post subject: how to automatically number rows in an excel worksheet
Archived from groups: microsoft>public>excel>worksheet>functions (more info?)

Hello,

I am trying to automatically number rows in a worksheet. I have used the
=ROW(A1) function and that works alright, BUT it doesn't re-adjust
automatically after a row has been deleted or inserted. I also tried
selecting the range and creating it as a LIST, which works when we delete a
row, but when I insert a row, I have to double-click on the cross-hair on the
bottom right corner of the previous cell.

Does anyone know a way around this?

MANY thanks!!
Back to top
David Billigmeier
External


Since: Mar 08, 2006
Posts: 107



PostPosted: Mon Sep 11, 2006 3:19 pm    Post subject: RE: how to automatically number rows in an excel worksheet [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Don't include a cell reference within ROW()... i.e. just use =ROW()

--
Regards,
Dave


"NewKid" wrote:

> Hello,
>
> I am trying to automatically number rows in a worksheet. I have used the
> =ROW(A1) function and that works alright, BUT it doesn't re-adjust
> automatically after a row has been deleted or inserted. I also tried
> selecting the range and creating it as a LIST, which works when we delete a
> row, but when I insert a row, I have to double-click on the cross-hair on the
> bottom right corner of the previous cell.
>
> Does anyone know a way around this?
>
> MANY thanks!!
>
Back to top
NewKid
External


Since: Dec 21, 2005
Posts: 11



PostPosted: Mon Sep 11, 2006 3:27 pm    Post subject: RE: how to automatically number rows in an excel worksheet [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Thank you! Two questions:

1) when I use the =Row() function, then I cannot give the starting row the
number 1 - it returns the row number that the cell is actually part of.

2) While this worked for me when inserting a row, it did not automatically
adjust the numbers when I deleted a row.

Perhaps I'm doing something wrong.

NewKid

"NewKid" wrote:

> Hello,
>
> I am trying to automatically number rows in a worksheet. I have used the
> =ROW(A1) function and that works alright, BUT it doesn't re-adjust
> automatically after a row has been deleted or inserted. I also tried
> selecting the range and creating it as a LIST, which works when we delete a
> row, but when I insert a row, I have to double-click on the cross-hair on the
> bottom right corner of the previous cell.
>
> Does anyone know a way around this?
>
> MANY thanks!!
>
Back to top
Marcelo
External


Since: Jun 19, 2006
Posts: 565



PostPosted: Mon Sep 11, 2006 4:28 pm    Post subject: RE: how to automatically number rows in an excel worksheet [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

hi,

try it
http://www.j-walk.com/ss/excel/usertips/tip035.htm

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"NewKid" escreveu:

> Thank you! Two questions:
>
> 1) when I use the =Row() function, then I cannot give the starting row the
> number 1 - it returns the row number that the cell is actually part of.
>
> 2) While this worked for me when inserting a row, it did not automatically
> adjust the numbers when I deleted a row.
>
> Perhaps I'm doing something wrong.
>
> NewKid
>
> "NewKid" wrote:
>
> > Hello,
> >
> > I am trying to automatically number rows in a worksheet. I have used the
> > =ROW(A1) function and that works alright, BUT it doesn't re-adjust
> > automatically after a row has been deleted or inserted. I also tried
> > selecting the range and creating it as a LIST, which works when we delete a
> > row, but when I insert a row, I have to double-click on the cross-hair on the
> > bottom right corner of the previous cell.
> >
> > Does anyone know a way around this?
> >
> > MANY thanks!!
> >
Back to top
NewKid
External


Since: Dec 21, 2005
Posts: 11



PostPosted: Mon Sep 11, 2006 5:09 pm    Post subject: RE: how to automatically number rows in an excel worksheet [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Thanks Marcelo!
This will work nicely for my purposes! Thanks again.

NewKid in Minnesota, USA



"Marcelo" wrote:

> hi,
>
> try it
> http://www.j-walk.com/ss/excel/usertips/tip035.htm
>
> hth
> --
> regards from Brazil
> Thanks in advance for your feedback.
> Marcelo
>
>
>
> "NewKid" escreveu:
>
> > Thank you! Two questions:
> >
> > 1) when I use the =Row() function, then I cannot give the starting row the
> > number 1 - it returns the row number that the cell is actually part of.
> >
> > 2) While this worked for me when inserting a row, it did not automatically
> > adjust the numbers when I deleted a row.
> >
> > Perhaps I'm doing something wrong.
> >
> > NewKid
> >
> > "NewKid" wrote:
> >
> > > Hello,
> > >
> > > I am trying to automatically number rows in a worksheet. I have used the
> > > =ROW(A1) function and that works alright, BUT it doesn't re-adjust
> > > automatically after a row has been deleted or inserted. I also tried
> > > selecting the range and creating it as a LIST, which works when we delete a
> > > row, but when I insert a row, I have to double-click on the cross-hair on the
> > > bottom right corner of the previous cell.
> > >
> > > Does anyone know a way around this?
> > >
> > > MANY thanks!!
> > >
Back to top
Marcelo
External


Since: Jun 19, 2006
Posts: 565



PostPosted: Mon Sep 11, 2006 5:32 pm    Post subject: RE: how to automatically number rows in an excel worksheet [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

thanks for the feedback

--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"NewKid" escreveu:

> Thanks Marcelo!
> This will work nicely for my purposes! Thanks again.
>
> NewKid in Minnesota, USA
>
>
>
> "Marcelo" wrote:
>
> > hi,
> >
> > try it
> > http://www.j-walk.com/ss/excel/usertips/tip035.htm
> >
> > hth
> > --
> > regards from Brazil
> > Thanks in advance for your feedback.
> > Marcelo
> >
> >
> >
> > "NewKid" escreveu:
> >
> > > Thank you! Two questions:
> > >
> > > 1) when I use the =Row() function, then I cannot give the starting row the
> > > number 1 - it returns the row number that the cell is actually part of.
> > >
> > > 2) While this worked for me when inserting a row, it did not automatically
> > > adjust the numbers when I deleted a row.
> > >
> > > Perhaps I'm doing something wrong.
> > >
> > > NewKid
> > >
> > > "NewKid" wrote:
> > >
> > > > Hello,
> > > >
> > > > I am trying to automatically number rows in a worksheet. I have used the
> > > > =ROW(A1) function and that works alright, BUT it doesn't re-adjust
> > > > automatically after a row has been deleted or inserted. I also tried
> > > > selecting the range and creating it as a LIST, which works when we delete a
> > > > row, but when I insert a row, I have to double-click on the cross-hair on the
> > > > bottom right corner of the previous cell.
> > > >
> > > > Does anyone know a way around this?
> > > >
> > > > MANY thanks!!
> > > >
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Worksheet Functions All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum