View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default how to number cells (1,2,3...) w/o having to manually type them al

In your first cell, say A1, enter 1.
In your second, say A2, enter =a1+1
Now drag this formula down your column as far as you want to go.

Regards,
Fred

"Botkinmama" wrote in message
...
am making a form for signing up items. Need to number column cells (1, 2,
3...) without having to do it manually. Is there a function that will do
it
for me?