WEBVTT
Kind: captions
Language: en

00:00:00.030 --> 00:00:02.240 align:start position:0%
 
the<00:00:00.359><c> format</c><00:00:00.780><c> painter</c><00:00:01.079><c> offers</c><00:00:01.469><c> an</c><00:00:01.650><c> easy</c><00:00:01.920><c> way</c><00:00:02.190><c> to</c>

00:00:02.240 --> 00:00:02.250 align:start position:0%
the format painter offers an easy way to
 

00:00:02.250 --> 00:00:04.130 align:start position:0%
the format painter offers an easy way to
copy<00:00:02.610><c> formatting</c><00:00:03.270><c> from</c><00:00:03.419><c> one</c><00:00:03.720><c> part</c><00:00:03.990><c> of</c><00:00:04.049><c> your</c>

00:00:04.130 --> 00:00:04.140 align:start position:0%
copy formatting from one part of your
 

00:00:04.140 --> 00:00:06.349 align:start position:0%
copy formatting from one part of your
spreadsheet<00:00:04.650><c> to</c><00:00:04.680><c> another</c><00:00:04.920><c> this</c><00:00:05.910><c> is</c><00:00:06.060><c> one</c><00:00:06.210><c> way</c>

00:00:06.349 --> 00:00:06.359 align:start position:0%
spreadsheet to another this is one way
 

00:00:06.359 --> 00:00:08.179 align:start position:0%
spreadsheet to another this is one way
to<00:00:06.390><c> ensure</c><00:00:06.690><c> that</c><00:00:06.870><c> things</c><00:00:07.259><c> stay</c><00:00:07.529><c> consistent</c>

00:00:08.179 --> 00:00:08.189 align:start position:0%
to ensure that things stay consistent
 

00:00:08.189 --> 00:00:10.129 align:start position:0%
to ensure that things stay consistent
without<00:00:08.550><c> spending</c><00:00:08.970><c> a</c><00:00:09.120><c> lot</c><00:00:09.330><c> of</c><00:00:09.360><c> time</c><00:00:09.450><c> trying</c><00:00:09.990><c> to</c>

00:00:10.129 --> 00:00:10.139 align:start position:0%
without spending a lot of time trying to
 

00:00:10.139 --> 00:00:12.230 align:start position:0%
without spending a lot of time trying to
replicate<00:00:10.920><c> your</c><00:00:10.950><c> formatting</c><00:00:11.610><c> manually</c><00:00:12.090><c> in</c>

00:00:12.230 --> 00:00:12.240 align:start position:0%
replicate your formatting manually in
 

00:00:12.240 --> 00:00:14.570 align:start position:0%
replicate your formatting manually in
this<00:00:13.019><c> example</c><00:00:13.380><c> our</c><00:00:13.650><c> dates</c><00:00:13.950><c> have</c><00:00:14.160><c> very</c>

00:00:14.570 --> 00:00:14.580 align:start position:0%
this example our dates have very
 

00:00:14.580 --> 00:00:17.029 align:start position:0%
this example our dates have very
inconsistent<00:00:15.179><c> formatting</c><00:00:15.870><c> in</c><00:00:16.080><c> addition</c><00:00:16.920><c> to</c>

00:00:17.029 --> 00:00:17.039 align:start position:0%
inconsistent formatting in addition to
 

00:00:17.039 --> 00:00:18.590 align:start position:0%
inconsistent formatting in addition to
the<00:00:17.190><c> fonts</c><00:00:17.609><c> and</c><00:00:17.820><c> alignment</c><00:00:18.449><c> being</c>

00:00:18.590 --> 00:00:18.600 align:start position:0%
the fonts and alignment being
 

00:00:18.600 --> 00:00:20.840 align:start position:0%
the fonts and alignment being
inconsistent<00:00:19.380><c> they</c><00:00:19.740><c> also</c><00:00:20.010><c> use</c><00:00:20.220><c> a</c><00:00:20.250><c> variety</c><00:00:20.550><c> of</c>

