Numbering Rows

R

Roxie

I would like to number rows in a spreadsheet. A2= 1, A3= 2, etc to #2007.
What is the best way to do this?

Thank you.
 
G

Gord Dibben

In A2 enter =ROW()-1

Copy down to row 2008

OR In namebox enter A2:A2008 and ENTER to select that range.

In Active cell enter =ROW()-1 then hit CTRL + ENTER to copy down.


Gord Dibben MS Excel MVP
 

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 1
Add rows depend on the number in a cell 3
Add Rows depends on the number in a cell 1
help with spreadsheet 1
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
Getting a formula to do the following: 2
Adding rows based on no of rows specified from a given position 1
What type of "lookup" 3

Top