SOLVED

fill down

New Contributor

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 Replies
best response confirmed by Sergei Baklan (MVP)
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.

thanks!