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

Word- Find and Replace 1
Numbering Rows 2
Referencing cells in consecutive rows 2
Excel - Wich Function should I use? 1
Finding the proper style field and the numbered paragraph value within the style 0
Excel does not accept text format! 0
Need Help with a VBA subroutine 0
Conditional Formatting - Given dates within certain range of days 4

Top