Forum Discussion
Solved
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...
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.
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!
