WEBVTT
Kind: captions
Language: en

00:00:01.180 --> 00:00:03.729 align:start position:0%
 
Goodwill<00:00:02.180><c> Community</c><00:00:02.629><c> Foundation</c><00:00:03.290><c> creating</c>

00:00:03.729 --> 00:00:03.739 align:start position:0%
Goodwill Community Foundation creating
 

00:00:03.739 --> 00:00:09.100 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:00:04.340><c> for</c><00:00:04.550><c> a</c><00:00:04.610><c> better</c><00:00:04.640><c> life</c><00:00:06.010><c> in</c><00:00:08.110><c> Excel</c>

00:00:09.100 --> 00:00:09.110 align:start position:0%
opportunities for a better life in Excel
 

00:00:09.110 --> 00:00:11.499 align:start position:0%
opportunities for a better life in Excel
every<00:00:09.650><c> workbook</c><00:00:10.129><c> is</c><00:00:10.309><c> different</c><00:00:10.730><c> that</c><00:00:11.330><c> means</c>

00:00:11.499 --> 00:00:11.509 align:start position:0%
every workbook is different that means
 

00:00:11.509 --> 00:00:13.390 align:start position:0%
every workbook is different that means
you<00:00:11.749><c> may</c><00:00:11.929><c> want</c><00:00:12.139><c> to</c><00:00:12.230><c> modify</c><00:00:12.440><c> certain</c><00:00:13.009><c> things</c>

00:00:13.390 --> 00:00:13.400 align:start position:0%
you may want to modify certain things
 

00:00:13.400 --> 00:00:16.029 align:start position:0%
you may want to modify certain things
like<00:00:13.730><c> the</c><00:00:14.240><c> size</c><00:00:14.480><c> and</c><00:00:14.839><c> layout</c><00:00:14.990><c> of</c><00:00:15.169><c> your</c><00:00:15.409><c> cell</c><00:00:15.619><c> to</c>

00:00:16.029 --> 00:00:16.039 align:start position:0%
like the size and layout of your cell to
 

00:00:16.039 --> 00:00:18.089 align:start position:0%
like the size and layout of your cell to
better<00:00:16.219><c> fit</c><00:00:16.460><c> the</c><00:00:16.519><c> data</c><00:00:16.760><c> you're</c><00:00:17.090><c> working</c><00:00:17.119><c> with</c>

00:00:18.089 --> 00:00:18.099 align:start position:0%
better fit the data you're working with
 

00:00:18.099 --> 00:00:21.099 align:start position:0%
better fit the data you're working with
this<00:00:19.099><c> column</c><00:00:19.550><c> has</c><00:00:19.699><c> been</c><00:00:19.730><c> resized</c><00:00:20.269><c> for</c><00:00:20.689><c> example</c>

00:00:21.099 --> 00:00:21.109 align:start position:0%
this column has been resized for example
 

00:00:21.109 --> 00:00:24.160 align:start position:0%
this column has been resized for example
but<00:00:21.619><c> not</c><00:00:21.830><c> quite</c><00:00:22.130><c> enough</c><00:00:22.400><c> most</c><00:00:23.359><c> of</c><00:00:23.539><c> the</c><00:00:23.630><c> text</c><00:00:24.019><c> is</c>

00:00:24.160 --> 00:00:24.170 align:start position:0%
but not quite enough most of the text is
 

00:00:24.170 --> 00:00:26.380 align:start position:0%
but not quite enough most of the text is
still<00:00:24.410><c> getting</c><00:00:24.589><c> cut</c><00:00:24.830><c> off</c><00:00:24.859><c> I'm</c><00:00:25.310><c> going</c><00:00:26.269><c> to</c>

00:00:26.380 --> 00:00:26.390 align:start position:0%
still getting cut off I'm going to
 

00:00:26.390 --> 00:00:28.240 align:start position:0%
still getting cut off I'm going to
increase<00:00:26.839><c> the</c><00:00:27.050><c> width</c><00:00:27.230><c> a</c><00:00:27.410><c> little</c><00:00:27.439><c> bit</c><00:00:27.830><c> more</c><00:00:28.039><c> by</c>

00:00:28.240 --> 00:00:28.250 align:start position:0%
increase the width a little bit more by
 

00:00:28.250 --> 00:00:30.220 align:start position:0%
increase the width a little bit more by
positioning<00:00:28.849><c> my</c><00:00:29.000><c> mouse</c><00:00:29.210><c> over</c><00:00:29.449><c> the</c><00:00:29.749><c> line</c><00:00:29.960><c> in</c>

00:00:30.220 --> 00:00:30.230 align:start position:0%
positioning my mouse over the line in
 

00:00:30.230 --> 00:00:32.350 align:start position:0%
positioning my mouse over the line in
the<00:00:30.349><c> column</c><00:00:30.380><c> heading</c><00:00:30.980><c> then</c><00:00:31.640><c> clicking</c><00:00:32.150><c> and</c>

00:00:32.350 --> 00:00:32.360 align:start position:0%
the column heading then clicking and
 

00:00:32.360 --> 00:00:35.500 align:start position:0%
the column heading then clicking and
dragging<00:00:32.390><c> it</c><00:00:32.899><c> to</c><00:00:32.930><c> the</c><00:00:33.050><c> right</c><00:00:34.000><c> another</c><00:00:35.000><c> option</c>

