WEBVTT

00:02.360 --> 00:03.790
Okay guys welcome back.

00:03.880 --> 00:11.080
We're going to have a look at an absolute and relative cell reference that is one such as duller A and

00:11.170 --> 00:12.040
one.

00:12.040 --> 00:15.280
So what I've done is I've got a couple of columns of numbers in here.

00:15.610 --> 00:24.160
And one of them do is write a simple formula that says equals this multiply and my this.

00:24.250 --> 00:30.930
But this time what woman I do is his for once and that gives us the absolute absolute one.

00:31.150 --> 00:32.590
I'm going to hit it again.

00:32.710 --> 00:39.360
And then we get a absolute one and I'm going to hit it a third time so this is for three times.

00:39.620 --> 00:42.810
No a get absolute a 1.

00:42.870 --> 00:49.570
And what that's going to do is like all of our formulas when we drag them around to call them a not

00:49.570 --> 00:53.570
necessarily line one but it's going to lock two column.

00:53.620 --> 00:57.600
So let's just copy that down and we can see how that works.

00:57.970 --> 01:06.010
So here when we hear EF 2 we can see that we are multiplying be one which is relative relative to absolute

01:06.150 --> 01:10.060
a one moved down and it's doing exactly the same.

01:10.060 --> 01:16.720
That pretty much looks like it did before but now you'll see when we copy that formula across there

01:16.730 --> 01:20.860
if we click in one of these at random we were in some seriously big numbers over here.

01:21.070 --> 01:29.090
What we have when we hear EF 2 is that this cell is always stuck to Column A.

01:29.170 --> 01:32.670
So D3 has moved over as we've moved the formula.

01:32.740 --> 01:37.340
But the second part of the formula has been locked to column.

01:37.510 --> 01:44.950
It will happily move down based on the line number so we can see here that we have absolute a 7 but

01:44.950 --> 01:47.900
it's always locked to column.

01:47.950 --> 01:56.230
So they go if you type a dollar sign or hit for three times you will lock the column but not the row.

01:56.230 --> 02:01.810
So you now have an absolute column reference and a relative row reference.

02:01.810 --> 02:06.730
So they figure that say you do an absolute relative and you can probably guess what is coming in the

02:06.730 --> 02:07.550
next lecture.

02:07.570 --> 02:12.830
But watch it through anyway and will cover the relative a absolute one.

02:12.850 --> 02:14.300
I'll see you in the next lecture.
