Mixed Reference in Excel

Wondering how to use mixed cell references in Excel?

In this video, we’ll discuss the differences between relative, absolute and mixed cell references and how to use them like a pro!

Skip to:
0:00 - What are mixed cell references?
0:38 - Why use mixed cell references?
0:54 - Example using mixed cell reference
1:59 - Example using mixed cell reference with the sum function
3:52 - Troubleshooting & bulk editing formulas
4:59 - Creating an expanding reference in Excel

#MixedReferences #MSExcel #ExcelTutorial

——

——

For more updates follow us on:

——
Created and presented by Claudia Buckley

[aishailyas]

Thank you for explaining all of this in such a simple manner. Made it easier for my dyslexic brain to understand better 😂

[bakhtsherali]

Explained so elegantly. Thanks teacher

[justinmorales]

amazingly explained. the explanation on YouTube about mixed cell references

[charlestoneoyoo]

Damn--the most concised and up to the point explanation . thank you for this

[leeannparchment]

Aaahh i see my issue now i put the second $ in the wrong place