Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
slenhart
 
Posts: n/a
Default Numbering rows in a worksheet

How do get Excel to number each row? i.e. 1, 2, 3

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Michl
 
Posts: n/a
Default Numbering rows in a worksheet

In cell A1 enter =ROW() then copy down.

- John

Reply
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
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
Linking rows of data to another worksheet Slovenc0417 Excel Discussion (Misc queries) 5 January 10th 06 08:06 PM
Three tables on one worksheet, need to hide rows Chiku Excel Discussion (Misc queries) 12 December 6th 05 10:47 PM
How to increase the maximum rows in the worksheet? ken2005 Excel Discussion (Misc queries) 4 June 30th 05 12:31 PM
numbering all pages in worksheet Lyn Familant via OfficeKB.com Excel Discussion (Misc queries) 1 February 12th 05 02:26 AM


All times are GMT +1. The time now is 02:09 AM.

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

About Us

"It's about Microsoft Excel"