Let’s explore how to use these Excel reference types.

What Are Excel Cell References?

What they now want to do is work out the total spend for each month.

Microsoft Excel sheet showing data relating to three items and a blank ‘Total’ table where the totals will be added together using relative references.

it’s possible for you to now complete your formula.

Then, press F4 and you will see the cell reference pop in change.

And you’re done!

Microsoft Excel sheet showing the formula and results when the January spending totals are added together.

Microsoft Excel sheet containing all results for each month after using relative referencing and AutoFill.

Microsoft Excel sheet showing data relating to several employees and a blank ‘Total’ table where their total pay will be added together using absolute references.

Microsoft Excel sheet showing what happens when absolute referencing is not used when it should be.

Microsoft Excel sheet showing the formula and result after absolute referencing has been applied.

Microsoft Excel sheet containing all results for each employee after using absolute referencing and AutoFill.

Microsoft Excel sheet showing data relating to several employees and blank ‘tax payable’ tables where their total tax bill will be calculated using mixed references.

Microsoft Excel sheet showing the formula and result after mixed referencing has been applied.

Microsoft Excel sheet containing all results for Arjun after using mixed referencing and AutoFill.

Microsoft Excel sheet containing all results for all employees after using mixed referencing and AutoFill.

Excel workbook showing the formula bar and the reference to cell G11 highlighted with an arrow.