WEBVTT

0
00:02.880 --> 00:08.100
Okay guys, we're just going to very quickly cover a couple of ways of copying a formula to save you

1
00:08.100 --> 00:13.570
having to rewrite it.
In the last lecture we covered how to use the autosum function...

2
00:13.590 --> 00:18.750
...so what we're going to do now is we're going to copy that formula all the way across the bottom of our

3
00:18.750 --> 00:19.790
data.

4
00:19.800 --> 00:27.150
The first thing we can do is copy the cell by hitting CTRL and C...selecting the cells we want to

5
00:27.150 --> 00:32.370
paste to by left clicking it, and hitting CTRL and V.

6
00:32.820 --> 00:38.340
And if I move the cursor at the way you can see there that our former has been successfully copied to

7
00:38.340 --> 00:44.160
get rid of the dancin and just hit the escape key on your keyboard and they go that's one way of copying

8
00:44.160 --> 00:45.180
formula.

9
00:45.420 --> 00:46.900
And then we just delete that.

10
00:47.280 --> 00:53.610
Alternatively we can select the formula we have and we can come over to this little box just at the

11
00:53.610 --> 01:01.640
bottom right hand corner hover over his left click and drag as far as we want to go.

12
01:02.550 --> 01:07.440
And then when we let go of our left mouse button they go you can see that the phone has been copied

13
01:07.530 --> 01:09.600
all the way across.

14
01:09.600 --> 01:11.090
Let me just delete that.

15
01:11.310 --> 01:18.090
And the other way is if you come to the cell immediately to the right of the cell you want to copy and

16
01:18.090 --> 01:23.370
hit control and are which is the keyboard shortcut for phil..

17
01:23.400 --> 01:24.050
Right.

18
01:24.060 --> 01:32.460
Control an Are You can see that it's been copied across again so we can either copy using control and

19
01:32.460 --> 01:39.010
say move over either hit Control envy or just hit enter.

20
01:39.060 --> 01:45.990
We can drag it over when our cursor changes to the black cross or we can left click in the cell immediately

21
01:45.990 --> 01:51.990
to the right of it hit control and ah and they go and that's a copy right now.

22
01:52.230 --> 01:57.220
Very quickly I'm also going to show you the same way to do it going downwards.

23
01:57.240 --> 01:59.910
Now again we have exactly the same options.

24
01:59.940 --> 02:03.570
We can either hit Control and see moved down here.

25
02:03.570 --> 02:12.120
Control and the image still we can hit Control and see come down and hit enter and they go that gets

26
02:12.120 --> 02:19.560
rid the downs in ants we can come to the cell immediately below it hit Control endi which is the keyboard

27
02:19.560 --> 02:21.930
shortcuts for fell down.

28
02:23.230 --> 02:30.070
We can also drag down to fill them when we hover over the box up the corner and our cursor changes.

29
02:30.070 --> 02:36.020
We can just drag down let go and they go whoops we can see that the formula's been copied.

30
02:36.190 --> 02:41.650
But if we're talking about the vertical plane there is another very quick way to copy the formula down

31
02:42.130 --> 02:48.160
in vein if you come to this little box up the corner hover over it until your cursor changes to a plus

32
02:48.850 --> 02:54.900
double click and you can see that the formula is being copied all the way down.

33
02:54.910 --> 02:59.850
Now the way it works where the bottom of the range is it just looks the cell immediately to the left

34
02:59.860 --> 03:03.070
to find out where the last entry is they go.

35
03:03.080 --> 03:05.330
Another time saving tip for Excel.

36
03:05.620 --> 03:05.870
Okay.

37
03:05.880 --> 03:11.500
Next we're going to have a look at how we can adapt the auto some formula so we can actually use it

38
03:11.650 --> 03:12.220
to some.

39
03:12.230 --> 03:13.740
A row of data.

40
03:13.930 --> 03:14.340
Okay.

41
03:14.380 --> 03:15.710
See you in the next lecture.