Jun 28 2022 12:22 PM
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
Jun 28 2022 12:30 PM
SolutionHere'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.
Jun 28 2022 12:30 PM
SolutionHere'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.