RedRocket1647545505 Posted November 11, 2008 Report Share Posted November 11, 2008 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? Quote Link to comment Share on other sites More sharing options...
CRed05 Posted November 11, 2008 Report Share Posted November 11, 2008 Left to right is a row, up and down is a column. If i understand correctly.... Paste this into B2: =A2*B1 Quote Link to comment Share on other sites More sharing options...
CRed05 Posted November 11, 2008 Report Share Posted November 11, 2008 If thats right, click on B2 and drag it down to all the cells you want it in, and then to the right. Quote Link to comment Share on other sites More sharing options...
RedRocket1647545505 Posted November 11, 2008 Author Report Share Posted November 11, 2008 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. Quote Link to comment Share on other sites More sharing options...
twistedfocus1647545489 Posted November 11, 2008 Report Share Posted November 11, 2008 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. Quote Link to comment Share on other sites More sharing options...
TURBOED Posted November 11, 2008 Report Share Posted November 11, 2008 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. Quote Link to comment Share on other sites More sharing options...
RedRocket1647545505 Posted November 11, 2008 Author Report Share Posted November 11, 2008 Hmm, still can't get it. Quote Link to comment Share on other sites More sharing options...
kenny Posted November 11, 2008 Report Share Posted November 11, 2008 rtfm Quote Link to comment Share on other sites More sharing options...
Sully Posted November 11, 2008 Report Share Posted November 11, 2008 rtfm winnar!! Quote Link to comment Share on other sites More sharing options...
RedRocket1647545505 Posted November 11, 2008 Author Report Share Posted November 11, 2008 that didn't work. Quote Link to comment Share on other sites More sharing options...
blacksi Posted November 12, 2008 Report Share Posted November 12, 2008 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. Quote Link to comment Share on other sites More sharing options...
blacksi Posted November 12, 2008 Report Share Posted November 12, 2008 Well, did it work? Quote Link to comment Share on other sites More sharing options...
RedRocket1647545505 Posted November 13, 2008 Author Report Share Posted November 13, 2008 Well, did it work? I gave up. It wasn't important. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.