WEBVTT
Kind: captions
Language: en

00:00:00.030 --> 00:00:02.629 align:start position:0%
 
let's<00:00:00.780><c> say</c><00:00:00.960><c> I've</c><00:00:01.199><c> created</c><00:00:01.530><c> a</c><00:00:01.800><c> formula</c><00:00:02.250><c> and</c><00:00:02.460><c> now</c>

00:00:02.629 --> 00:00:02.639 align:start position:0%
let's say I've created a formula and now
 

00:00:02.639 --> 00:00:04.579 align:start position:0%
let's say I've created a formula and now
we<00:00:02.700><c> want</c><00:00:02.970><c> to</c><00:00:03.030><c> copy</c><00:00:03.330><c> that</c><00:00:03.510><c> formula</c><00:00:03.899><c> to</c><00:00:04.230><c> the</c><00:00:04.319><c> rest</c>

00:00:04.579 --> 00:00:04.589 align:start position:0%
we want to copy that formula to the rest
 

00:00:04.589 --> 00:00:06.800 align:start position:0%
we want to copy that formula to the rest
of<00:00:04.680><c> the</c><00:00:04.799><c> rows</c><00:00:04.980><c> in</c><00:00:05.190><c> my</c><00:00:05.339><c> spreadsheet</c><00:00:05.660><c> you</c><00:00:06.660><c> may</c>

00:00:06.800 --> 00:00:06.810 align:start position:0%
of the rows in my spreadsheet you may
 

00:00:06.810 --> 00:00:08.540 align:start position:0%
of the rows in my spreadsheet you may
already<00:00:07.020><c> know</c><00:00:07.170><c> that</c><00:00:07.440><c> you</c><00:00:07.529><c> can</c><00:00:07.710><c> copy</c><00:00:07.980><c> cells</c><00:00:08.309><c> by</c>

00:00:08.540 --> 00:00:08.550 align:start position:0%
already know that you can copy cells by
 

00:00:08.550 --> 00:00:10.700 align:start position:0%
already know that you can copy cells by
dragging<00:00:09.150><c> the</c><00:00:09.269><c> fill</c><00:00:09.480><c> handle</c><00:00:09.690><c> which</c><00:00:10.349><c> is</c><00:00:10.380><c> this</c>

00:00:10.700 --> 00:00:10.710 align:start position:0%
dragging the fill handle which is this
 

00:00:10.710 --> 00:00:13.820 align:start position:0%
dragging the fill handle which is this
little<00:00:11.010><c> square</c><00:00:11.280><c> here</c><00:00:12.049><c> but</c><00:00:13.049><c> if</c><00:00:13.259><c> you</c><00:00:13.380><c> have</c><00:00:13.559><c> a</c><00:00:13.590><c> lot</c>

00:00:13.820 --> 00:00:13.830 align:start position:0%
little square here but if you have a lot
 

00:00:13.830 --> 00:00:15.650 align:start position:0%
little square here but if you have a lot
of<00:00:13.860><c> rows</c><00:00:14.130><c> this</c><00:00:14.309><c> can</c><00:00:14.519><c> be</c><00:00:14.639><c> pretty</c><00:00:14.969><c> awkward</c><00:00:15.179><c> in</c>

00:00:15.650 --> 00:00:15.660 align:start position:0%
of rows this can be pretty awkward in
 

00:00:15.660 --> 00:00:18.290 align:start position:0%
of rows this can be pretty awkward in
this<00:00:16.289><c> case</c><00:00:16.500><c> I</c><00:00:16.619><c> have</c><00:00:16.770><c> 300</c><00:00:17.460><c> rows</c><00:00:17.670><c> your</c>

00:00:18.290 --> 00:00:18.300 align:start position:0%
this case I have 300 rows your
 

00:00:18.300 --> 00:00:19.400 align:start position:0%
this case I have 300 rows your
spreadsheet<00:00:18.750><c> might</c><00:00:18.930><c> actually</c><00:00:19.109><c> have</c>

00:00:19.400 --> 00:00:19.410 align:start position:0%
spreadsheet might actually have
 

00:00:19.410 --> 00:00:22.400 align:start position:0%
spreadsheet might actually have
thousands<00:00:20.010><c> of</c><00:00:20.070><c> rows</c><00:00:20.279><c> or</c><00:00:20.490><c> even</c><00:00:20.789><c> more</c><00:00:21.410><c> luckily</c>

00:00:22.400 --> 00:00:22.410 align:start position:0%
thousands of rows or even more luckily
 