00:00:35.500 --> 00:00:35.510 align:start position:0%
dragging it to the right another option
 

00:00:35.510 --> 00:00:37.600 align:start position:0%
dragging it to the right another option
is<00:00:35.629><c> to</c><00:00:35.660><c> auto</c><00:00:35.930><c> size</c><00:00:36.320><c> the</c><00:00:36.530><c> column</c><00:00:36.860><c> this</c><00:00:37.399><c> will</c>

00:00:37.600 --> 00:00:37.610 align:start position:0%
is to auto size the column this will
 

00:00:37.610 --> 00:00:39.369 align:start position:0%
is to auto size the column this will
automatically<00:00:38.300><c> adjust</c><00:00:38.600><c> the</c><00:00:38.780><c> width</c><00:00:38.989><c> so</c><00:00:39.230><c> that</c>

00:00:39.369 --> 00:00:39.379 align:start position:0%
automatically adjust the width so that
 

00:00:39.379 --> 00:00:40.959 align:start position:0%
automatically adjust the width so that
it<00:00:39.620><c> fits</c><00:00:39.829><c> the</c><00:00:39.949><c> contents</c><00:00:40.520><c> of</c><00:00:40.579><c> the</c><00:00:40.730><c> cells</c>

00:00:40.959 --> 00:00:40.969 align:start position:0%
it fits the contents of the cells
 

00:00:40.969 --> 00:00:43.540 align:start position:0%
it fits the contents of the cells
exactly<00:00:41.649><c> just</c><00:00:42.649><c> double-click</c><00:00:42.980><c> the</c><00:00:43.340><c> line</c>

00:00:43.540 --> 00:00:43.550 align:start position:0%
exactly just double-click the line
 

00:00:43.550 --> 00:00:46.810 align:start position:0%
exactly just double-click the line
instead<00:00:44.030><c> of</c><00:00:44.149><c> dragging</c><00:00:44.390><c> it</c><00:00:45.160><c> now</c><00:00:46.160><c> the</c><00:00:46.219><c> column</c><00:00:46.670><c> is</c>

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

00:00:46.820 --> 00:00:50.020 align:start position:0%
instead of dragging it now the column is
perfectly<00:00:47.059><c> sized</c><00:00:47.629><c> to</c><00:00:47.809><c> the</c><00:00:47.989><c> text</c><00:00:48.760><c> rows</c><00:00:49.760><c> work</c>

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

00:00:50.030 --> 00:00:52.090 align:start position:0%
perfectly sized to the text rows work
the<00:00:50.210><c> same</c><00:00:50.420><c> way</c><00:00:50.469><c> you</c><00:00:51.469><c> can</c><00:00:51.620><c> adjust</c><00:00:51.710><c> them</c>

00:00:52.090 --> 00:00:52.100 align:start position:0%
the same way you can adjust them
 

00:00:52.100 --> 00:00:55.420 align:start position:0%
the same way you can adjust them
manually<00:00:52.489><c> or</c><00:00:53.260><c> auto</c><00:00:54.260><c> size</c><00:00:54.620><c> them</c><00:00:54.920><c> to</c><00:00:55.100><c> fit</c><00:00:55.309><c> the</c>

00:00:55.420 --> 00:00:55.430 align:start position:0%
manually or auto size them to fit the
 

00:00:55.430 --> 00:00:58.180 align:start position:0%
manually or auto size them to fit the
height<00:00:55.609><c> of</c><00:00:55.789><c> your</c><00:00:55.879><c> text</c><00:00:57.010><c> sometimes</c><00:00:58.010><c> it's</c>

00:00:58.180 --> 00:00:58.190 align:start position:0%
height of your text sometimes it's
 

00:00:58.190 --> 00:01:00.130 align:start position:0%
height of your text sometimes it's
useful<00:00:58.370><c> to</c><00:00:58.609><c> be</c><00:00:58.760><c> able</c><00:00:59.059><c> to</c><00:00:59.149><c> resize</c><00:00:59.570><c> all</c><00:00:59.840><c> of</c><00:00:59.989><c> your</c>

00:01:00.130 --> 00:01:00.140 align:start position:0%
useful to be able to resize all of your
 

00:01:00.140 --> 00:01:02.529 align:start position:0%
useful to be able to resize all of your
cells<00:01:00.379><c> at</c><00:01:00.559><c> once</c><00:01:00.590><c> in</c><00:01:01.070><c> this</c><00:01:01.760><c> example</c><00:01:02.120><c> I'd</c><00:01:02.480><c> like</c>

00:01:02.529 --> 00:01:02.539 align:start position:0%
cells at once in this example I'd like
 

00:01:02.539 --> 00:01:04.600 align:start position:0%
cells at once in this example I'd like
to<00:01:02.750><c> make</c><00:01:02.989><c> all</c><00:01:03.230><c> of</c><00:01:03.350><c> my</c><00:01:03.500><c> rows</c><00:01:03.710><c> the</c><00:01:03.980><c> exact</c><00:01:04.339><c> same</c>

00:01:04.600 --> 00:01:04.610 align:start position:0%
to make all of my rows the exact same
 

