A mixed reference is a reference that is fixed only on part of the reference:
- either the row
- or the column
Before showing you an example of a calculation using mixed references, we will detail the use of the $ symbol in a reference.
An absolute reference has two $. There is one for the rows and one for the columns.
But which one does what? 🤔🤨🙄
- If the $ is on the left of the letter, this means you lock the column
- If the $ is on the lest of the row number, you lock the row
Press the key stroke F4 many times to change the position of the $.
The idea here is to create a single formula and copy it for the rest of the entire document. This will save us to write the 99 other formulas 😉😉
We want to stay always on the headers of our table so we will write the formula as follows
- Start by copying the C4 cell (Ctrl + C)
- Then select all the other cells
- Finally, paste the formula (Ctrl + V)
The multiplication table is now correct for every single cells.
We have create only one formula and copy it for the 99 other cells. What a productivity 👍😍😎
How to know where insert the $?
If creating a formula with mixed references is difficult for you at the first glance, there is a trick to know where to put the $. 💡