How to Use an Absolute Reference in Excel

In this tutorial, I show how to use an absolute reference in Excel. You will also here this referred to as locking a cell reference in place. You can lock a cell reference in a specific cell, in row, or in a column. You can also use this with ranges to lock a cell range reference in place.

Stay up to date with FREE lessons by subscribing to our newsletter
https://www.modernschoolbus.com/free-...

Timestamps
00:00 Intro
1:30 Using Absolute Cell Reference
2:02 Locking a Cell Reference in a Row
2:58 Locking a Cell Reference in a Column
4:07 Locking a Cell Range Reference

#excel #exceltips #exceltutorial #exceltutorialforbeginners