00:01:04.610 --> 00:01:07.179 align:start position:0%
to make all of my rows the exact same
height<00:01:04.879><c> to</c><00:01:05.540><c> do</c><00:01:05.720><c> this</c><00:01:05.900><c> click</c><00:01:06.500><c> the</c><00:01:06.560><c> Select</c><00:01:07.100><c> All</c>

00:01:07.179 --> 00:01:07.189 align:start position:0%
height to do this click the Select All
 

00:01:07.189 --> 00:01:10.270 align:start position:0%
height to do this click the Select All
button<00:01:07.369><c> in</c><00:01:07.850><c> the</c><00:01:08.000><c> top</c><00:01:08.210><c> left</c><00:01:08.240><c> corner</c><00:01:09.280><c> then</c>

00:01:10.270 --> 00:01:10.280 align:start position:0%
button in the top left corner then
 

00:01:10.280 --> 00:01:12.370 align:start position:0%
button in the top left corner then
resize<00:01:10.790><c> a</c><00:01:10.820><c> row</c><00:01:11.000><c> it</c><00:01:11.420><c> doesn't</c><00:01:11.810><c> matter</c><00:01:11.930><c> which</c><00:01:12.170><c> one</c>

00:01:12.370 --> 00:01:12.380 align:start position:0%
resize a row it doesn't matter which one
 

00:01:12.380 --> 00:01:15.219 align:start position:0%
resize a row it doesn't matter which one
and<00:01:13.030><c> the</c><00:01:14.030><c> change</c><00:01:14.299><c> will</c><00:01:14.479><c> be</c><00:01:14.540><c> applied</c><00:01:14.900><c> to</c><00:01:15.140><c> the</c>

00:01:15.219 --> 00:01:15.229 align:start position:0%
and the change will be applied to the
 

00:01:15.229 --> 00:01:18.249 align:start position:0%
and the change will be applied to the
entire<00:01:15.380><c> worksheet</c><00:01:16.750><c> next</c><00:01:17.750><c> I</c><00:01:17.869><c> need</c><00:01:17.990><c> to</c><00:01:18.140><c> add</c>

00:01:18.249 --> 00:01:18.259 align:start position:0%
entire worksheet next I need to add
 

00:01:18.259 --> 00:01:20.770 align:start position:0%
entire worksheet next I need to add
another<00:01:18.710><c> row</c><00:01:18.950><c> to</c><00:01:19.009><c> this</c><00:01:19.250><c> list</c><00:01:19.549><c> I'd</c><00:01:20.270><c> like</c><00:01:20.509><c> to</c><00:01:20.630><c> put</c>

00:01:20.770 --> 00:01:20.780 align:start position:0%
another row to this list I'd like to put
 

00:01:20.780 --> 00:01:24.249 align:start position:0%
another row to this list I'd like to put
it<00:01:20.900><c> in</c><00:01:20.990><c> between</c><00:01:21.140><c> row</c><00:01:21.590><c> 4</c><00:01:21.920><c> and</c><00:01:22.220><c> row</c><00:01:22.460><c> 5</c><00:01:23.049><c> to</c><00:01:24.049><c> add</c><00:01:24.229><c> a</c>

00:01:24.249 --> 00:01:24.259 align:start position:0%
it in between row 4 and row 5 to add a
 

00:01:24.259 --> 00:01:26.499 align:start position:0%
it in between row 4 and row 5 to add a
new<00:01:24.530><c> row</c><00:01:24.740><c> all</c><00:01:25.040><c> you</c><00:01:25.310><c> have</c><00:01:25.460><c> to</c><00:01:25.610><c> do</c><00:01:25.759><c> is</c><00:01:26.030><c> select</c><00:01:26.240><c> the</c>

00:01:26.499 --> 00:01:26.509 align:start position:0%
new row all you have to do is select the
 

00:01:26.509 --> 00:01:28.420 align:start position:0%
new row all you have to do is select the
row<00:01:26.780><c> heading</c><00:01:27.140><c> below</c><00:01:27.560><c> where</c><00:01:27.829><c> you</c><00:01:27.950><c> want</c><00:01:28.159><c> the</c><00:01:28.310><c> new</c>

00:01:28.420 --> 00:01:28.430 align:start position:0%
row heading below where you want the new
 

00:01:28.430 --> 00:01:31.240 align:start position:0%
row heading below where you want the new
one<00:01:28.460><c> to</c><00:01:28.790><c> appear</c><00:01:29.409><c> then</c><00:01:30.409><c> click</c><00:01:30.770><c> the</c><00:01:30.920><c> insert</c>

00:01:31.240 --> 00:01:31.250 align:start position:0%
one to appear then click the insert
 

00:01:31.250 --> 00:01:38.210 align:start position:0%
one to appear then click the insert
command

00:01:38.210 --> 00:01:38.220 align:start position:0%
 
 

00:01:38.220 --> 00:01:40.640 align:start position:0%
 
the<00:01:38.880><c> process</c><00:01:39.330><c> is</c><00:01:39.510><c> similar</c><00:01:39.720><c> for</c><00:01:39.900><c> inserting</c><00:01:40.470><c> a</c>

00:01:40.640 --> 00:01:40.650 align:start position:0%
the process is similar for inserting a
 

