One of the commonest topics that Excel newbies find challenging is the whole when they copy down a formula and it apparently stops working or at least does weird stuff.
Here is the starting file.
Here is the finished file
Also here are some tips on when to use a fixed (absolute reference)
- You need to use the same cell for multiple calculations (like the example in the video)
- You are calculating a percentage of a total (you need to fix the total)
- You are referencing a specific range in a formula e.g. a vlookup or a list of holidays in a Networkdays function.
You can read more about using fixed references here.
In this video I give you an introduction to how to use a fixed (absolute reference) in your formulas.
In the video, I mention about using the double click to copy down the formulas. If for reason that doesn’t work – check the following: