Can I fill a series of noncontiguous cells?

D

dmva

I'd like to know if there is a way to fill in numbers in a column, bu
in non-contiguous cells. Edit>Fill>Series only does adjacent cells
from what I have been able to find while experimenting.

I have a number of items in a list that the description of the items i
posted into cells in three rows. All I am trying to do is number thes
items #1 through #500, but they have to skip cells in-between.

Example: Cell A1 is 1, A4 is 2, A7 is 3, A10 is 4. I want to numbe
through 500. That would give me number 1 for rows 1,2 and 3, number
for rows 4,5 and 6, and so on.

I know I can really do this by hand, but I have wondered this for quit
some time, as I have had other applications that I could have used
method to do the same thing.

Thanks.

dmv
 
M

Max

... On 2nd reading of your post, from these lines ..
.. All I am trying to do is number these items #1
through #500, but they have to skip cells in-between.
Click to expand...
.. Example: Cell A1 is 1, A4 is 2, A7 is 3, A10 is 4.
I want to number through 500.
Click to expand...

Perhaps you're actually looking for this?

Put, say,

in A1: 1
in A4: 2

Select A1:A6

Note: Selection *must* include
the 2 blank cells (A5 and A6)

Now drag down the fill handle as far as required

The above will fill in the sequential numbers
skipping 2 cells in-between every number
 
D

dmva

Max, thanks. I knew there should be an easy way to do this, but dumm
me had never investigated how the fill handle worked! Your secon
suggestion worked like a charm.

Thanks again.

dmv
 
Top