View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default How to get from 1 - 50

On Jan 2, 5:45*pm, JayKimball
wrote:
How can I get a collum to go from 1-50 with out typing 1 then 2 then 3
so on and so forth in every row?


Yet another way....

Enter 1 into A1. Enter =A1+1 into A2, right click and select Copy.
Enter A3:A50 in the Name Box of the Formula Bar, right click and
select Paste.