WEBVTT
Kind: captions
Language: en

00:00:00.410 --> 00:00:02.990 align:start position:0%
 
Goodwill<00:00:01.410><c> Community</c><00:00:01.890><c> Foundation</c><00:00:02.520><c> creating</c>

00:00:02.990 --> 00:00:03.000 align:start position:0%
Goodwill Community Foundation creating
 

00:00:03.000 --> 00:00:10.540 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:00:03.600><c> for</c><00:00:03.810><c> a</c><00:00:03.870><c> better</c><00:00:04.020><c> life</c>

00:00:10.540 --> 00:00:10.550 align:start position:0%
 
 

00:00:10.550 --> 00:00:13.270 align:start position:0%
 
in<00:00:10.780><c> Excel</c><00:00:11.780><c> every</c><00:00:12.290><c> workbook</c><00:00:12.680><c> is</c><00:00:12.830><c> different</c>

00:00:13.270 --> 00:00:13.280 align:start position:0%
in Excel every workbook is different
 

00:00:13.280 --> 00:00:15.440 align:start position:0%
in Excel every workbook is different
that<00:00:14.000><c> means</c><00:00:14.270><c> you</c><00:00:14.390><c> may</c><00:00:14.510><c> want</c><00:00:14.720><c> to</c>

00:00:15.440 --> 00:00:15.450 align:start position:0%
that means you may want to
 

00:00:15.450 --> 00:00:17.029 align:start position:0%
that means you may want to
certain<00:00:15.599><c> things</c><00:00:15.750><c> like</c><00:00:16.260><c> the</c><00:00:16.410><c> size</c><00:00:16.619><c> and</c><00:00:16.920><c> layout</c>

00:00:17.029 --> 00:00:17.039 align:start position:0%
certain things like the size and layout
 

00:00:17.039 --> 00:00:18.859 align:start position:0%
certain things like the size and layout
of<00:00:17.369><c> your</c><00:00:17.400><c> cells</c><00:00:17.789><c> to</c><00:00:18.240><c> better</c><00:00:18.420><c> fit</c><00:00:18.630><c> the</c><00:00:18.750><c> data</c>

00:00:18.859 --> 00:00:18.869 align:start position:0%
of your cells to better fit the data
 

00:00:18.869 --> 00:00:21.740 align:start position:0%
of your cells to better fit the data
you're<00:00:19.140><c> working</c><00:00:19.170><c> with</c><00:00:20.090><c> this</c><00:00:21.090><c> column</c><00:00:21.450><c> has</c><00:00:21.600><c> been</c>

00:00:21.740 --> 00:00:21.750 align:start position:0%
you're working with this column has been
 

00:00:21.750 --> 00:00:23.870 align:start position:0%
you're working with this column has been
resized<00:00:22.140><c> for</c><00:00:22.349><c> example</c><00:00:22.920><c> but</c><00:00:23.250><c> not</c><00:00:23.430><c> quite</c><00:00:23.759><c> enough</c>

00:00:23.870 --> 00:00:23.880 align:start position:0%
resized for example but not quite enough
 

00:00:23.880 --> 00:00:26.150 align:start position:0%
resized for example but not quite enough
most<00:00:24.750><c> of</c><00:00:24.930><c> the</c><00:00:25.050><c> text</c><00:00:25.349><c> is</c><00:00:25.470><c> still</c><00:00:25.590><c> getting</c><00:00:25.890><c> cut</c>

00:00:26.150 --> 00:00:26.160 align:start position:0%
most of the text is still getting cut
 

00:00:26.160 --> 00:00:28.429 align:start position:0%
most of the text is still getting cut
off<00:00:26.340><c> I'm</c><00:00:26.640><c> going</c><00:00:27.509><c> to</c><00:00:27.570><c> increase</c><00:00:27.869><c> the</c><00:00:27.990><c> width</c><00:00:28.290><c> a</c>

00:00:28.429 --> 00:00:28.439 align:start position:0%
off I'm going to increase the width a
 

00:00:28.439 --> 00:00:30.409 align:start position:0%
off I'm going to increase the width a
little<00:00:28.470><c> more</c><00:00:28.890><c> by</c><00:00:29.160><c> positioning</c><00:00:29.669><c> my</c><00:00:29.849><c> mouse</c><00:00:30.029><c> over</c>

00:00:30.409 --> 00:00:30.419 align:start position:0%
little more by positioning my mouse over
 

00:00:30.419 --> 00:00:31.970 align:start position:0%
little more by positioning my mouse over
the<00:00:30.539><c> line</c><00:00:30.720><c> in</c><00:00:30.930><c> the</c><00:00:31.020><c> column</c><00:00:31.050><c> heading</c><00:00:31.649><c> then</c>

00:00:31.970 --> 00:00:31.980 align:start position:0%
the line in the column heading then
 

00:00:31.980 --> 00:00:34.720 align:start position:0%
the line in the column heading then
clicking<00:00:32.369><c> and</c><00:00:32.669><c> dragging</c><00:00:32.700><c> it</c><00:00:33.180><c> to</c><00:00:33.210><c> the</c><00:00:33.390><c> right</c>

00:00:34.720 --> 00:00:34.730 align:start position:0%
clicking and dragging it to the right
 