00:01:40.650 --> 00:01:42.920 align:start position:0%
the process is similar for inserting a
new<00:01:40.680><c> column</c><00:01:40.800><c> just</c><00:01:41.420><c> select</c><00:01:42.420><c> the</c><00:01:42.540><c> column</c>

00:01:42.920 --> 00:01:42.930 align:start position:0%
new column just select the column
 

00:01:42.930 --> 00:01:44.510 align:start position:0%
new column just select the column
heading<00:01:43.260><c> to</c><00:01:43.290><c> the</c><00:01:43.560><c> right</c><00:01:43.800><c> of</c><00:01:44.010><c> where</c><00:01:44.160><c> you</c><00:01:44.310><c> want</c>

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

00:01:44.520 --> 00:01:47.000 align:start position:0%
heading to the right of where you want
the<00:01:44.610><c> new</c><00:01:44.640><c> one</c><00:01:44.790><c> to</c><00:01:45.060><c> go</c><00:01:45.500><c> click</c><00:01:46.500><c> the</c><00:01:46.650><c> insert</c>

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

00:01:47.010 --> 00:01:49.550 align:start position:0%
the new one to go click the insert
command<00:01:47.160><c> and</c><00:01:47.610><c> a</c><00:01:48.450><c> column</c><00:01:48.810><c> will</c><00:01:48.930><c> appear</c><00:01:48.960><c> to</c><00:01:49.440><c> the</c>

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

00:01:49.560 --> 00:01:54.560 align:start position:0%
command and a column will appear to the
left<00:01:52.340><c> deleting</c><00:01:53.340><c> columns</c><00:01:53.520><c> and</c><00:01:53.820><c> rows</c><00:01:53.970><c> is</c><00:01:54.240><c> just</c>

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

00:01:54.570 --> 00:01:57.320 align:start position:0%
left deleting columns and rows is just
as<00:01:54.720><c> easy</c><00:01:54.840><c> first</c><00:01:55.830><c> select</c><00:01:56.520><c> the</c><00:01:56.700><c> column</c><00:01:57.060><c> or</c><00:01:57.150><c> row</c>

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

00:01:57.330 --> 00:01:59.750 align:start position:0%
as easy first select the column or row
you<00:01:57.360><c> want</c><00:01:57.690><c> to</c><00:01:57.810><c> delete</c><00:01:58.130><c> then</c><00:01:59.130><c> click</c><00:01:59.460><c> the</c><00:01:59.610><c> delete</c>

00:01:59.750 --> 00:01:59.760 align:start position:0%
you want to delete then click the delete
 

00:01:59.760 --> 00:02:03.800 align:start position:0%
you want to delete then click the delete
command<00:02:01.760><c> the</c><00:02:02.760><c> column</c><00:02:03.180><c> or</c><00:02:03.300><c> row</c><00:02:03.480><c> will</c><00:02:03.690><c> be</c>

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

00:02:03.810 --> 00:02:06.080 align:start position:0%
command the column or row will be
deleted<00:02:04.260><c> causing</c><00:02:04.950><c> the</c><00:02:05.040><c> other</c><00:02:05.220><c> cells</c><00:02:05.610><c> to</c><00:02:05.880><c> move</c>

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

00:02:06.090 --> 00:02:08.810 align:start position:0%
deleted causing the other cells to move
and<00:02:06.390><c> fill</c><00:02:06.660><c> in</c><00:02:06.810><c> the</c><00:02:06.930><c> gap</c><00:02:07.110><c> automatically</c><00:02:07.860><c> just</c>

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

00:02:08.820 --> 00:02:10.010 align:start position:0%
and fill in the gap automatically just
remember<00:02:09.210><c> that</c><00:02:09.360><c> there</c><00:02:09.510><c> is</c><00:02:09.540><c> a</c><00:02:09.630><c> difference</c>

00:02:10.010 --> 00:02:10.020 align:start position:0%
remember that there is a difference
 

00:02:10.020 --> 00:02:12.620 align:start position:0%
remember that there is a difference
between<00:02:10.200><c> clearing</c><00:02:10.920><c> and</c><00:02:11.130><c> deleting</c><00:02:11.630><c> deleting</c>

00:02:12.620 --> 00:02:12.630 align:start position:0%
between clearing and deleting deleting
 

00:02:12.630 --> 00:02:14.330 align:start position:0%
between clearing and deleting deleting
cells<00:02:12.900><c> removes</c><00:02:13.350><c> them</c><00:02:13.560><c> from</c><00:02:13.740><c> your</c><00:02:13.860><c> worksheet</c>

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

00:02:14.340 --> 00:02:18.170 align:start position:0%
cells removes them from your worksheet
clearing<00:02:15.270><c> just</c><00:02:15.570><c> removes</c><00:02:15.930><c> the</c><00:02:16.080><c> contents</c><00:02:17.180><c> you</c>

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

00:02:18.180 --> 00:02:19.850 align:start position:0%
clearing just removes the contents you
can<00:02:18.330><c> also</c><00:02:18.480><c> move</c><00:02:18.810><c> a</c><00:02:18.990><c> column</c><00:02:19.200><c> or</c><00:02:19.470><c> row</c><00:02:19.590><c> to</c><00:02:19.650><c> a</c>

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