00:00:22.410 --> 00:00:25.040 align:start position:0%
thousands of rows or even more luckily
there<00:00:22.710><c> is</c><00:00:22.740><c> a</c><00:00:22.830><c> shortcut</c><00:00:23.269><c> just</c><00:00:24.269><c> double</c><00:00:24.720><c> click</c>

00:00:25.040 --> 00:00:25.050 align:start position:0%
there is a shortcut just double click
 

00:00:25.050 --> 00:00:27.830 align:start position:0%
there is a shortcut just double click
the<00:00:25.260><c> fill</c><00:00:25.470><c> handle</c><00:00:25.680><c> and</c><00:00:26.240><c> it</c><00:00:27.240><c> will</c><00:00:27.359><c> copy</c><00:00:27.599><c> the</c>

00:00:27.830 --> 00:00:27.840 align:start position:0%
the fill handle and it will copy the
 

00:00:27.840 --> 00:00:31.669 align:start position:0%
the fill handle and it will copy the
formula<00:00:28.260><c> down</c><00:00:28.289><c> automatically</c><00:00:29.689><c> if</c><00:00:30.689><c> we</c><00:00:31.380><c> scroll</c>

00:00:31.669 --> 00:00:31.679 align:start position:0%
formula down automatically if we scroll
 

00:00:31.679 --> 00:00:33.440 align:start position:0%
formula down automatically if we scroll
down<00:00:31.740><c> you</c><00:00:32.219><c> can</c><00:00:32.279><c> see</c><00:00:32.430><c> that</c><00:00:32.820><c> the</c><00:00:32.910><c> formula</c><00:00:33.180><c> has</c>

00:00:33.440 --> 00:00:33.450 align:start position:0%
down you can see that the formula has
 

00:00:33.450 --> 00:00:35.120 align:start position:0%
down you can see that the formula has
been<00:00:33.480><c> copied</c><00:00:33.989><c> all</c><00:00:34.230><c> the</c><00:00:34.350><c> way</c><00:00:34.440><c> down</c><00:00:34.620><c> to</c><00:00:34.829><c> the</c><00:00:34.950><c> end</c>

00:00:35.120 --> 00:00:35.130 align:start position:0%
been copied all the way down to the end
 

00:00:35.130 --> 00:00:37.250 align:start position:0%
been copied all the way down to the end
of<00:00:35.280><c> our</c><00:00:35.430><c> data</c><00:00:35.640><c> and</c><00:00:35.910><c> it's</c><00:00:36.630><c> just</c><00:00:36.809><c> looking</c><00:00:37.079><c> at</c><00:00:37.170><c> the</c>

00:00:37.250 --> 00:00:37.260 align:start position:0%
of our data and it's just looking at the
 

00:00:37.260 --> 00:00:39.170 align:start position:0%
of our data and it's just looking at the
other<00:00:37.440><c> columns</c><00:00:38.010><c> and</c><00:00:38.280><c> seeing</c><00:00:38.579><c> where</c><00:00:38.850><c> the</c><00:00:39.000><c> data</c>

00:00:39.170 --> 00:00:39.180 align:start position:0%
other columns and seeing where the data
 

00:00:39.180 --> 00:00:42.020 align:start position:0%
other columns and seeing where the data
ends<00:00:39.629><c> and</c><00:00:39.780><c> then</c><00:00:40.020><c> trying</c><00:00:40.260><c> to</c><00:00:40.350><c> match</c><00:00:40.530><c> that</c><00:00:41.000><c> so</c><00:00:42.000><c> I</c>

00:00:42.020 --> 00:00:42.030 align:start position:0%
ends and then trying to match that so I
 

00:00:42.030 --> 00:00:43.850 align:start position:0%
ends and then trying to match that so I
recommend<00:00:42.510><c> using</c><00:00:42.719><c> this</c><00:00:42.960><c> shortcut</c><00:00:43.469><c> whenever</c>

00:00:43.850 --> 00:00:43.860 align:start position:0%
recommend using this shortcut whenever
 

00:00:43.860 --> 00:00:47.450 align:start position:0%
recommend using this shortcut whenever
you<00:00:44.010><c> can</c>

00:00:47.450 --> 00:00:47.460 align:start position:0%
 
 

00:00:47.460 --> 00:00:49.819 align:start position:0%
 
Goodwill<00:00:48.239><c> Community</c><00:00:48.719><c> Foundation</c><00:00:49.379><c> creating</c>

00:00:49.819 --> 00:00:49.829 align:start position:0%
Goodwill Community Foundation creating
 

00:00:49.829 --> 00:00:52.910 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:00:50.430><c> for</c><00:00:50.460><c> a</c><00:00:50.700><c> better</c><00:00:50.730><c> life</c>