00:00:34.730 --> 00:00:37.280 align:start position:0%
clicking and dragging it to the right
another<00:00:35.730><c> option</c><00:00:36.210><c> is</c><00:00:36.390><c> to</c><00:00:36.420><c> auto</c><00:00:36.720><c> size</c><00:00:37.050><c> the</c>

00:00:37.280 --> 00:00:37.290 align:start position:0%
another option is to auto size the
 

00:00:37.290 --> 00:00:39.620 align:start position:0%
another option is to auto size the
column<00:00:37.649><c> this</c><00:00:38.399><c> will</c><00:00:38.670><c> automatically</c><00:00:39.360><c> adjust</c>

00:00:39.620 --> 00:00:39.630 align:start position:0%
column this will automatically adjust
 

00:00:39.630 --> 00:00:41.510 align:start position:0%
column this will automatically adjust
the<00:00:39.750><c> width</c><00:00:40.020><c> so</c><00:00:40.200><c> it</c><00:00:40.500><c> fits</c><00:00:40.680><c> the</c><00:00:40.890><c> contents</c><00:00:41.040><c> of</c><00:00:41.399><c> the</c>

00:00:41.510 --> 00:00:41.520 align:start position:0%
the width so it fits the contents of the
 

00:00:41.520 --> 00:00:44.180 align:start position:0%
the width so it fits the contents of the
cells<00:00:41.760><c> exactly</c><00:00:42.380><c> just</c><00:00:43.380><c> double</c><00:00:43.710><c> click</c><00:00:43.920><c> the</c><00:00:44.040><c> line</c>

00:00:44.180 --> 00:00:44.190 align:start position:0%
cells exactly just double click the line
 

00:00:44.190 --> 00:00:47.119 align:start position:0%
cells exactly just double click the line
instead<00:00:44.579><c> of</c><00:00:44.730><c> dragging</c><00:00:45.000><c> it</c><00:00:45.469><c> now</c><00:00:46.469><c> the</c><00:00:46.530><c> column</c><00:00:46.980><c> is</c>

00:00:47.119 --> 00:00:47.129 align:start position:0%
instead of dragging it now the column is
 

00:00:47.129 --> 00:00:50.450 align:start position:0%
instead of dragging it now the column is
perfectly<00:00:47.340><c> sized</c><00:00:47.880><c> to</c><00:00:48.060><c> the</c><00:00:48.150><c> text</c><00:00:49.190><c> rows</c><00:00:50.190><c> work</c>

00:00:50.450 --> 00:00:50.460 align:start position:0%
perfectly sized to the text rows work
 

00:00:50.460 --> 00:00:52.880 align:start position:0%
perfectly sized to the text rows work
the<00:00:50.640><c> same</c><00:00:50.850><c> way</c><00:00:51.090><c> you</c><00:00:51.780><c> can</c><00:00:51.930><c> adjust</c><00:00:52.260><c> the</c><00:00:52.410><c> manually</c>

00:00:52.880 --> 00:00:52.890 align:start position:0%
the same way you can adjust the manually
 

00:00:52.890 --> 00:00:54.980 align:start position:0%
the same way you can adjust the manually
or<00:00:53.070><c> auto</c><00:00:53.640><c> size</c><00:00:54.000><c> them</c><00:00:54.270><c> to</c><00:00:54.450><c> fit</c><00:00:54.600><c> the</c><00:00:54.720><c> height</c><00:00:54.870><c> of</c>

00:00:54.980 --> 00:00:54.990 align:start position:0%
or auto size them to fit the height of
 

00:00:54.990 --> 00:00:58.580 align:start position:0%
or auto size them to fit the height of
your<00:00:55.140><c> text</c><00:00:56.780><c> sometimes</c><00:00:57.780><c> it's</c><00:00:57.990><c> useful</c><00:00:58.170><c> to</c><00:00:58.410><c> be</c>

00:00:58.580 --> 00:00:58.590 align:start position:0%
your text sometimes it's useful to be
 

00:00:58.590 --> 00:01:00.380 align:start position:0%
your text sometimes it's useful to be
able<00:00:58.860><c> to</c><00:00:58.920><c> resize</c><00:00:59.280><c> all</c><00:00:59.640><c> of</c><00:00:59.820><c> your</c><00:00:59.940><c> cells</c><00:01:00.180><c> at</c><00:01:00.360><c> once</c>

00:01:00.380 --> 00:01:00.390 align:start position:0%
able to resize all of your cells at once
 

00:01:00.390 --> 00:01:03.290 align:start position:0%
able to resize all of your cells at once
in<00:01:00.900><c> this</c><00:01:01.680><c> example</c><00:01:02.070><c> I'd</c><00:01:02.489><c> like</c><00:01:02.760><c> to</c><00:01:02.880><c> make</c><00:01:03.030><c> all</c><00:01:03.239><c> of</c>

00:01:03.290 --> 00:01:03.300 align:start position:0%
in this example I'd like to make all of
 

00:01:03.300 --> 00:01:06.350 align:start position:0%
in this example I'd like to make all of
my<00:01:03.480><c> rows</c><00:01:03.810><c> the</c><00:01:04.049><c> exact</c><00:01:04.409><c> same</c><00:01:04.650><c> height</c><00:01:05.000><c> to</c><00:01:06.000><c> do</c><00:01:06.150><c> this</c>

