Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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? |
#2
![]() |
|||
|
|||
![]()
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" 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If I create a random list in Excel, does it repeat numbers? | Excel Worksheet Functions | |||
Is there a way to create a drop-down list of links in Excel? | Excel Worksheet Functions | |||
create a drop down list with the source from a different workbook | Excel Discussion (Misc queries) | |||
Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
list of sequential numbers | Excel Discussion (Misc queries) |