how to automatically number rows in an excel worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!
 
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
 
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
 
Thanks Marcelo!
This will work nicely for my purposes! Thanks again.

NewKid in Minnesota, USA
 
Thanks Marcelo!
This will work nicely for my purposes! Thanks again.

NewKid in Minnesota, USA
 
thanks for the feedback

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



"NewKid" escreveu:
 
thanks for the feedback

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



"NewKid" escreveu:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically hide/unhide rows 5
Excel-Adding rows to master sheet that will be inserted on following worksheets 1
Insert/ delete row in protected worksheet 7
Automatically insert rows/copy formula 1
Delete rows based on contents of Col A 0
How to stop to adjust references automatically 7
Automatic Sorting? 6
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1

Back
Top