00:01:06.350 --> 00:01:06.360 align:start position:0%
my rows the exact same height to do this
 

00:01:06.360 --> 00:01:08.539 align:start position:0%
my rows the exact same height to do this
click<00:01:06.899><c> the</c><00:01:07.079><c> Select</c><00:01:07.470><c> All</c><00:01:07.560><c> button</c><00:01:07.740><c> in</c><00:01:08.250><c> the</c><00:01:08.369><c> top</c>

00:01:08.539 --> 00:01:08.549 align:start position:0%
click the Select All button in the top
 

00:01:08.549 --> 00:01:11.780 align:start position:0%
click the Select All button in the top
left<00:01:08.579><c> corner</c><00:01:09.200><c> then</c><00:01:10.200><c> resize</c><00:01:10.740><c> a</c><00:01:10.770><c> row</c><00:01:10.979><c> it</c><00:01:11.399><c> doesn't</c>

00:01:11.780 --> 00:01:11.790 align:start position:0%
left corner then resize a row it doesn't
 

00:01:11.790 --> 00:01:15.319 align:start position:0%
left corner then resize a row it doesn't
matter<00:01:11.939><c> which</c><00:01:12.149><c> one</c><00:01:12.390><c> and</c><00:01:13.729><c> the</c><00:01:14.729><c> change</c><00:01:15.030><c> will</c><00:01:15.210><c> be</c>

00:01:15.319 --> 00:01:15.329 align:start position:0%
matter which one and the change will be
 

00:01:15.329 --> 00:01:18.679 align:start position:0%
matter which one and the change will be
applied<00:01:15.659><c> to</c><00:01:15.840><c> the</c><00:01:15.930><c> entire</c><00:01:15.960><c> worksheet</c><00:01:17.570><c> next</c><00:01:18.570><c> I</c>

00:01:18.679 --> 00:01:18.689 align:start position:0%
applied to the entire worksheet next I
 

00:01:18.689 --> 00:01:21.050 align:start position:0%
applied to the entire worksheet next I
need<00:01:18.750><c> to</c><00:01:18.899><c> add</c><00:01:19.020><c> another</c><00:01:19.409><c> row</c><00:01:19.679><c> to</c><00:01:19.740><c> this</c><00:01:19.979><c> list</c><00:01:20.310><c> I'd</c>

00:01:21.050 --> 00:01:21.060 align:start position:0%
need to add another row to this list I'd
 

00:01:21.060 --> 00:01:23.389 align:start position:0%
need to add another row to this list I'd
like<00:01:21.240><c> to</c><00:01:21.389><c> put</c><00:01:21.569><c> it</c><00:01:21.659><c> in</c><00:01:21.780><c> between</c><00:01:21.929><c> row</c><00:01:22.319><c> 4</c><00:01:22.649><c> and</c><00:01:22.920><c> row</c>

00:01:23.389 --> 00:01:23.399 align:start position:0%
like to put it in between row 4 and row
 

00:01:23.399 --> 00:01:26.899 align:start position:0%
like to put it in between row 4 and row
5<00:01:24.020><c> to</c><00:01:25.020><c> add</c><00:01:25.170><c> a</c><00:01:25.200><c> new</c><00:01:25.499><c> row</c><00:01:25.710><c> all</c><00:01:25.979><c> you</c><00:01:26.310><c> have</c><00:01:26.490><c> to</c><00:01:26.609><c> do</c><00:01:26.759><c> is</c>

00:01:26.899 --> 00:01:26.909 align:start position:0%
5 to add a new row all you have to do is
 

00:01:26.909 --> 00:01:28.669 align:start position:0%
5 to add a new row all you have to do is
select<00:01:27.090><c> the</c><00:01:27.420><c> row</c><00:01:27.600><c> heading</c><00:01:27.960><c> below</c><00:01:28.319><c> where</c><00:01:28.560><c> you</c>

00:01:28.669 --> 00:01:28.679 align:start position:0%
select the row heading below where you
 

00:01:28.679 --> 00:01:32.599 align:start position:0%
select the row heading below where you
want<00:01:28.920><c> the</c><00:01:29.039><c> new</c><00:01:29.189><c> one</c><00:01:29.219><c> to</c><00:01:29.549><c> appear</c><00:01:31.219><c> then</c><00:01:32.219><c> click</c>

00:01:32.599 --> 00:01:32.609 align:start position:0%
want the new one to appear then click
 

00:01:32.609 --> 00:01:39.919 align:start position:0%
want the new one to appear then click
the<00:01:32.759><c> insert</c><00:01:33.119><c> command</c><00:01:38.270><c> the</c><00:01:39.270><c> process</c><00:01:39.749><c> is</c>

00:01:39.919 --> 00:01:39.929 align:start position:0%
the insert command the process is
 

00:01:39.929 --> 00:01:40.719 align:start position:0%
the insert command the process is
similar

00:01:40.719 --> 00:01:40.729 align:start position:0%
similar
 

00:01:40.729 --> 00:01:43.450 align:start position:0%
similar
a<00:01:40.820><c> new</c><00:01:41.119><c> column</c><00:01:41.539><c> just</c><00:01:41.920><c> select</c><00:01:42.920><c> the</c><00:01:43.100><c> column</c>

