# Table of incrementing by one numbers

1. ## Table of incrementing by one numbers

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

2. ## Re: Table of incrementing by one numbers

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" <brbarto.20bgem_1135044603.5812@excelforum-nospam.com> wrote in
message news:brbarto.20bgem_1135044603.5812@excelforum-nospam.com...
>
> 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
>

3. ## Re: Table of incrementing by one numbers

Just another play to try ..

Assume the starting number will be entered
in a cell outside the 6 C x 30 R table, say, in G1

Then we could populate the table
by placing in any starting cell, say, in A1:

=IF(\$G\$1="","",\$G\$1+ROW(A1)*6-6+MOD(COLUMN(A1)-1,6))

and copy A1 across 6 cols to F1, fill down by 30 rows to F30
(or copy A1 down by 30 rows to A30, fill across 6 cols to F30)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"brbarto" <brbarto.20bgem_1135044603.5812@excelforum-nospam.com> wrote in
message news:brbarto.20bgem_1135044603.5812@excelforum-nospam.com...
>
> 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
>

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1