00:02:19.860 --> 00:02:20.720 align:start position:0%
can also move a column or row to a
different<00:02:20.220><c> location</c>

00:02:20.720 --> 00:02:20.730 align:start position:0%
different location
 

00:02:20.730 --> 00:02:23.270 align:start position:0%
different location
in<00:02:20.850><c> this</c><00:02:21.600><c> example</c><00:02:21.960><c> we'll</c><00:02:22.350><c> move</c><00:02:22.530><c> a</c><00:02:22.650><c> column</c><00:02:22.830><c> all</c>

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

00:02:23.280 --> 00:02:25.220 align:start position:0%
in this example we'll move a column all
you<00:02:23.880><c> have</c><00:02:24.030><c> to</c><00:02:24.150><c> do</c><00:02:24.300><c> is</c><00:02:24.570><c> select</c><00:02:24.780><c> the</c><00:02:25.050><c> one</c><00:02:25.080><c> you</c>

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

00:02:25.230 --> 00:02:29.990 align:start position:0%
you have to do is select the one you
want<00:02:25.820><c> then</c><00:02:26.820><c> click</c><00:02:26.850><c> the</c><00:02:27.300><c> cut</c><00:02:27.510><c> command</c><00:02:29.000><c> next</c>

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

00:02:30.000 --> 00:02:31.790 align:start position:0%
want then click the cut command next
select<00:02:30.510><c> the</c><00:02:30.570><c> column</c><00:02:30.990><c> to</c><00:02:31.140><c> the</c><00:02:31.260><c> right</c><00:02:31.290><c> of</c><00:02:31.650><c> where</c>

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

00:02:31.800 --> 00:02:34.520 align:start position:0%
select the column to the right of where
you<00:02:31.950><c> want</c><00:02:32.130><c> the</c><00:02:32.250><c> column</c><00:02:32.550><c> to</c><00:02:32.700><c> be</c><00:02:32.730><c> moved</c><00:02:33.530><c> click</c>

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

00:02:34.530 --> 00:02:36.910 align:start position:0%
you want the column to be moved click
the<00:02:34.680><c> insert</c><00:02:35.160><c> drop-down</c><00:02:35.670><c> menu</c><00:02:36.030><c> on</c><00:02:36.180><c> the</c><00:02:36.270><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.050 align:start position:0%
the insert drop-down menu on the ribbon
then<00:02:37.920><c> choose</c><00:02:38.280><c> insert</c><00:02:38.910><c> cut</c><00:02:39.210><c> cells</c><00:02:41.060><c> another</c>

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

00:02:42.060 --> 00:02:44.180 align:start position:0%
then choose insert cut cells another
useful<00:02:42.330><c> technique</c><00:02:42.660><c> for</c><00:02:43.080><c> rearranging</c><00:02:43.709><c> data</c><00:02:43.920><c> is</c>

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

00:02:44.190 --> 00:02:46.070 align:start position:0%
useful technique for rearranging data is
the<00:02:44.340><c> ability</c><00:02:44.760><c> to</c><00:02:44.790><c> hide</c><00:02:45.120><c> certain</c><00:02:45.390><c> columns</c><00:02:45.930><c> or</c>

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

00:02:46.080 --> 00:02:48.560 align:start position:0%
the ability to hide certain columns or
rows<00:02:46.280><c> for</c><00:02:47.280><c> example</c><00:02:47.730><c> I</c><00:02:47.880><c> don't</c><00:02:47.970><c> really</c><00:02:48.300><c> need</c><00:02:48.510><c> to</c>

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

00:02:48.570 --> 00:02:50.810 align:start position:0%
rows for example I don't really need to
see<00:02:48.840><c> these</c><00:02:49.110><c> three</c><00:02:49.410><c> columns</c><00:02:49.860><c> right</c><00:02:50.040><c> now</c><00:02:50.220><c> I'd</c>

00:02:50.810 --> 00:02:50.820 align:start position:0%
see these three columns right now I'd
 

00:02:50.820 --> 00:02:52.430 align:start position:0%
see these three columns right now I'd
rather<00:02:51.060><c> focus</c><00:02:51.360><c> on</c><00:02:51.660><c> the</c><00:02:51.780><c> customers</c><00:02:52.200><c> email</c>

00:02:52.430 --> 00:02:52.440 align:start position:0%
rather focus on the customers email
 

00:02:52.440 --> 00:02:56.390 align:start position:0%
rather focus on the customers email
addresses<00:02:53.070><c> if</c><00:02:53.280><c> we</c><00:02:54.270><c> right</c><00:02:54.510><c> click</c><00:02:55.370><c> then</c><00:02:56.370><c> choose</c>

00:02:56.390 --> 00:02:56.400 align:start position:0%
addresses if we right click then choose
 

00:02:56.400 --> 00:02:58.990 align:start position:0%
addresses if we right click then choose
hide<00:02:57.000><c> from</c><00:02:57.180><c> the</c><00:02:57.360><c> menu</c>

00:02:58.990 --> 00:02:59.000 align:start position:0%
hide from the menu
 