00:01:43.450 --> 00:01:43.460 align:start position:0%
a new column just select the column
 

00:01:43.460 --> 00:01:44.920 align:start position:0%
a new column just select the column
heading<00:01:43.729><c> to</c><00:01:43.880><c> the</c><00:01:43.969><c> right</c><00:01:44.180><c> of</c><00:01:44.450><c> where</c><00:01:44.630><c> you</c><00:01:44.750><c> want</c>

00:01:44.920 --> 00:01:44.930 align:start position:0%
heading to the right of where you want
 

00:01:44.930 --> 00:01:47.980 align:start position:0%
heading to the right of where you want
the<00:01:45.079><c> new</c><00:01:45.110><c> one</c><00:01:45.380><c> to</c><00:01:45.560><c> go</c><00:01:46.450><c> click</c><00:01:47.450><c> the</c><00:01:47.479><c> insert</c>

00:01:47.980 --> 00:01:47.990 align:start position:0%
the new one to go click the insert
 

00:01:47.990 --> 00:01:50.469 align:start position:0%
the new one to go click the insert
command<00:01:48.140><c> and</c><00:01:48.590><c> a</c><00:01:49.490><c> column</c><00:01:49.820><c> will</c><00:01:49.939><c> appear</c><00:01:49.969><c> to</c><00:01:50.390><c> the</c>

00:01:50.469 --> 00:01:50.479 align:start position:0%
command and a column will appear to the
 

00:01:50.479 --> 00:01:55.120 align:start position:0%
command and a column will appear to the
left<00:01:52.990><c> deleting</c><00:01:53.990><c> columns</c><00:01:54.170><c> and</c><00:01:54.439><c> rows</c><00:01:54.590><c> is</c><00:01:54.829><c> just</c>

00:01:55.120 --> 00:01:55.130 align:start position:0%
left deleting columns and rows is just
 

00:01:55.130 --> 00:01:58.120 align:start position:0%
left deleting columns and rows is just
as<00:01:55.280><c> easy</c><00:01:55.780><c> first</c><00:01:56.780><c> select</c><00:01:57.380><c> the</c><00:01:57.530><c> column</c><00:01:57.740><c> or</c><00:01:58.009><c> row</c>

00:01:58.120 --> 00:01:58.130 align:start position:0%
as easy first select the column or row
 

00:01:58.130 --> 00:02:01.719 align:start position:0%
as easy first select the column or row
you<00:01:58.189><c> want</c><00:01:58.429><c> to</c><00:01:58.549><c> delete</c><00:02:00.159><c> then</c><00:02:01.159><c> click</c><00:02:01.460><c> the</c><00:02:01.610><c> delete</c>

00:02:01.719 --> 00:02:01.729 align:start position:0%
you want to delete then click the delete
 

00:02:01.729 --> 00:02:04.660 align:start position:0%
you want to delete then click the delete
command<00:02:02.710><c> the</c><00:02:03.710><c> column</c><00:02:04.069><c> or</c><00:02:04.189><c> row</c><00:02:04.369><c> will</c><00:02:04.549><c> be</c>

00:02:04.660 --> 00:02:04.670 align:start position:0%
command the column or row will be
 

00:02:04.670 --> 00:02:06.730 align:start position:0%
command the column or row will be
deleted<00:02:05.090><c> causing</c><00:02:05.630><c> the</c><00:02:05.750><c> other</c><00:02:05.899><c> cells</c><00:02:06.289><c> to</c><00:02:06.439><c> move</c>

00:02:06.730 --> 00:02:06.740 align:start position:0%
deleted causing the other cells to move
 

00:02:06.740 --> 00:02:09.550 align:start position:0%
deleted causing the other cells to move
and<00:02:07.100><c> fill</c><00:02:07.250><c> in</c><00:02:07.399><c> the</c><00:02:07.520><c> gap</c><00:02:07.670><c> automatically</c><00:02:08.560><c> just</c>

00:02:09.550 --> 00:02:09.560 align:start position:0%
and fill in the gap automatically just
 

00:02:09.560 --> 00:02:10.779 align:start position:0%
and fill in the gap automatically just
remember<00:02:09.950><c> that</c><00:02:10.129><c> there's</c><00:02:10.310><c> a</c><00:02:10.369><c> difference</c>

00:02:10.779 --> 00:02:10.789 align:start position:0%
remember that there's a difference
 

00:02:10.789 --> 00:02:13.270 align:start position:0%
remember that there's a difference
between<00:02:10.970><c> clearing</c><00:02:11.629><c> and</c><00:02:11.810><c> deleting</c><00:02:12.280><c> deleting</c>

00:02:13.270 --> 00:02:13.280 align:start position:0%
between clearing and deleting deleting
 

00:02:13.280 --> 00:02:14.949 align:start position:0%
between clearing and deleting deleting
cells<00:02:13.549><c> removes</c><00:02:14.060><c> them</c><00:02:14.239><c> from</c><00:02:14.420><c> your</c><00:02:14.540><c> worksheet</c>

00:02:14.949 --> 00:02:14.959 align:start position:0%
cells removes them from your worksheet
 

