WEBVTT

00:02.250 --> 00:08.100
Okay guys are going to have a look at an absolute cell reference so I have a column of numbers down

00:08.100 --> 00:08.570
here.

00:08.580 --> 00:13.590
And one thing to do in sell a one is just type three let's just type three.

00:13.800 --> 00:21.160
So I'm going to write a similar formula wrong and say is this cell multiplied by this cell.

00:21.330 --> 00:28.520
But when I'm selecting a cell a 1 1 I'm going to do is push EF 4 on the keyboard and you can see in

00:28.530 --> 00:37.010
the formula bar that we now have the formula equals a three multiplied by dollar sign a dollar sign.

00:37.020 --> 00:37.720
1.

00:37.890 --> 00:41.080
So that's absolute a absolute one.

00:41.150 --> 00:44.230
And I'm going to hit enter and there's our formula.

00:44.310 --> 00:48.740
Now I'm going to copy it down just as we did before using the drag handle and double click in.

00:48.770 --> 00:54.910
But this time noticed what's happened as I moved down here when I hit F2.

00:55.110 --> 01:01.750
You can see that the a reference has moved down in line with our copy in the formula down.

01:01.750 --> 01:06.960
So instead of calculating on a 3 it's now looking at a 4.

01:07.140 --> 01:08.700
But the other cell.

01:08.730 --> 01:17.760
The absolute absolute one has been anchored up the corner to always be a and one.

01:17.880 --> 01:25.650
And then if I come down to here and hit EF 2 again you can see that the first cell a 10 has moved down

01:25.710 --> 01:28.000
relative to where the formula is.

01:28.110 --> 01:36.030
But it game because we put the dollar sign a dollar sign one that is an absolute cell reference state

01:36.360 --> 01:42.730
it's always going to multiply by a 1 because those dollar signs lock it in column.

01:42.780 --> 01:44.620
And luckily it's column 1.

01:44.820 --> 01:52.650
So if we if we were to copy that formula across what would happen let's just copy it over there and

01:52.650 --> 01:54.040
copy it down.

01:54.250 --> 01:55.850
That's dragnet down.

01:56.130 --> 02:03.540
So even when we come over here and hit EF 2 you can see that this cell has moved relative to its position

02:03.540 --> 02:05.260
where the formula lies.

02:05.460 --> 02:11.240
But still absolute absolute one is always the second operator.

02:11.430 --> 02:18.900
So by putting a dollar sign or hitting EF 4 once puts a dollar sign in front of the column letter and

02:18.900 --> 02:26.430
the row number and where ever you move your formula that particular cell reference will absolutely never

02:26.430 --> 02:30.980
move it becomes an absolute cell reference.

02:30.990 --> 02:31.530
So they go.

02:31.530 --> 02:37.170
That's an absolute cell reference in the next lecture we're going to have a look at an absolute and

02:37.170 --> 02:40.450
relative cell reference with absolute A.

02:40.530 --> 02:42.580
One I'll see you in the next year.
