View Single Post
  #4   Report Post  
Sanjay Kumar via OfficeKB.com
 
Posts: n/a
Default

Put "2" in 'A2', and drag it down after selecteion.
If you already have contents in column 'B' say till row number 34.
If you select 'A1:A2' and double-click the cross at the bottom of A2, it will
fill incremented data till 'A34"