Maybe....

I put 1 in A1 and 2 in A3
then I selected A1:A4 (including 2 empty cells)
and rightclicked on the autofill button and dragged down the range.

When I let go of the mouse, I chose Fill Series.

And I ended up with 1, 2, 3, ... in every other row.

Daniel Q. wrote:

Is there anyway to fill cells by highlighting 2 or 3 at a time but have the
fill go only consecutively? i highlight 2 cells at a time and i want it to
go 1, 2, 3 every 2 cells rather it goes, 1, 3, 5.

DSQ

--

Dave Peterson