00:02:59.000 --> 00:03:02.470 align:start position:0%
hide from the menu
the<00:02:59.630><c> columns</c><00:03:00.050><c> temporarily</c><00:03:00.620><c> disappear</c><00:03:01.480><c> to</c>

00:03:02.470 --> 00:03:02.480 align:start position:0%
the columns temporarily disappear to
 

00:03:02.480 --> 00:03:04.570 align:start position:0%
the columns temporarily disappear to
unhide<00:03:02.810><c> them</c><00:03:03.020><c> select</c><00:03:03.740><c> the</c><00:03:03.860><c> columns</c><00:03:04.250><c> on</c><00:03:04.400><c> either</c>

00:03:04.570 --> 00:03:04.580 align:start position:0%
unhide them select the columns on either
 

00:03:04.580 --> 00:03:06.100 align:start position:0%
unhide them select the columns on either
side<00:03:04.970><c> of</c><00:03:05.000><c> the</c><00:03:05.240><c> ones</c><00:03:05.420><c> that</c><00:03:05.600><c> are</c><00:03:05.720><c> hidden</c>

00:03:06.100 --> 00:03:06.110 align:start position:0%
side of the ones that are hidden
 

00:03:06.110 --> 00:03:12.660 align:start position:0%
side of the ones that are hidden
then<00:03:06.980><c> right-click</c><00:03:07.280><c> again</c><00:03:07.610><c> and</c><00:03:08.740><c> choose</c><00:03:09.740><c> unhide</c>

00:03:12.660 --> 00:03:12.670 align:start position:0%
 
 

00:03:12.670 --> 00:03:14.740 align:start position:0%
 
let's<00:03:13.670><c> fast</c><00:03:13.940><c> forward</c><00:03:14.090><c> to</c><00:03:14.420><c> the</c><00:03:14.540><c> finished</c>

00:03:14.740 --> 00:03:14.750 align:start position:0%
let's fast forward to the finished
 

00:03:14.750 --> 00:03:18.040 align:start position:0%
let's fast forward to the finished
worksheet<00:03:16.120><c> next</c><00:03:17.120><c> I'd</c><00:03:17.330><c> like</c><00:03:17.480><c> to</c><00:03:17.660><c> take</c><00:03:17.780><c> a</c><00:03:17.840><c> look</c>

00:03:18.040 --> 00:03:18.050 align:start position:0%
worksheet next I'd like to take a look
 

00:03:18.050 --> 00:03:19.960 align:start position:0%
worksheet next I'd like to take a look
at<00:03:18.170><c> wrapping</c><00:03:18.560><c> text</c><00:03:18.800><c> which</c><00:03:19.430><c> is</c><00:03:19.610><c> one</c><00:03:19.790><c> way</c><00:03:19.940><c> of</c>

00:03:19.960 --> 00:03:19.970 align:start position:0%
at wrapping text which is one way of
 

00:03:19.970 --> 00:03:22.060 align:start position:0%
at wrapping text which is one way of
addressing<00:03:20.180><c> cells</c><00:03:20.780><c> that</c><00:03:21.020><c> contain</c><00:03:21.380><c> more</c><00:03:21.650><c> text</c>

00:03:22.060 --> 00:03:22.070 align:start position:0%
addressing cells that contain more text
 

00:03:22.070 --> 00:03:24.550 align:start position:0%
addressing cells that contain more text
than<00:03:22.310><c> they</c><00:03:22.430><c> can</c><00:03:22.490><c> actually</c><00:03:22.790><c> display</c><00:03:23.560><c> for</c>

00:03:24.550 --> 00:03:24.560 align:start position:0%
than they can actually display for
 

00:03:24.560 --> 00:03:26.770 align:start position:0%
than they can actually display for
example<00:03:25.070><c> I'd</c><00:03:25.310><c> like</c><00:03:25.340><c> to</c><00:03:25.520><c> resize</c><00:03:25.670><c> my</c><00:03:26.270><c> column</c><00:03:26.660><c> of</c>

00:03:26.770 --> 00:03:26.780 align:start position:0%
example I'd like to resize my column of
 

00:03:26.780 --> 00:03:28.630 align:start position:0%
example I'd like to resize my column of
addresses<00:03:27.290><c> to</c><00:03:27.320><c> about</c><00:03:27.740><c> half</c><00:03:27.980><c> its</c><00:03:28.220><c> current</c><00:03:28.430><c> size</c>

00:03:28.630 --> 00:03:28.640 align:start position:0%
addresses to about half its current size
 

00:03:28.640 --> 00:03:32.290 align:start position:0%
addresses to about half its current size
but<00:03:29.390><c> still</c><00:03:29.660><c> be</c><00:03:29.810><c> able</c><00:03:29.930><c> to</c><00:03:30.080><c> see</c><00:03:30.290><c> the</c><00:03:30.440><c> contents</c><00:03:31.300><c> we</c>

00:03:32.290 --> 00:03:32.300 align:start position:0%
but still be able to see the contents we
 

00:03:32.300 --> 00:03:34.030 align:start position:0%
but still be able to see the contents we
can<00:03:32.450><c> do</c><00:03:32.630><c> this</c><00:03:32.810><c> using</c><00:03:33.080><c> the</c><00:03:33.350><c> wrap</c><00:03:33.530><c> text</c><00:03:33.830><c> command</c>

