Jump to content

Need help with Excel


RedRocket1647545505

Recommended Posts

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?

Link to comment
Share on other sites

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.
Link to comment
Share on other sites

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.
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...