Microsoft Excel 19 Cell References in Formulas

SimpleTutorials

Microsoft Excel is a powerful spreadsheet application used for organizing, analyzing, and visualizing data. In this course, you will learn the essential skills you need to get started and become confident in using Excel.  In this video lesson, we will learn about Cell References in Formulas in Microsoft Excel  You can access the entire Microsoft Excel Course in the following playlist: https://www.dailymotion.com/playlist/xa9hyw

Transcript

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.

Category

Transcript

Be the first to comment

Recommended