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



2 Replies
best response confirmed by Sergei Baklan (MVP)


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.


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