Numbering Rows

  • Thread starter Thread starter Roxie
  • Start date Start date
R

Roxie

I would like to number rows in a spreadsheet. A2 = 1, A3 = 2, etc to row
2006. What is the easiest way to do this?
 
Dear Roxie

You can also try A2=ROW()-1 which will maintain the row numbering even if
rows are deleted from inbetween. Its up to your requirement.

If this post helps click Yes
 

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

Numbering Rows 2
Add rows depend on the number in a cell 3
Add Rows depends on the number in a cell 1
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
Getting a formula to do the following: 2
What type of "lookup" 3
Cell Shading 2
Avoiding redundant calculations 7

Back
Top