00:03:34.030 --> 00:03:34.040 align:start position:0%
can do this using the wrap text command
 

00:03:34.040 --> 00:03:37.180 align:start position:0%
can do this using the wrap text command
on<00:03:34.459><c> the</c><00:03:34.550><c> ribbon</c><00:03:34.580><c> as</c><00:03:35.500><c> you</c><00:03:36.500><c> can</c><00:03:36.680><c> see</c><00:03:36.890><c> this</c>

00:03:37.180 --> 00:03:37.190 align:start position:0%
on the ribbon as you can see this
 

00:03:37.190 --> 00:03:40.600 align:start position:0%
on the ribbon as you can see this
displays<00:03:37.640><c> the</c><00:03:37.850><c> text</c><00:03:38.209><c> on</c><00:03:38.330><c> multiple</c><00:03:38.840><c> lines</c><00:03:39.610><c> now</c>

00:03:40.600 --> 00:03:40.610 align:start position:0%
displays the text on multiple lines now
 

00:03:40.610 --> 00:03:41.560 align:start position:0%
displays the text on multiple lines now
for<00:03:40.880><c> the</c><00:03:40.970><c> finishing</c><00:03:41.240><c> touch</c>

00:03:41.560 --> 00:03:41.570 align:start position:0%
for the finishing touch
 

00:03:41.570 --> 00:03:44.110 align:start position:0%
for the finishing touch
combining<00:03:42.470><c> the</c><00:03:42.709><c> cells</c><00:03:42.950><c> in</c><00:03:43.160><c> the</c><00:03:43.250><c> top</c><00:03:43.459><c> row</c><00:03:43.730><c> so</c>

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

00:03:44.120 --> 00:03:45.580 align:start position:0%
combining the cells in the top row so
the<00:03:44.240><c> title</c><00:03:44.480><c> of</c><00:03:44.660><c> my</c><00:03:44.840><c> worksheet</c><00:03:45.260><c> can</c><00:03:45.440><c> be</c>

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

00:03:45.590 --> 00:03:48.580 align:start position:0%
the title of my worksheet can be
centered<00:03:45.950><c> in</c><00:03:46.130><c> a</c><00:03:46.280><c> single</c><00:03:46.700><c> large</c><00:03:46.970><c> cell</c><00:03:47.470><c> to</c><00:03:48.470><c> do</c>

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

00:03:48.590 --> 00:03:51.090 align:start position:0%
centered in a single large cell to do
this<00:03:48.770><c> select</c><00:03:49.310><c> the</c><00:03:49.520><c> cells</c><00:03:49.820><c> you</c><00:03:49.910><c> want</c><00:03:50.000><c> to</c><00:03:50.209><c> merge</c>

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

00:03:51.100 --> 00:03:55.110 align:start position:0%
this select the cells you want to merge
then<00:03:52.100><c> click</c><00:03:52.400><c> the</c><00:03:52.550><c> merge</c><00:03:52.820><c> &amp;</c><00:03:53.120><c> Center</c><00:03:53.450><c> command</c>

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

00:03:55.120 --> 00:03:58.990 align:start position:0%
then click the merge &amp; Center command
there<00:03:56.120><c> that's</c><00:03:56.510><c> perfect</c><00:03:57.430><c> to</c><00:03:58.430><c> access</c><00:03:58.790><c> more</c>

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

00:03:59.000 --> 00:04:01.150 align:start position:0%
there that's perfect to access more
merge<00:03:59.240><c> options</c><00:03:59.750><c> open</c><00:04:00.050><c> the</c><00:04:00.410><c> drop</c><00:04:00.620><c> down</c><00:04:00.830><c> menu</c>

00:04:01.150 --> 00:04:01.160 align:start position:0%
merge options open the drop down menu
 

00:04:01.160 --> 00:04:04.300 align:start position:0%
merge options open the drop down menu
here<00:04:01.490><c> you</c><00:04:01.610><c> can</c><00:04:02.540><c> merge</c><00:04:02.930><c> across</c><00:04:03.380><c> creating</c>

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

00:04:04.310 --> 00:04:06.160 align:start position:0%
here you can merge across creating
merged<00:04:04.550><c> rows</c><00:04:04.910><c> instead</c><00:04:05.360><c> of</c><00:04:05.570><c> a</c><00:04:05.630><c> single</c><00:04:05.989><c> large</c>

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

00:04:06.170 --> 00:04:08.380 align:start position:0%
merged rows instead of a single large
cell<00:04:06.530><c> if</c><00:04:06.800><c> you</c><00:04:07.010><c> have</c><00:04:07.160><c> multiple</c><00:04:07.550><c> cells</c><00:04:07.820><c> selected</c>

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

00:04:08.390 --> 00:04:11.740 align:start position:0%
cell if you have multiple cells selected
you<00:04:09.260><c> can</c><00:04:09.410><c> also</c><00:04:09.590><c> merge</c><00:04:10.160><c> without</c><00:04:10.430><c> centering</c><00:04:11.060><c> or</c>

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

00:04:11.750 --> 00:04:14.979 align:start position:0%
you can also merge without centering or
split<00:04:12.620><c> your</c><00:04:12.739><c> cells</c><00:04:13.010><c> up</c><00:04:13.160><c> again</c><00:04:13.840><c> there</c><00:04:14.840><c> is</c><00:04:14.959><c> a</c>