00:02:14.959 --> 00:02:17.640 align:start position:0%
cells removes them from your worksheet
clearing<00:02:15.799><c> just</c><00:02:16.010><c> removes</c><00:02:16.400><c> the</c><00:02:16.580><c> contents</c><00:02:17.120><c> you</c>

00:02:17.640 --> 00:02:17.650 align:start position:0%
clearing just removes the contents you
 

00:02:17.650 --> 00:02:20.350 align:start position:0%
clearing just removes the contents you
can<00:02:18.650><c> also</c><00:02:18.950><c> move</c><00:02:19.340><c> a</c><00:02:19.459><c> column</c><00:02:19.670><c> or</c><00:02:19.970><c> row</c><00:02:20.090><c> to</c><00:02:20.150><c> a</c>

00:02:20.350 --> 00:02:20.360 align:start position:0%
can also move a column or row to a
 

00:02:20.360 --> 00:02:21.280 align:start position:0%
can also move a column or row to a
different<00:02:20.750><c> location</c>

00:02:21.280 --> 00:02:21.290 align:start position:0%
different location
 

00:02:21.290 --> 00:02:24.210 align:start position:0%
different location
in<00:02:21.440><c> this</c><00:02:22.220><c> example</c><00:02:22.640><c> we'll</c><00:02:23.060><c> move</c><00:02:23.299><c> a</c><00:02:23.390><c> column</c><00:02:23.630><c> all</c>

00:02:24.210 --> 00:02:24.220 align:start position:0%
in this example we'll move a column all
 

00:02:24.220 --> 00:02:26.440 align:start position:0%
in this example we'll move a column all
you<00:02:25.220><c> have</c><00:02:25.370><c> to</c><00:02:25.489><c> do</c><00:02:25.610><c> is</c><00:02:25.760><c> select</c><00:02:25.910><c> the</c><00:02:26.239><c> one</c><00:02:26.269><c> you</c>

00:02:26.440 --> 00:02:26.450 align:start position:0%
you have to do is select the one you
 

00:02:26.450 --> 00:02:30.400 align:start position:0%
you have to do is select the one you
want<00:02:26.540><c> then</c><00:02:27.170><c> click</c><00:02:27.470><c> the</c><00:02:27.650><c> cut</c><00:02:27.829><c> command</c><00:02:29.410><c> next</c>

00:02:30.400 --> 00:02:30.410 align:start position:0%
want then click the cut command next
 

00:02:30.410 --> 00:02:32.319 align:start position:0%
want then click the cut command next
select<00:02:30.920><c> the</c><00:02:31.010><c> column</c><00:02:31.430><c> to</c><00:02:31.579><c> the</c><00:02:31.610><c> right</c><00:02:31.700><c> of</c><00:02:32.150><c> where</c>

00:02:32.319 --> 00:02:32.329 align:start position:0%
select the column to the right of where
 

00:02:32.329 --> 00:02:35.110 align:start position:0%
select the column to the right of where
you<00:02:32.450><c> want</c><00:02:32.660><c> the</c><00:02:32.780><c> column</c><00:02:33.110><c> to</c><00:02:33.230><c> be</c><00:02:33.260><c> moved</c><00:02:34.120><c> click</c>

00:02:35.110 --> 00:02:35.120 align:start position:0%
you want the column to be moved click
 

00:02:35.120 --> 00:02:36.910 align:start position:0%
you want the column to be moved click
the<00:02:35.269><c> insert</c><00:02:35.690><c> drop-down</c><00:02:36.170><c> menu</c><00:02:36.500><c> on</c><00:02:36.530><c> the</c><00:02:36.739><c> ribbon</c>

00:02:36.910 --> 00:02:36.920 align:start position:0%
the insert drop-down menu on the ribbon
 

00:02:36.920 --> 00:02:42.640 align:start position:0%
the insert drop-down menu on the ribbon
then<00:02:37.750><c> choose</c><00:02:38.750><c> insert</c><00:02:39.349><c> cut</c><00:02:39.680><c> cells</c><00:02:41.650><c> another</c>

00:02:42.640 --> 00:02:42.650 align:start position:0%
then choose insert cut cells another
 

00:02:42.650 --> 00:02:44.710 align:start position:0%
then choose insert cut cells another
useful<00:02:42.920><c> technique</c><00:02:43.250><c> for</c><00:02:43.640><c> rearranging</c><00:02:43.910><c> data</c><00:02:44.450><c> is</c>

00:02:44.710 --> 00:02:44.720 align:start position:0%
useful technique for rearranging data is
 

00:02:44.720 --> 00:02:46.780 align:start position:0%
useful technique for rearranging data is
the<00:02:44.989><c> ability</c><00:02:45.230><c> to</c><00:02:45.440><c> hide</c><00:02:45.829><c> certain</c><00:02:46.130><c> columns</c><00:02:46.639><c> or</c>

00:02:46.780 --> 00:02:46.790 align:start position:0%
the ability to hide certain columns or
 

00:02:46.790 --> 00:02:49.449 align:start position:0%
the ability to hide certain columns or
rows<00:02:47.049><c> for</c><00:02:48.049><c> example</c><00:02:48.470><c> I</c><00:02:48.620><c> don't</c><00:02:48.920><c> really</c><00:02:49.130><c> need</c><00:02:49.340><c> to</c>

