Excel Table

M

M

I want to build a table which grow in two dimention.
For example, 12 numbers list on the columns and rows, and for a
Multiplication Table: 1x1=1, 1x2=2, 1x3=3, .... , 4x6=24,...

I am wondering whether there's a way to insert a formula to a cell so
that when you use the "fill down" function, it will form the table
automatically. As because the table will grow to 1000s rows and
columns and seems to be impossible to do it manually.

Thanks in advance.
M
 
F

Frank Kabel

Hi
enter the following formula in A1
=ROW()*COLUMN()
and copy this down and to the right
 
J

Jim Rech

the table will grow to 1000s rows and columns

Well it won't grow to thousand of columns because there are only 256!

A more conventional approach than Frank's:

-Enter 1 and 2 in A2 and A3. Grab the fill handle and drag down as many
rows as you wish.

-Enter 1 and 2 in B1 and C1. Grab the fill handle and drag right as many
columns as you wish.

-In B2 enter: =B$1*$A2.

-Drag this formula down as many rows as you filled in column A. And then
drag this entire range of filled formulas to the right as many columns as
you filled in row 1.
 
Top