Does anyone know how to make a MULTIPLICATION table in Excel?

[Iron Thrower]

I have to make a multiplication table with numbers 1-10. But i can't just input the numbers, i have to use mixed references for the formula. Does anyone know how to do this?? Many thanks, Iron

 

[Zirakzigil]

Put the number 5 in A1
Put the number 1 in B1
Put =$A1 * $B1 in C1
Put =$B1 + 1 in B2
Copy B2 and paste into B3 through B10
Copy C1 and paste into C2 through C10

Now you have multiplied 1..10 by 5.


I think.

 

[Zirakzigil]

btw disclaimer, I haven't used Excel in years...

 

[Iron Thrower]

ok, thanks for the help, that one didn't exactly work, but i am still playing with it. I am supposed to copy the formula in the single cell, to the rest of the row and column. dammit

 

[Zirakzigil]

*Zirak summons up long forgotten knowledge*

Ok, I made a mistake I think. You can't copy C1 into C2 through C10 because it will print all zeros right? You have to type C2 through C10 in manually.

In C2, put: =$A1*$B2
in C3, put: =$A1*$B3
in C4, put: =$A1*$B4
..etc..

Maybe there is a better way to do this but I don't have Excel here so I can't help

 

[Iron Thrower]

I figured it out, you do something like =$A4*B3........> all the way to the end.

then do it for each number in the different rows.

Thanks for the help though. Iron

 

[mrbill]

Iron...you basically got it. Just remember the absolute cell reference needs to look like this: $a$1
the dollar sign needs to be in front of both terms. you can set it up like this:

put the numbers 1-10 in cells b1 through k1
put the numbers 1-10 in cells a2 through a11

this will make a grid: now enter first formula in cell b2. enter formula $b$1*a2
now drag formula to cell b11 by grabing black dot in corner of cell b2 and dragging down to cell b11

do this for every column and you are done

 

[Iron Thrower]

Iron...you basically got it. Just remember the absolute cell reference needs to look like this: $a$1
the dollar sign needs to be in front of both terms. you can set it up like this:

put the numbers 1-10 in cells b1 through k1
put the numbers 1-10 in cells a2 through a11

this will make a grid: now enter first formula in cell b2. enter formula $b$1*a2
now drag formula to cell b11 by grabing black dot in corner of cell b2 and dragging down to cell b11

do this for every column and you are done

Thanks Mrbill, that basically is what i did, but easier. I took my like 2 hours to figure out this shit. I can't believe it was that easy. Thanks for the info. Iron

 

[mrbill]

glad you got it...usually if you mess around a little you can figure most of the basic stuff out (especially with the HELP)