In this Excel video tutorial, we gonna see How To Use Absolute and Relative Cell References In Excel with Practical Examples.

To lock a cell in Excel or fix a reference we can use the $ dollar sign or the keyboard shortcut key F4.

We can lock rows and columns, that is, we can use an absolute reference to the cell in Excel or we can lock just the row or just the column and this way we will have a relative reference.

Learning how to lock a cell in Excel to prevent it from moving up or down or to the right or left is very important because there are situations where you cannot let the references change, you need to keep the cell in the same position always even when you drag a formula down

We can apply absolute references and relative references in Excel to both formulas and functions, such as addition, multiplication, division, subtraction or sum function, average function, sumif function, vlookup, xlookup etc.

00:00 - Subscribe to the Channel!
00:20 - Like the video!
00:40 - Practical Examples
00:48 - 1st Example
01:35 - 2nd Example
04:34 - 3rd Example

#JopaExcel #Dashboard #Excel