brbarto, one way, with 100 in A1, in B1 put =A1+1, select b1 and click on
the fill handle, the little black square on the bottom right , and drag it
over to column F now in A2 put =A1+6 and drag it over to column F next
select A2:F2 and drag it down to row 30, that should do it.

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"brbarto" wrote in
message ...

I would like to be able to enter a number in the first cell and have it
populate a table - 6 columns by 30 rows - incrementing each cell by
one.

For ex, if I enter 100 in the first cell, the rest of the row would be
101,102,103,104,105. The next row would be 106, 107, 108, 109, 110,
111. Etc.

Is there a easy way to do this?

Thanks,
Someone who rarely uses Excel


--
brbarto
------------------------------------------------------------------------
brbarto's Profile:
http://www.excelforum.com/member.php...o&userid=29755
View this thread: http://www.excelforum.com/showthread...hreadid=494773