View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default How do I number cells vertically in succession? Example: (1 2 3)

Another way - put the formula:

=ROW(A1)

in your first cell and copy down.

Hope this helps.

Pete

On Oct 2, 4:24 am, rsmith844
wrote:
How do I number cells vertically in succession?
Example:
1
2
3

Thank you.