00:00:20.840 --> 00:00:20.850 align:start position:0%
inconsistent they also use a variety of
 

00:00:20.850 --> 00:00:23.210 align:start position:0%
inconsistent they also use a variety of
different<00:00:21.090><c> date</c><00:00:21.480><c> formats</c><00:00:21.930><c> some</c><00:00:22.590><c> use</c><00:00:22.800><c> along</c>

00:00:23.210 --> 00:00:23.220 align:start position:0%
different date formats some use along
 

00:00:23.220 --> 00:00:25.609 align:start position:0%
different date formats some use along
date<00:00:23.490><c> others</c><00:00:24.150><c> use</c><00:00:24.420><c> a</c><00:00:24.449><c> short</c><00:00:24.930><c> date</c><00:00:25.140><c> without</c><00:00:25.320><c> the</c>

00:00:25.609 --> 00:00:25.619 align:start position:0%
date others use a short date without the
 

00:00:25.619 --> 00:00:28.790 align:start position:0%
date others use a short date without the
year<00:00:25.890><c> and</c><00:00:26.070><c> so</c><00:00:26.699><c> on</c><00:00:26.849><c> I</c><00:00:27.060><c> want</c><00:00:28.050><c> all</c><00:00:28.230><c> of</c><00:00:28.260><c> these</c><00:00:28.560><c> to</c>

00:00:28.790 --> 00:00:28.800 align:start position:0%
year and so on I want all of these to
 

00:00:28.800 --> 00:00:30.769 align:start position:0%
year and so on I want all of these to
match<00:00:29.010><c> the</c><00:00:29.279><c> formatting</c><00:00:29.760><c> of</c><00:00:29.880><c> the</c><00:00:29.939><c> first</c><00:00:30.510><c> date</c>

00:00:30.769 --> 00:00:30.779 align:start position:0%
match the formatting of the first date
 

00:00:30.779 --> 00:00:33.440 align:start position:0%
match the formatting of the first date
to<00:00:31.769><c> do</c><00:00:31.949><c> this</c><00:00:32.070><c> just</c><00:00:32.399><c> click</c><00:00:32.460><c> the</c><00:00:32.669><c> format</c><00:00:33.149><c> painter</c>

00:00:33.440 --> 00:00:33.450 align:start position:0%
to do this just click the format painter
 

00:00:33.450 --> 00:00:36.229 align:start position:0%
to do this just click the format painter
command<00:00:33.780><c> on</c><00:00:33.989><c> the</c><00:00:34.170><c> Home</c><00:00:34.320><c> tab</c><00:00:34.380><c> and</c><00:00:34.940><c> it</c><00:00:35.940><c> will</c><00:00:36.059><c> copy</c>

00:00:36.229 --> 00:00:36.239 align:start position:0%
command on the Home tab and it will copy
 

00:00:36.239 --> 00:00:38.209 align:start position:0%
command on the Home tab and it will copy
all<00:00:36.570><c> of</c><00:00:36.600><c> the</c><00:00:36.840><c> formatting</c><00:00:37.230><c> from</c><00:00:37.469><c> the</c><00:00:37.710><c> selected</c>

00:00:38.209 --> 00:00:38.219 align:start position:0%
all of the formatting from the selected
 

00:00:38.219 --> 00:00:41.030 align:start position:0%
all of the formatting from the selected
cell<00:00:38.660><c> then</c><00:00:39.660><c> we'll</c><00:00:39.870><c> click</c><00:00:40.140><c> and</c><00:00:40.320><c> drag</c><00:00:40.530><c> over</c><00:00:40.770><c> the</c>

00:00:41.030 --> 00:00:41.040 align:start position:0%
cell then we'll click and drag over the
 

00:00:41.040 --> 00:00:43.450 align:start position:0%
cell then we'll click and drag over the
other<00:00:41.219><c> dates</c>

00:00:43.450 --> 00:00:43.460 align:start position:0%
other dates
 