00:02:49.449 --> 00:02:49.459 align:start position:0%
rows for example I don't really need to
 

00:02:49.459 --> 00:02:51.430 align:start position:0%
rows for example I don't really need to
see<00:02:49.609><c> these</c><00:02:49.850><c> 3</c><00:02:50.120><c> columns</c><00:02:50.480><c> right</c><00:02:50.660><c> now</c><00:02:50.840><c> I'd</c><00:02:51.139><c> rather</c>

00:02:51.430 --> 00:02:51.440 align:start position:0%
see these 3 columns right now I'd rather
 

00:02:51.440 --> 00:02:53.470 align:start position:0%
see these 3 columns right now I'd rather
focus<00:02:51.709><c> on</c><00:02:51.980><c> the</c><00:02:52.100><c> customers</c><00:02:52.609><c> email</c><00:02:52.970><c> addresses</c>

00:02:53.470 --> 00:02:53.480 align:start position:0%
focus on the customers email addresses
 

00:02:53.480 --> 00:02:57.460 align:start position:0%
focus on the customers email addresses
if<00:02:53.769><c> we</c><00:02:54.769><c> right</c><00:02:54.980><c> click</c><00:02:55.569><c> then</c><00:02:56.569><c> choose</c><00:02:56.600><c> hide</c><00:02:57.200><c> from</c>

00:02:57.460 --> 00:02:57.470 align:start position:0%
if we right click then choose hide from
 

00:02:57.470 --> 00:02:59.890 align:start position:0%
if we right click then choose hide from
the<00:02:57.620><c> menu</c><00:02:58.000><c> the</c><00:02:59.000><c> columns</c><00:02:59.389><c> temporarily</c>

00:02:59.890 --> 00:02:59.900 align:start position:0%
the menu the columns temporarily
 

00:02:59.900 --> 00:03:03.309 align:start position:0%
the menu the columns temporarily
disappear<00:03:00.970><c> to</c><00:03:01.970><c> unhide</c><00:03:02.329><c> them</c><00:03:02.569><c> select</c><00:03:03.170><c> the</c>

00:03:03.309 --> 00:03:03.319 align:start position:0%
disappear to unhide them select the
 

00:03:03.319 --> 00:03:05.080 align:start position:0%
disappear to unhide them select the
columns<00:03:03.680><c> on</c><00:03:03.829><c> either</c><00:03:04.040><c> side</c><00:03:04.430><c> of</c><00:03:04.459><c> the</c><00:03:04.670><c> ones</c><00:03:04.850><c> that</c>

00:03:05.080 --> 00:03:05.090 align:start position:0%
columns on either side of the ones that
 

00:03:05.090 --> 00:03:05.470 align:start position:0%
columns on either side of the ones that
are<00:03:05.180><c> hidden</c>

00:03:05.470 --> 00:03:05.480 align:start position:0%
are hidden
 

00:03:05.480 --> 00:03:10.590 align:start position:0%
are hidden
then<00:03:05.989><c> right-click</c><00:03:06.470><c> again</c><00:03:06.590><c> and</c><00:03:07.420><c> choose</c><00:03:08.420><c> unhide</c>

00:03:10.590 --> 00:03:10.600 align:start position:0%
then right-click again and choose unhide
 

00:03:10.600 --> 00:03:12.300 align:start position:0%
then right-click again and choose unhide
let's<00:03:11.600><c> fast</c><00:03:11.840><c> forward</c>

00:03:12.300 --> 00:03:12.310 align:start position:0%
let's fast forward
 

00:03:12.310 --> 00:03:15.630 align:start position:0%
let's fast forward
to<00:03:12.400><c> the</c><00:03:12.520><c> finished</c><00:03:12.849><c> worksheet</c><00:03:14.489><c> next</c><00:03:15.489><c> I'd</c><00:03:15.610><c> like</c>

00:03:15.630 --> 00:03:15.640 align:start position:0%
to the finished worksheet next I'd like
 

00:03:15.640 --> 00:03:17.850 align:start position:0%
to the finished worksheet next I'd like
to<00:03:15.790><c> take</c><00:03:16.090><c> a</c><00:03:16.120><c> look</c><00:03:16.300><c> at</c><00:03:16.450><c> wrapping</c><00:03:16.840><c> text</c><00:03:17.110><c> which</c><00:03:17.709><c> is</c>

00:03:17.850 --> 00:03:17.860 align:start position:0%
to take a look at wrapping text which is
 

00:03:17.860 --> 00:03:19.559 align:start position:0%
to take a look at wrapping text which is
one<00:03:18.069><c> way</c><00:03:18.220><c> of</c><00:03:18.370><c> addressing</c><00:03:18.580><c> cells</c><00:03:19.030><c> that</c><00:03:19.239><c> contain</c>

00:03:19.559 --> 00:03:19.569 align:start position:0%
one way of addressing cells that contain
 

00:03:19.569 --> 00:03:21.890 align:start position:0%
one way of addressing cells that contain
more<00:03:19.810><c> text</c><00:03:20.290><c> than</c><00:03:20.410><c> they</c><00:03:20.620><c> can</c><00:03:20.680><c> actually</c><00:03:20.950><c> display</c>

