View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier
 
Posts: n/a
Default automatically number every other row

Hi

One way
Enter a 1 in A1, 2 in A3.
Mark cells A1:A4.
Grab the fill handle (the small black cross that appears as you hover
over the bottom right corner of cell A4) and drag down as far as you
need.

--
Regards

Roger Govier


"KGB" wrote in message
...
Hi, I need to be able to number every other row on my spread sheet.
The
numbers must be 1,2,3 ect. but I need to skip a row inbetween each. Is
this
possible? Thanks