LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,520
Default Numbering Rows

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
---------------
Jacob Skaria

"Roxie" wrote:

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?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Numbering Rows Roxie Excel Worksheet Functions 2 March 24th 09 12:11 AM
numbering of rows FreddieP Excel Discussion (Misc queries) 3 April 23rd 07 01:28 PM
Numbering Rows [email protected] Excel Discussion (Misc queries) 1 March 2nd 07 02:36 PM
Numbering Rows DaleH Excel Discussion (Misc queries) 1 March 1st 07 05:20 PM
How do I do numbering of rows in Excel when there are blank rows? V Excel Discussion (Misc queries) 1 April 3rd 06 11:24 AM


All times are GMT +1. The time now is 10:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"