00:03:21.890 --> 00:03:21.900 align:start position:0%
more text than they can actually display
 

00:03:21.900 --> 00:03:24.839 align:start position:0%
more text than they can actually display
for<00:03:22.900><c> example</c><00:03:23.319><c> I'd</c><00:03:23.500><c> like</c><00:03:23.560><c> to</c><00:03:23.770><c> resize</c><00:03:23.920><c> my</c><00:03:24.489><c> column</c>

00:03:24.839 --> 00:03:24.849 align:start position:0%
for example I'd like to resize my column
 

00:03:24.849 --> 00:03:26.670 align:start position:0%
for example I'd like to resize my column
of<00:03:24.970><c> addresses</c><00:03:25.450><c> to</c><00:03:25.480><c> about</c><00:03:25.959><c> half</c><00:03:26.290><c> its</c><00:03:26.500><c> current</c>

00:03:26.670 --> 00:03:26.680 align:start position:0%
of addresses to about half its current
 

00:03:26.680 --> 00:03:28.500 align:start position:0%
of addresses to about half its current
size<00:03:27.069><c> but</c><00:03:27.489><c> still</c><00:03:27.790><c> be</c><00:03:27.970><c> able</c><00:03:28.060><c> to</c><00:03:28.239><c> see</c><00:03:28.390><c> the</c>

00:03:28.500 --> 00:03:28.510 align:start position:0%
size but still be able to see the
 

00:03:28.510 --> 00:03:31.470 align:start position:0%
size but still be able to see the
contents<00:03:29.340><c> we</c><00:03:30.340><c> can</c><00:03:30.489><c> do</c><00:03:30.640><c> this</c><00:03:30.819><c> using</c><00:03:31.030><c> the</c><00:03:31.209><c> wrap</c>

00:03:31.470 --> 00:03:31.480 align:start position:0%
contents we can do this using the wrap
 

00:03:31.480 --> 00:03:34.259 align:start position:0%
contents we can do this using the wrap
text<00:03:31.780><c> command</c><00:03:31.900><c> on</c><00:03:32.380><c> the</c><00:03:32.470><c> ribbon</c><00:03:32.500><c> as</c><00:03:33.090><c> you</c><00:03:34.090><c> can</c>

00:03:34.259 --> 00:03:34.269 align:start position:0%
text command on the ribbon as you can
 

00:03:34.269 --> 00:03:36.180 align:start position:0%
text command on the ribbon as you can
see<00:03:34.480><c> this</c><00:03:34.690><c> displays</c><00:03:35.110><c> the</c><00:03:35.319><c> text</c><00:03:35.620><c> on</c><00:03:35.739><c> multiple</c>

00:03:36.180 --> 00:03:36.190 align:start position:0%
see this displays the text on multiple
 

00:03:36.190 --> 00:03:39.479 align:start position:0%
see this displays the text on multiple
lines<00:03:37.200><c> now</c><00:03:38.200><c> for</c><00:03:38.470><c> the</c><00:03:38.560><c> finishing</c><00:03:39.010><c> touch</c>

00:03:39.479 --> 00:03:39.489 align:start position:0%
lines now for the finishing touch
 

00:03:39.489 --> 00:03:41.699 align:start position:0%
lines now for the finishing touch
combining<00:03:40.090><c> the</c><00:03:40.269><c> cells</c><00:03:40.510><c> in</c><00:03:40.750><c> the</c><00:03:40.870><c> top</c><00:03:41.080><c> row</c><00:03:41.380><c> so</c>

00:03:41.699 --> 00:03:41.709 align:start position:0%
combining the cells in the top row so
 

00:03:41.709 --> 00:03:43.050 align:start position:0%
combining the cells in the top row so
the<00:03:41.830><c> title</c><00:03:42.040><c> of</c><00:03:42.220><c> my</c><00:03:42.400><c> worksheet</c><00:03:42.790><c> can</c><00:03:42.970><c> be</c>

00:03:43.050 --> 00:03:43.060 align:start position:0%
the title of my worksheet can be
 

00:03:43.060 --> 00:03:45.870 align:start position:0%
the title of my worksheet can be
centered<00:03:43.450><c> in</c><00:03:43.599><c> a</c><00:03:43.720><c> single</c><00:03:44.110><c> large</c><00:03:44.350><c> cell</c><00:03:44.730><c> to</c><00:03:45.730><c> do</c>

00:03:45.870 --> 00:03:45.880 align:start position:0%
centered in a single large cell to do
 

00:03:45.880 --> 00:03:48.259 align:start position:0%
centered in a single large cell to do
this<00:03:46.060><c> select</c><00:03:46.510><c> the</c><00:03:46.870><c> cells</c><00:03:47.080><c> you</c><00:03:47.230><c> want</c><00:03:47.260><c> to</c><00:03:47.470><c> merge</c>

00:03:48.259 --> 00:03:48.269 align:start position:0%
this select the cells you want to merge
 

00:03:48.269 --> 00:03:51.530 align:start position:0%
this select the cells you want to merge
then<00:03:49.269><c> click</c><00:03:49.569><c> the</c><00:03:49.720><c> merge</c><00:03:49.989><c> &amp;</c><00:03:50.290><c> Center</c><00:03:50.590><c> command</c>

