How do you autofill across horizontal rows or both horizontal and vertical collumns using the same formula?

[happyman5005]

This has been bugging the hell out of me for the past hour. It seems a simple concept but I haven't found anything helpful so far.

Say you have a multiplication table such as:
1 2 3 4 5 6 7 8 9...
on both the first row and column

For the first space (B2) I put in the formula =(B1*A2) and make sure I peg on or the other with $ such as =(B$1*A2) or =(B1*A$2)

Dragging this formula down vertically works out fine however if I autofill horizontally it gives me the previous sum of the previous column multiplied by the above sum. eg.
1 (1) 2 (2) 3 (6) 4 (24) 5 (120)
() being the column directly beneath
How would I make it so that it autofills correctly? Also for something as simple as filling in a multiplication table I feel like there would be a really easy way to do it however the online tutorials only give examples of starting from scratch where you make your own table rather than filling in an existing table.

Another example. Say I want to fill in a table calculating interests added onto a deposit every year such as the one below.

Row 1 ¥10,000 ¥20,000 ¥100,000
Row 2 1% 2% 3% 10% 1% 2% 3% 10% 1% 2% 3% 10%
row 3 (1year) ¥10,100
row 4 (2years)
row 5 (3years)
row 6 (4years)
row 7 (5years)
row 8 (10years)

I would have the formula =FV(B$8,A9,,-B$7) for the first column however I would only be able to use this formula for the first row. What would be the easiest way of filling in this table?

 

[Andrew Poulsom]

Welcome to MrExcel.

Is it?

=B$1*$A2

 

[happyman5005]

Thank You

I tried all combinations. Results are still the same unfortunately.

 

[Andrew Poulsom]

The formula I posted works for me. Enter it in B2 and copy down and across:

Excel 2010
	A	B	C	D	E	F	G	H	I	J
1		1	2	3	4	5	6	7	8	9
2	1	1	2	3	4	5	6	7	8	9
3	2	2	4	6	8	10	12	14	16	18
4	3	3	6	9	12	15	18	21	24	27
5	4	4	8	12	16	20	24	28	32	36
6	5	5	10	15	20	25	30	35	40	45
7	6	6	12	18	24	30	36	42	48	54
8	7	7	14	21	28	35	42	49	56	63
9	8	8	16	24	32	40	48	56	64	72
10	9	9	18	27	36	45	54	63	72	81
Sheet1

Cell Formulas
Range	Formula
B2	=B$1*$A2

 

[happyman5005]

Oh...
I realize that I've been placing the $ in the wrong place this whole time.
So simple yet so frustrating. Thank you so much kind stranger!