00:04:14.979 --> 00:04:14.989 align:start position:0%
split your cells up again there is a
 

00:04:14.989 --> 00:04:16.690 align:start position:0%
split your cells up again there is a
downside<00:04:15.530><c> to</c><00:04:15.709><c> using</c><00:04:15.739><c> the</c><00:04:16.130><c> merge</c><00:04:16.340><c> command</c>

00:04:16.690 --> 00:04:16.700 align:start position:0%
downside to using the merge command
 

00:04:16.700 --> 00:04:18.610 align:start position:0%
downside to using the merge command
though<00:04:16.970><c> if</c><00:04:17.330><c> you</c><00:04:17.870><c> want</c><00:04:18.019><c> to</c><00:04:18.200><c> merge</c><00:04:18.350><c> multiple</c>

00:04:18.610 --> 00:04:18.620 align:start position:0%
though if you want to merge multiple
 

00:04:18.620 --> 00:04:21.070 align:start position:0%
though if you want to merge multiple
cells<00:04:19.130><c> each</c><00:04:19.400><c> containing</c><00:04:20.060><c> data</c><00:04:20.209><c> merge</c><00:04:20.870><c> will</c>

00:04:21.070 --> 00:04:21.080 align:start position:0%
cells each containing data merge will
 

00:04:21.080 --> 00:04:23.140 align:start position:0%
cells each containing data merge will
only<00:04:21.290><c> keep</c><00:04:21.620><c> the</c><00:04:21.769><c> contents</c><00:04:22.310><c> of</c><00:04:22.370><c> the</c><00:04:22.580><c> upper</c><00:04:22.910><c> left</c>

00:04:23.140 --> 00:04:23.150 align:start position:0%
only keep the contents of the upper left
 

00:04:23.150 --> 00:04:25.570 align:start position:0%
only keep the contents of the upper left
cell<00:04:23.510><c> and</c><00:04:23.750><c> discard</c><00:04:24.200><c> everything</c><00:04:24.650><c> else</c><00:04:24.800><c> so</c><00:04:25.520><c> you</c>

00:04:25.570 --> 00:04:25.580 align:start position:0%
cell and discard everything else so you
 

00:04:25.580 --> 00:04:27.010 align:start position:0%
cell and discard everything else so you
should<00:04:25.880><c> be</c><00:04:26.000><c> careful</c><00:04:26.419><c> when</c><00:04:26.540><c> using</c><00:04:26.750><c> this</c>

00:04:27.010 --> 00:04:27.020 align:start position:0%
should be careful when using this
 

00:04:27.020 --> 00:04:29.350 align:start position:0%
should be careful when using this
feature<00:04:27.520><c> the</c><00:04:28.520><c> best</c><00:04:28.760><c> way</c><00:04:28.940><c> to</c><00:04:28.970><c> learn</c><00:04:29.210><c> about</c>

00:04:29.350 --> 00:04:29.360 align:start position:0%
feature the best way to learn about
 

00:04:29.360 --> 00:04:31.719 align:start position:0%
feature the best way to learn about
merging<00:04:29.840><c> cells</c><00:04:30.080><c> wrapping</c><00:04:30.740><c> text</c><00:04:31.190><c> and</c><00:04:31.400><c> working</c>

00:04:31.719 --> 00:04:31.729 align:start position:0%
merging cells wrapping text and working
 

00:04:31.729 --> 00:04:34.120 align:start position:0%
merging cells wrapping text and working
with<00:04:31.880><c> columns</c><00:04:32.270><c> and</c><00:04:32.419><c> rows</c><00:04:32.600><c> is</c><00:04:32.840><c> to</c><00:04:32.990><c> practice</c><00:04:33.440><c> so</c>

00:04:34.120 --> 00:04:34.130 align:start position:0%
with columns and rows is to practice so
 

00:04:34.130 --> 00:04:35.920 align:start position:0%
with columns and rows is to practice so
the<00:04:34.280><c> next</c><00:04:34.460><c> time</c><00:04:34.669><c> you're</c><00:04:34.850><c> using</c><00:04:34.880><c> Excel</c><00:04:35.300><c> look</c>

00:04:35.920 --> 00:04:35.930 align:start position:0%
the next time you're using Excel look
 

00:04:35.930 --> 00:04:37.330 align:start position:0%
the next time you're using Excel look
for<00:04:36.140><c> ways</c><00:04:36.260><c> that</c><00:04:36.560><c> you</c><00:04:36.680><c> can</c><00:04:36.860><c> customize</c><00:04:37.040><c> your</c>

00:04:37.330 --> 00:04:37.340 align:start position:0%
for ways that you can customize your
 

00:04:37.340 --> 00:04:43.010 align:start position:0%
for ways that you can customize your
worksheet<00:04:37.850><c> to</c><00:04:38.060><c> better</c><00:04:38.240><c> fit</c><00:04:38.479><c> your</c><00:04:38.510><c> data</c>

00:04:43.010 --> 00:04:43.020 align:start position:0%
 
 

00:04:43.020 --> 00:04:45.080 align:start position:0%
 
you