00:00:43.460 --> 00:00:45.430 align:start position:0%
other dates
and<00:00:43.550><c> now</c><00:00:44.030><c> all</c><00:00:44.329><c> of</c><00:00:44.360><c> them</c><00:00:44.690><c> are</c><00:00:44.899><c> perfectly</c>

00:00:45.430 --> 00:00:45.440 align:start position:0%
and now all of them are perfectly
 

00:00:45.440 --> 00:00:48.280 align:start position:0%
and now all of them are perfectly
consistent<00:00:46.239><c> now</c><00:00:47.239><c> you</c><00:00:47.300><c> can</c><00:00:47.480><c> also</c><00:00:47.629><c> double-click</c>

00:00:48.280 --> 00:00:48.290 align:start position:0%
consistent now you can also double-click
 

00:00:48.290 --> 00:00:50.470 align:start position:0%
consistent now you can also double-click
the<00:00:48.649><c> format</c><00:00:48.980><c> painter</c><00:00:49.309><c> which</c><00:00:49.730><c> will</c><00:00:49.940><c> lock</c><00:00:50.120><c> it</c><00:00:50.329><c> on</c>

00:00:50.470 --> 00:00:50.480 align:start position:0%
the format painter which will lock it on
 

00:00:50.480 --> 00:00:53.470 align:start position:0%
the format painter which will lock it on
until<00:00:51.140><c> you</c><00:00:51.260><c> turn</c><00:00:51.440><c> it</c><00:00:51.559><c> off</c><00:00:51.760><c> for</c><00:00:52.760><c> example</c><00:00:53.149><c> if</c><00:00:53.329><c> we</c>

00:00:53.470 --> 00:00:53.480 align:start position:0%
until you turn it off for example if we
 

00:00:53.480 --> 00:00:56.080 align:start position:0%
until you turn it off for example if we
click<00:00:53.720><c> this</c><00:00:53.930><c> pink</c><00:00:54.290><c> cell</c><00:00:54.559><c> then</c><00:00:55.370><c> double</c><00:00:55.940><c> click</c>

00:00:56.080 --> 00:00:56.090 align:start position:0%
click this pink cell then double click
 

00:00:56.090 --> 00:00:58.509 align:start position:0%
click this pink cell then double click
the<00:00:56.300><c> format</c><00:00:56.629><c> painter</c><00:00:56.920><c> we</c><00:00:57.920><c> can</c><00:00:58.070><c> click</c><00:00:58.280><c> on</c><00:00:58.399><c> as</c>

00:00:58.509 --> 00:00:58.519 align:start position:0%
the format painter we can click on as
 

00:00:58.519 --> 00:01:01.090 align:start position:0%
the format painter we can click on as
many<00:00:58.760><c> cells</c><00:00:59.120><c> as</c><00:00:59.360><c> we</c><00:00:59.570><c> want</c><00:00:59.839><c> and</c><00:01:00.079><c> the</c><00:01:00.769><c> format</c>

00:01:01.090 --> 00:01:01.100 align:start position:0%
many cells as we want and the format
 

00:01:01.100 --> 00:01:03.790 align:start position:0%
many cells as we want and the format
painter<00:01:01.400><c> will</c><00:01:01.550><c> stay</c><00:01:01.790><c> on</c><00:01:02.140><c> this</c><00:01:03.140><c> is</c><00:01:03.290><c> an</c><00:01:03.409><c> easy</c><00:01:03.589><c> way</c>

00:01:03.790 --> 00:01:03.800 align:start position:0%
painter will stay on this is an easy way
 

00:01:03.800 --> 00:01:05.859 align:start position:0%
painter will stay on this is an easy way
to<00:01:03.829><c> highlight</c><00:01:04.280><c> several</c><00:01:04.550><c> non</c><00:01:04.909><c> adjacent</c><00:01:05.239><c> cells</c>

00:01:05.859 --> 00:01:05.869 align:start position:0%
to highlight several non adjacent cells
 

00:01:05.869 --> 00:01:07.570 align:start position:0%
to highlight several non adjacent cells
we're<00:01:06.290><c> clicking</c><00:01:06.560><c> and</c><00:01:06.800><c> dragging</c><00:01:06.830><c> isn't</c><00:01:07.490><c> an</c>

