How do I create a list of sequential numbers using Excel or Acces.

I am trying to generate a list of numbers, incrementally increased to my
specifications. I absolutely hate the idea of having to do these
myself....is there a way to have Excel or Access generate this list for me?

To set your own increment criteria you would first need to enter the first 2 values, ie 1 in cell A1 and 3 in cell A2. Highlight both these values and click on the black square (tag) at the bottom right of cell A2. Holding down the left mouse key drag down as far as you want. Numbers are automatically entered in increments of 2.

Hope this helps

Badger

There are all kinds of ways of doing this, but what are your
specifications, and restrictions.

Increment by one
insert a 1 into cell A1 or a formula =ROW() into cell A1

place 1 into cell A1, drag down with right mouse button, fill series

place =ROW() * 5 - 1 into cell A1
drag down with mouse, or
drag down with right mouse button, fill values (still be formulas)

If you have a value to the left, or if none then cells with values on the right,
you can double click to fill-down, more information on
use of the fill handle in
http://www.mvps.org/dmcritchie/excel/fillhand.htm

Then, of course, if you know what you want and where you want it
you could do it in a macro.

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Clueless" <[email protected]> wrote ...
> I am trying to generate a list of numbers, incrementally increased to my
> specifications. I absolutely hate the idea of having to do these
> myself....is there a way to have Excel or Access generate this list for me?