View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
ozgrid.com ozgrid.com is offline
external usenet poster
 
Posts: 464
Default how to drag the cell to assign numbers by skipping one row each ti

I A1 enter 1
In A3 enter 2


Select A1:A4 and drag down.



--
Regards
Dave Hawley
www.ozgrid.com
"Paran" wrote in message
...
1
skip
2
skip
3
skip
4
and so on...