fill down

[marty691]

I am trying to use fill down feature to copy formula.  Intitial formula =A2*C6.  I want to fill down keeping A2 constant with all forumulas  (A2*C6, A2*C7,...)  When I grab the bottom right corner to fill down the first factor changes to A3.  Any advice is welcomed

 thanks

[#2 · Accepted solution]

@marty691 

Here's where you should start. One of the basic features of Excel--the ability to make what is called an "Absolute Reference"--is what you're looking for.

https://exceljet.net/glossary/absolute-reference

The formula would be =($A$2*C6), but don't just take that. Use that link to read up on the concept itself.

[#3]

thanks!