JollyRoger01
New Member
- Joined
- Jun 1, 2021
- Messages
- 12
- Office Version
- 365
- 2016
- Platform
- Windows
I am trying to help my mum with some Excel formulas for a course she is doing and am trying to show her how to use absolute references to drag formulas properly. The problem is I have some references that need to stay the same horizontally and some vertically. If I make the vertical ones absolute, I can drag down. But then I need to manually change each of those references to relative to be able to drag each row across. I am not doing a good job of convincing her that this is more efficient than entering them manually. I know there is a better way of doing this and was wondering if someone can show me.
As an example, in the attached file I have used an absolute reference to D4 inside cell F4, and multiplied that by a percentage in F2. I can drag that formula horizontally all the way to Q4 and the formulas will fill fine. Now if I want to do the same thing on the rows below, I have to remove the absolute reference to D4 and apply an absolute reference to F2, then drag F4 down. Then I have to reverse these references to be able to drag them across, which is very time consuming.
Budget
As an example, in the attached file I have used an absolute reference to D4 inside cell F4, and multiplied that by a percentage in F2. I can drag that formula horizontally all the way to Q4 and the formulas will fill fine. Now if I want to do the same thing on the rows below, I have to remove the absolute reference to D4 and apply an absolute reference to F2, then drag F4 down. Then I have to reverse these references to be able to drag them across, which is very time consuming.
Budget