Using Absolute vs Relative References in Excel 🔒 #excel

In this video, you will learn how to use absolute vs relative references in Excel!

A1 = Relative column, relative row
$A$1 = Absolute column, absolute row
A$1 = Relative column, absolute row
$A1 = Absolute column, relative row

To cycle between absolute and relative references press F4.

Don't waste time spending countless hours on manual, repetitive tasks in Excel 🚫

Join Miss Excel's FREE Masterclass to learn all of her favorite tips & tricks. In this fun power-packed 1 hour session, you'll learn her secret hacks for optimizing your data visualization skills to save you hours each week!

Limited spots available! Register at our link on channel page! 🎉

#excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials