Hi,
By using the ROW() or COLUMN() functions, it's possible to generate many
series.
For instance, assuming you want to go down the sheet, if in cell A1 you put
=row() and copy down, you will get 1 2 3 4 5 6 7 8 9 etc.
Here are a few variations
=2*ROW() will generate 2 4 6 8 10 12 14 etc
=2*ROW()-1 will generate 1 3 5 7 9 11 13 etc
=3*ROW()-2 will generate 1 4 7 10 13 16 etc
=ROW()^2 will generate 1 4 9 16 25 36 etc
=ROUNDUP(ROW()/2,0) will generate 1 1 2 2 3 3 4 4 5 5 etc
=MOD(ROW()-1,3) will generate 0 1 2 0 1 2 0 1 2 etc

Or are we all on the wrong track here?

Dave


"Suleman Peerzade" wrote:

Hi,

Assuming that you are asking for a simple series of number 1,2,3,4,etc....
if you want Col wise then fill 1 in Col A1 and 2 in Col B1 then select both
these cells and drag from the LHS lower corner of the cell to whatever number
you want.

2)
If you want Row wise then fill 1 in col A1 and 2 Col A2 and drag vertically
as mentioned above.

In both the above options you will get the numbers in series.
--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade


"passion_queen" wrote:

I'm studying Excel 2007, and I am having trouble creating a series of numbers
within Excel.