Forum Discussion
fill down
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
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.
2 Replies
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!
