00:00So over here you can see that I got some cell data right here. Let me just go ahead and make it let's
00:12say two columns right here just like this. So let's just go ahead and take a reference. Let's
00:17say for example I'm going to go to this particular cell and I'm going to press equals right here and
00:22take this particular cell as a reference and press enter. So you can see that this takes a one as
00:28reference but as soon as I go ahead and drag it you can see that this is a relative reference meaning
00:34this is a one but as soon as I dragged it down you can see that it said a two. Similarly if I were to
00:41drag it onto the right then it'll get the value from the right here and I can go ahead and let's
00:46say for example go around onto these two cells then I can go ahead and click and drag this out
00:52and then you get the relative value. But let's say I want an absolute value like I always want
00:59the reference to be a one. Then what you can do is you can go ahead and type in dollar sign right here
01:04just like this in reference. So this becomes an absolute reference right here. So now if I were to
01:11go ahead and drag this out you can see that the value is still two three four right here. If I were to
01:18drag it onto the right you can still see that the value is still a right here. So this is an absolute
01:24reference as you can see right here. But let's say I'm going to go ahead and do this. So I'm just going
01:29to say dollar a right here just like this so that now the reference is always from column a but you
01:37can see that the rows can change out. So this is a mixed reference. So if I were to go ahead and click
01:43and drag out you can still see that the value changes out right here. So you can see that there's
01:50a one a two a three. But if I were to click and drag this out this does not change into b because we
01:55made uh the column absolute and the row uh relative right here which is a mixed reference. So if I were
02:02to click and drag this out now you can see that this is what you have. So if I were to actually go
02:07around over here on to let's say for example dollar one right here. So let's say now I'm going to go ahead
02:13and make um the uh the column relative and row absolute. So if I were to go ahead and do that now
02:20as I drag this down you can see that the value still remains a one. But as soon as I click and
02:27drag this around over here on to the right this is what you have. You got the column right here as b
02:32and if I were to go ahead and click and drag this out right here this is what you have. So that is how
02:37you can go ahead and utilize cell references in formulas inside of excel as needed. So if you
02:44found this video useful be sure to hit the like button. Don't forget to share this out with your
02:49friends and family. And for more contents like these do follow simple tutorials.
