how do I have rows automatically number each row when I add a new row?

Question

how do I have rows automatically number each row when I add a new row?

Anonymous

how do I make excel rows automatically renumber when I add a new row?

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

1 additional answer

Answer 1

HansV 462.6K MVP Volunteer Moderator

Do you want sequential numbers?

One option is to enter the formula =ROW() in a cell in row 1 and then fill down. After inserting rows, fill down again.

Another option is to enter the formula =SEQUENCE(100) in the cell where you want to start numbering. This will enter the numbers 1 to 100.

0 comments

Answer 2

Anonymous

thanks!

0 comments

Share via

how do I have rows automatically number each row when I add a new row?

1 additional answer