Need help with Excel

[RedRocket1647545505]

It's been years since I've had an Excel class in high school, so I can't seem to remember a damn thing about it.

 

I'm trying to do something that seems like it should be simple, but I can't figure it out.

 

I'm trying to make a chart.

 

I've got a row of numbers on top, and a row of numbers down the left side. I want Excel to fill in the chart for me with the product of these rows.

 

ex. C x 3 = C3; F x 11 = F11, etc.

 

Does that make any sense?

[CRed05]

Left to right is a row, up and down is a column.

 

If i understand correctly.... Paste this into B2: =A2*B1

[CRed05]

If thats right, click on B2 and drag it down to all the cells you want it in, and then to the right.

[RedRocket1647545505]

Well, the formula worked for that cell, however, it wants to change the formula for the other cells. Not sure how to fill all the cells at once.

[twistedfocus1647545489]

To make it keep the same numeric values you may want to cut/paste that formula into multiple cells (4ish) then select all of them and try the drag feature. Usually if you have multiple formulas that need to retain a static value this trick will make it remain consistent.

[TURBOED]

I only skimmed what everyone has said, but, if you put a "$" in front of either part of a cell reference, it will keep that static. For instance, $B5 will keep "B" as the column no matter where you drag that cell. B$5 will keep 5 as the row, while $B$5 will keep that exact cell reference anywhere you drag it.

[RedRocket1647545505]

Hmm, still can't get it.

[kenny]

rtfm

[Sully]

rtfm

 

winnar!!

[RedRocket1647545505]

that didn't work.

 

[blacksi]

Well, I don't know dick about excel but reading the above posts I think I figured it out.

=A2*B$1 In cell b2 Then highlight b2 down to whatever and hit Ctrl D to fill down. Then move to the next column and replace B$1 with C$1.

[blacksi]

Well, did it work?

[RedRocket1647545505]

Well, did it work?

 

I gave up. It wasn't important.