00:01:07.570 --> 00:01:07.580 align:start position:0%
we're clicking and dragging isn't an
 

00:01:07.580 --> 00:01:10.270 align:start position:0%
we're clicking and dragging isn't an
option<00:01:08.290><c> when</c><00:01:09.290><c> you</c><00:01:09.380><c> use</c><00:01:09.560><c> the</c><00:01:09.770><c> double</c><00:01:10.040><c> clicking</c>

00:01:10.270 --> 00:01:10.280 align:start position:0%
option when you use the double clicking
 

00:01:10.280 --> 00:01:11.920 align:start position:0%
option when you use the double clicking
method<00:01:10.759><c> you'll</c><00:01:10.970><c> need</c><00:01:11.149><c> to</c><00:01:11.240><c> make</c><00:01:11.330><c> sure</c><00:01:11.390><c> to</c><00:01:11.630><c> click</c>

00:01:11.920 --> 00:01:11.930 align:start position:0%
method you'll need to make sure to click
 

00:01:11.930 --> 00:01:13.330 align:start position:0%
method you'll need to make sure to click
the<00:01:12.080><c> format</c><00:01:12.409><c> painter</c><00:01:12.440><c> again</c><00:01:12.830><c> when</c><00:01:13.220><c> you're</c>

00:01:13.330 --> 00:01:13.340 align:start position:0%
the format painter again when you're
 

00:01:13.340 --> 00:01:15.940 align:start position:0%
the format painter again when you're
done<00:01:13.520><c> to</c><00:01:13.790><c> turn</c><00:01:13.940><c> it</c><00:01:14.060><c> off</c><00:01:14.560><c> so</c><00:01:15.560><c> there</c><00:01:15.710><c> are</c><00:01:15.800><c> really</c>

00:01:15.940 --> 00:01:15.950 align:start position:0%
done to turn it off so there are really
 

00:01:15.950 --> 00:01:17.950 align:start position:0%
done to turn it off so there are really
two<00:01:16.340><c> ways</c><00:01:16.369><c> to</c><00:01:16.880><c> use</c><00:01:17.090><c> the</c><00:01:17.300><c> format</c><00:01:17.600><c> painter</c>

00:01:17.950 --> 00:01:17.960 align:start position:0%
two ways to use the format painter
 

00:01:17.960 --> 00:01:20.590 align:start position:0%
two ways to use the format painter
single<00:01:18.679><c> clicking</c><00:01:18.920><c> and</c><00:01:19.220><c> double</c><00:01:20.090><c> clicking</c><00:01:20.360><c> and</c>

00:01:20.590 --> 00:01:20.600 align:start position:0%
single clicking and double clicking and
 

00:01:20.600 --> 00:01:22.779 align:start position:0%
single clicking and double clicking and
you<00:01:20.690><c> can</c><00:01:21.530><c> just</c><00:01:21.710><c> use</c><00:01:21.860><c> whichever</c><00:01:22.070><c> one</c><00:01:22.310><c> is</c><00:01:22.580><c> more</c>

00:01:22.779 --> 00:01:22.789 align:start position:0%
you can just use whichever one is more
 

00:01:22.789 --> 00:01:27.980 align:start position:0%
you can just use whichever one is more
convenient<00:01:23.210><c> depending</c><00:01:23.869><c> on</c><00:01:23.990><c> the</c><00:01:24.110><c> situation</c>

00:01:27.980 --> 00:01:27.990 align:start position:0%
 
 

00:01:27.990 --> 00:01:30.380 align:start position:0%
 
Goodwill<00:01:28.770><c> Community</c><00:01:29.250><c> Foundation</c><00:01:29.909><c> creating</c>

00:01:30.380 --> 00:01:30.390 align:start position:0%
Goodwill Community Foundation creating
 

00:01:30.390 --> 00:01:33.619 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:01:30.960><c> for</c><00:01:31.170><c> a</c><00:01:31.229><c> better</c><00:01:31.259><c> life</c>