00:03:51.530 --> 00:03:51.540 align:start position:0%
then click the merge &amp; Center command
 

00:03:51.540 --> 00:03:55.380 align:start position:0%
then click the merge &amp; Center command
there<00:03:52.540><c> that's</c><00:03:52.930><c> perfect</c><00:03:53.790><c> to</c><00:03:54.790><c> access</c><00:03:55.180><c> more</c>

00:03:55.380 --> 00:03:55.390 align:start position:0%
there that's perfect to access more
 

00:03:55.390 --> 00:03:57.420 align:start position:0%
there that's perfect to access more
merge<00:03:55.630><c> options</c><00:03:56.110><c> open</c><00:03:56.410><c> the</c><00:03:56.739><c> drop</c><00:03:56.950><c> down</c><00:03:57.160><c> menu</c>

00:03:57.420 --> 00:03:57.430 align:start position:0%
merge options open the drop down menu
 

00:03:57.430 --> 00:04:00.509 align:start position:0%
merge options open the drop down menu
here<00:03:57.989><c> you</c><00:03:58.989><c> can</c><00:03:59.170><c> merge</c><00:03:59.290><c> across</c><00:03:59.620><c> creating</c>

00:04:00.509 --> 00:04:00.519 align:start position:0%
here you can merge across creating
 

00:04:00.519 --> 00:04:02.400 align:start position:0%
here you can merge across creating
merged<00:04:00.760><c> rows</c><00:04:01.150><c> instead</c><00:04:01.630><c> of</c><00:04:01.840><c> a</c><00:04:01.900><c> single</c><00:04:02.230><c> large</c>

00:04:02.400 --> 00:04:02.410 align:start position:0%
merged rows instead of a single large
 

00:04:02.410 --> 00:04:04.559 align:start position:0%
merged rows instead of a single large
cell<00:04:02.769><c> if</c><00:04:03.010><c> you</c><00:04:03.220><c> have</c><00:04:03.370><c> multiple</c><00:04:03.760><c> cells</c><00:04:04.030><c> selected</c>

00:04:04.559 --> 00:04:04.569 align:start position:0%
cell if you have multiple cells selected
 

00:04:04.569 --> 00:04:07.140 align:start position:0%
cell if you have multiple cells selected
you<00:04:05.410><c> can</c><00:04:05.560><c> also</c><00:04:05.709><c> merge</c><00:04:06.069><c> without</c><00:04:06.310><c> centering</c><00:04:06.970><c> or</c>

00:04:07.140 --> 00:04:07.150 align:start position:0%
you can also merge without centering or
 

00:04:07.150 --> 00:04:11.970 align:start position:0%
you can also merge without centering or
split<00:04:07.989><c> your</c><00:04:08.110><c> cells</c><00:04:08.349><c> up</c><00:04:08.500><c> again</c><00:04:10.560><c> the</c><00:04:11.560><c> best</c><00:04:11.769><c> way</c>

00:04:11.970 --> 00:04:11.980 align:start position:0%
split your cells up again the best way
 

00:04:11.980 --> 00:04:13.680 align:start position:0%
split your cells up again the best way
to<00:04:12.010><c> learn</c><00:04:12.220><c> about</c><00:04:12.340><c> merging</c><00:04:12.849><c> cells</c><00:04:13.150><c> wrapping</c>

00:04:13.680 --> 00:04:13.690 align:start position:0%
to learn about merging cells wrapping
 

00:04:13.690 --> 00:04:15.420 align:start position:0%
to learn about merging cells wrapping
text<00:04:14.080><c> and</c><00:04:14.230><c> working</c><00:04:14.620><c> with</c><00:04:14.739><c> columns</c><00:04:15.130><c> and</c><00:04:15.250><c> rows</c>

00:04:15.420 --> 00:04:15.430 align:start position:0%
text and working with columns and rows
 

00:04:15.430 --> 00:04:17.940 align:start position:0%
text and working with columns and rows
is<00:04:15.790><c> to</c><00:04:16.000><c> practice</c><00:04:16.419><c> so</c><00:04:17.260><c> the</c><00:04:17.380><c> next</c><00:04:17.530><c> time</c><00:04:17.769><c> you're</c>

00:04:17.940 --> 00:04:17.950 align:start position:0%
is to practice so the next time you're
 

00:04:17.950 --> 00:04:19.860 align:start position:0%
is to practice so the next time you're
using<00:04:17.979><c> Excel</c><00:04:18.400><c> look</c><00:04:19.120><c> for</c><00:04:19.299><c> ways</c><00:04:19.419><c> that</c><00:04:19.450><c> you</c><00:04:19.660><c> can</c>

00:04:19.860 --> 00:04:19.870 align:start position:0%
using Excel look for ways that you can
 

00:04:19.870 --> 00:04:21.599 align:start position:0%
using Excel look for ways that you can
customize<00:04:20.049><c> your</c><00:04:20.380><c> worksheet</c><00:04:20.979><c> to</c><00:04:21.190><c> better</c><00:04:21.370><c> fit</c>

00:04:21.599 --> 00:04:21.609 align:start position:0%
customize your worksheet to better fit
 

00:04:21.609 --> 00:04:23.970 align:start position:0%
customize your worksheet to better fit
your<00:04:21.640><c> data</c>