Thread: Fill bar
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Fill bar

I need to paste the following range: into consecutive cells:
=a1,=a4,=a7, =a10 down to about =a1230. When I use the fill handle
after about 3 cells, Excel doesn't seem to understand that I want the
cell reference sequence to increment by 3 each time. Is there a way to
make that happen?