WEBVTT
Kind: captions
Language: en

00:00:11.170 --> 00:00:13.930 align:start position:0%
 
when<00:00:12.170><c> you</c><00:00:12.260><c> open</c><00:00:12.590><c> a</c><00:00:12.650><c> new</c><00:00:12.680><c> blank</c><00:00:12.920><c> workbook</c><00:00:13.280><c> cells</c>

00:00:13.930 --> 00:00:13.940 align:start position:0%
when you open a new blank workbook cells
 

00:00:13.940 --> 00:00:16.540 align:start position:0%
when you open a new blank workbook cells
are<00:00:14.120><c> set</c><00:00:14.330><c> to</c><00:00:14.540><c> a</c><00:00:14.570><c> default</c><00:00:14.750><c> size</c><00:00:15.250><c> however</c><00:00:16.250><c> as</c>

00:00:16.540 --> 00:00:16.550 align:start position:0%
are set to a default size however as
 

00:00:16.550 --> 00:00:18.609 align:start position:0%
are set to a default size however as
seen<00:00:16.880><c> here</c><00:00:17.270><c> you</c><00:00:17.420><c> may</c><00:00:17.689><c> want</c><00:00:17.720><c> to</c><00:00:17.930><c> go</c><00:00:18.080><c> beyond</c><00:00:18.470><c> the</c>

00:00:18.609 --> 00:00:18.619 align:start position:0%
seen here you may want to go beyond the
 

00:00:18.619 --> 00:00:20.260 align:start position:0%
seen here you may want to go beyond the
default<00:00:18.980><c> size</c><00:00:19.220><c> depending</c><00:00:19.820><c> on</c><00:00:19.910><c> the</c><00:00:19.970><c> type</c><00:00:20.240><c> of</c>

00:00:20.260 --> 00:00:20.270 align:start position:0%
default size depending on the type of
 

00:00:20.270 --> 00:00:22.450 align:start position:0%
default size depending on the type of
spreadsheet<00:00:20.930><c> you're</c><00:00:21.080><c> working</c><00:00:21.470><c> on</c><00:00:21.590><c> this</c>

00:00:22.450 --> 00:00:22.460 align:start position:0%
spreadsheet you're working on this
 

00:00:22.460 --> 00:00:24.700 align:start position:0%
spreadsheet you're working on this
column<00:00:22.880><c> has</c><00:00:23.029><c> been</c><00:00:23.210><c> resized</c><00:00:23.630><c> for</c><00:00:23.960><c> example</c><00:00:24.410><c> but</c>

00:00:24.700 --> 00:00:24.710 align:start position:0%
column has been resized for example but
 

00:00:24.710 --> 00:00:27.040 align:start position:0%
column has been resized for example but
not<00:00:24.950><c> quite</c><00:00:25.340><c> enough</c><00:00:25.640><c> a</c><00:00:25.880><c> couple</c><00:00:26.450><c> addresses</c><00:00:26.660><c> are</c>

00:00:27.040 --> 00:00:27.050 align:start position:0%
not quite enough a couple addresses are
 

00:00:27.050 --> 00:00:29.080 align:start position:0%
not quite enough a couple addresses are
still<00:00:27.290><c> getting</c><00:00:27.560><c> cut</c><00:00:27.770><c> off</c><00:00:27.800><c> I'm</c><00:00:28.189><c> just</c><00:00:28.849><c> going</c><00:00:29.029><c> to</c>

00:00:29.080 --> 00:00:29.090 align:start position:0%
still getting cut off I'm just going to
 

00:00:29.090 --> 00:00:30.970 align:start position:0%
still getting cut off I'm just going to
increase<00:00:29.390><c> the</c><00:00:29.660><c> column</c><00:00:29.989><c> width</c><00:00:30.200><c> a</c><00:00:30.349><c> little</c><00:00:30.710><c> by</c>

00:00:30.970 --> 00:00:30.980 align:start position:0%
increase the column width a little by
 

00:00:30.980 --> 00:00:32.979 align:start position:0%
increase the column width a little by
positioning<00:00:31.610><c> my</c><00:00:31.790><c> mouse</c><00:00:32.000><c> over</c><00:00:32.270><c> the</c><00:00:32.509><c> line</c><00:00:32.720><c> in</c>

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

00:00:32.989 --> 00:00:34.870 align:start position:0%
positioning my mouse over the line in
the<00:00:33.079><c> column</c><00:00:33.110><c> heading</c><00:00:33.739><c> then</c><00:00:34.100><c> clicking</c><00:00:34.670><c> and</c>

00:00:34.870 --> 00:00:34.880 align:start position:0%
the column heading then clicking and
 

00:00:34.880 --> 00:00:37.810 align:start position:0%
the column heading then clicking and
dragging<00:00:34.910><c> it</c><00:00:35.420><c> to</c><00:00:35.450><c> the</c><00:00:35.660><c> right</c><00:00:36.050><c> you</c><00:00:36.670><c> can</c><00:00:37.670><c> get</c>

00:00:37.810 --> 00:00:37.820 align:start position:0%
dragging it to the right you can get
 

00:00:37.820 --> 00:00:39.670 align:start position:0%
dragging it to the right you can get
even<00:00:38.149><c> more</c><00:00:38.329><c> precise</c><00:00:38.750><c> results</c><00:00:38.899><c> with</c><00:00:39.500><c> the</c>

00:00:39.670 --> 00:00:39.680 align:start position:0%
even more precise results with the
 

00:00:39.680 --> 00:00:42.520 align:start position:0%
even more precise results with the
format<00:00:40.070><c> command</c><00:00:40.630><c> choose</c><00:00:41.630><c> column</c><00:00:42.080><c> width</c><00:00:42.290><c> to</c>

00:00:42.520 --> 00:00:42.530 align:start position:0%
format command choose column width to
 

00:00:42.530 --> 00:00:44.140 align:start position:0%
format command choose column width to
change<00:00:42.830><c> the</c><00:00:43.010><c> column</c><00:00:43.370><c> to</c><00:00:43.520><c> a</c><00:00:43.550><c> specific</c>

00:00:44.140 --> 00:00:44.150 align:start position:0%
change the column to a specific
 

00:00:44.150 --> 00:00:46.000 align:start position:0%
change the column to a specific
measurement<00:00:44.480><c> the</c><00:00:45.050><c> width</c><00:00:45.290><c> is</c><00:00:45.500><c> measured</c><00:00:45.860><c> in</c>

00:00:46.000 --> 00:00:46.010 align:start position:0%
measurement the width is measured in
 

00:00:46.010 --> 00:00:47.130 align:start position:0%
measurement the width is measured in
pixels

00:00:47.130 --> 00:00:47.140 align:start position:0%
pixels
 

00:00:47.140 --> 00:00:49.930 align:start position:0%
pixels
another<00:00:48.140><c> option</c><00:00:48.620><c> is</c><00:00:48.770><c> to</c><00:00:48.980><c> autofit</c><00:00:49.490><c> the</c><00:00:49.520><c> column</c>

00:00:49.930 --> 00:00:49.940 align:start position:0%
another option is to autofit the column
 

00:00:49.940 --> 00:00:51.640 align:start position:0%
another option is to autofit the column
which<00:00:50.300><c> will</c><00:00:50.510><c> automatically</c><00:00:51.050><c> adjust</c><00:00:51.500><c> the</c>

00:00:51.640 --> 00:00:51.650 align:start position:0%
which will automatically adjust the
 

00:00:51.650 --> 00:00:53.470 align:start position:0%
which will automatically adjust the
column<00:00:52.070><c> so</c><00:00:52.280><c> it</c><00:00:52.400><c> fits</c><00:00:52.610><c> the</c><00:00:52.790><c> contents</c><00:00:53.180><c> of</c><00:00:53.360><c> the</c>

00:00:53.470 --> 00:00:53.480 align:start position:0%
column so it fits the contents of the
 

00:00:53.480 --> 00:00:57.640 align:start position:0%
column so it fits the contents of the
cells<00:00:53.720><c> exactly</c><00:00:54.220><c> just</c><00:00:55.220><c> go</c><00:00:55.400><c> to</c><00:00:55.460><c> format</c><00:00:56.650><c> autofit</c>

00:00:57.640 --> 00:00:57.650 align:start position:0%
cells exactly just go to format autofit
 

00:00:57.650 --> 00:01:00.130 align:start position:0%
cells exactly just go to format autofit
column<00:00:57.890><c> width</c><00:00:58.220><c> now</c><00:00:59.180><c> the</c><00:00:59.240><c> column</c><00:00:59.720><c> is</c><00:00:59.870><c> perfectly</c>

00:01:00.130 --> 00:01:00.140 align:start position:0%
column width now the column is perfectly
 

00:01:00.140 --> 00:01:04.149 align:start position:0%
column width now the column is perfectly
sized<00:01:00.740><c> to</c><00:01:00.980><c> the</c><00:01:01.010><c> text</c><00:01:02.170><c> rows</c><00:01:03.170><c> work</c><00:01:03.530><c> the</c><00:01:03.710><c> same</c><00:01:03.950><c> way</c>

00:01:04.149 --> 00:01:04.159 align:start position:0%
sized to the text rows work the same way
 

00:01:04.159 --> 00:01:06.280 align:start position:0%
sized to the text rows work the same way
you<00:01:04.790><c> can</c><00:01:04.970><c> click</c><00:01:05.239><c> and</c><00:01:05.390><c> drag</c><00:01:05.449><c> the</c><00:01:05.840><c> line</c><00:01:06.020><c> to</c>

00:01:06.280 --> 00:01:06.290 align:start position:0%
you can click and drag the line to
 

00:01:06.290 --> 00:01:09.490 align:start position:0%
you can click and drag the line to
adjust<00:01:06.650><c> the</c><00:01:06.799><c> height</c><00:01:06.920><c> manually</c><00:01:07.549><c> or</c><00:01:08.509><c> use</c><00:01:09.290><c> the</c>

00:01:09.490 --> 00:01:09.500 align:start position:0%
adjust the height manually or use the
 

00:01:09.500 --> 00:01:12.969 align:start position:0%
adjust the height manually or use the
format<00:01:09.920><c> command</c><00:01:10.100><c> to</c><00:01:10.759><c> auto</c><00:01:10.970><c> fit</c><00:01:11.299><c> or</c><00:01:12.229><c> specify</c>

00:01:12.969 --> 00:01:12.979 align:start position:0%
format command to auto fit or specify
 

00:01:12.979 --> 00:01:17.050 align:start position:0%
format command to auto fit or specify
the<00:01:13.040><c> height</c><00:01:15.130><c> now</c><00:01:16.130><c> I</c><00:01:16.159><c> need</c><00:01:16.490><c> to</c><00:01:16.640><c> add</c><00:01:16.789><c> another</c>

00:01:17.050 --> 00:01:17.060 align:start position:0%
the height now I need to add another
 

00:01:17.060 --> 00:01:19.419 align:start position:0%
the height now I need to add another
name<00:01:17.329><c> to</c><00:01:17.509><c> this</c><00:01:17.630><c> contact</c><00:01:18.140><c> list</c><00:01:18.439><c> I'd</c><00:01:18.920><c> like</c><00:01:19.280><c> to</c>

00:01:19.419 --> 00:01:19.429 align:start position:0%
name to this contact list I'd like to
 

00:01:19.429 --> 00:01:22.779 align:start position:0%
name to this contact list I'd like to
put<00:01:19.609><c> it</c><00:01:19.700><c> in</c><00:01:19.850><c> between</c><00:01:19.969><c> rows</c><00:01:20.479><c> 3</c><00:01:20.869><c> &amp;</c><00:01:21.140><c> 4</c><00:01:21.649><c> to</c><00:01:22.369><c> insert</c><00:01:22.759><c> a</c>

00:01:22.779 --> 00:01:22.789 align:start position:0%
put it in between rows 3 &amp; 4 to insert a
 

00:01:22.789 --> 00:01:24.849 align:start position:0%
put it in between rows 3 &amp; 4 to insert a
new<00:01:23.060><c> row</c><00:01:23.299><c> all</c><00:01:23.539><c> you</c><00:01:23.780><c> have</c><00:01:23.960><c> to</c><00:01:24.079><c> do</c><00:01:24.229><c> is</c><00:01:24.409><c> select</c><00:01:24.590><c> the</c>

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

00:01:24.859 --> 00:01:27.010 align:start position:0%
new row all you have to do is select the
row<00:01:25.130><c> below</c><00:01:25.429><c> where</c><00:01:25.939><c> you</c><00:01:26.060><c> want</c><00:01:26.329><c> the</c><00:01:26.479><c> new</c><00:01:26.659><c> one</c><00:01:26.689><c> to</c>

00:01:27.010 --> 00:01:27.020 align:start position:0%
row below where you want the new one to
 

00:01:27.020 --> 00:01:31.569 align:start position:0%
row below where you want the new one to
appear<00:01:27.460><c> now</c><00:01:28.460><c> click</c><00:01:28.819><c> the</c><00:01:28.999><c> insert</c><00:01:29.389><c> command</c><00:01:30.579><c> your</c>

00:01:31.569 --> 00:01:31.579 align:start position:0%
appear now click the insert command your
 

00:01:31.579 --> 00:01:33.580 align:start position:0%
appear now click the insert command your
row<00:01:31.789><c> appears</c><00:01:32.240><c> along</c><00:01:32.689><c> with</c><00:01:32.719><c> the</c><00:01:32.990><c> insert</c>

00:01:33.580 --> 00:01:33.590 align:start position:0%
row appears along with the insert
 

00:01:33.590 --> 00:01:35.440 align:start position:0%
row appears along with the insert
options<00:01:34.100><c> button</c><00:01:34.429><c> which</c><00:01:34.789><c> lets</c><00:01:35.060><c> you</c><00:01:35.179><c> choose</c><00:01:35.389><c> the</c>

00:01:35.440 --> 00:01:35.450 align:start position:0%
options button which lets you choose the
 

00:01:35.450 --> 00:01:37.870 align:start position:0%
options button which lets you choose the
formatting<00:01:36.139><c> for</c><00:01:36.319><c> your</c><00:01:36.380><c> new</c><00:01:36.619><c> cells</c><00:01:36.920><c> I'm</c><00:01:37.579><c> going</c>

00:01:37.870 --> 00:01:37.880 align:start position:0%
formatting for your new cells I'm going
 

00:01:37.880 --> 00:01:39.459 align:start position:0%
formatting for your new cells I'm going
to<00:01:37.969><c> keep</c><00:01:38.119><c> the</c><00:01:38.270><c> default</c><00:01:38.689><c> which</c><00:01:38.899><c> is</c><00:01:38.929><c> the</c><00:01:39.109><c> same</c>

00:01:39.459 --> 00:01:39.469 align:start position:0%
to keep the default which is the same
 

00:01:39.469 --> 00:01:45.940 align:start position:0%
to keep the default which is the same
formatting<00:01:40.039><c> as</c><00:01:40.159><c> the</c><00:01:40.310><c> row</c><00:01:40.459><c> above</c><00:01:44.469><c> the</c><00:01:45.469><c> process</c>

00:01:45.940 --> 00:01:45.950 align:start position:0%
formatting as the row above the process
 

00:01:45.950 --> 00:01:47.440 align:start position:0%
formatting as the row above the process
is<00:01:46.130><c> similar</c><00:01:46.369><c> for</c><00:01:46.549><c> inserting</c><00:01:47.209><c> a</c><00:01:47.270><c> new</c><00:01:47.420><c> column</c>

00:01:47.440 --> 00:01:47.450 align:start position:0%
is similar for inserting a new column
 

00:01:47.450 --> 00:01:50.230 align:start position:0%
is similar for inserting a new column
just<00:01:48.069><c> select</c><00:01:49.069><c> the</c><00:01:49.159><c> column</c><00:01:49.520><c> to</c><00:01:49.670><c> the</c><00:01:49.700><c> right</c><00:01:49.819><c> of</c>

00:01:50.230 --> 00:01:50.240 align:start position:0%
just select the column to the right of
 

00:01:50.240 --> 00:01:52.480 align:start position:0%
just select the column to the right of
where<00:01:50.450><c> you</c><00:01:50.569><c> want</c><00:01:50.780><c> the</c><00:01:50.899><c> new</c><00:01:51.020><c> one</c><00:01:51.049><c> to</c><00:01:51.350><c> go</c><00:01:51.530><c> click</c>

00:01:52.480 --> 00:01:52.490 align:start position:0%
where you want the new one to go click
 

00:01:52.490 --> 00:01:55.480 align:start position:0%
where you want the new one to go click
the<00:01:52.639><c> insert</c><00:01:53.090><c> command</c><00:01:53.509><c> and</c><00:01:53.920><c> the</c><00:01:54.920><c> new</c><00:01:55.069><c> column</c>

00:01:55.480 --> 00:01:55.490 align:start position:0%
the insert command and the new column
 

00:01:55.490 --> 00:01:58.209 align:start position:0%
the insert command and the new column
will<00:01:55.609><c> appear</c><00:01:55.939><c> to</c><00:01:56.060><c> the</c><00:01:56.149><c> left</c><00:01:56.770><c> always</c><00:01:57.770><c> make</c><00:01:58.009><c> sure</c>

00:01:58.209 --> 00:01:58.219 align:start position:0%
will appear to the left always make sure
 

00:01:58.219 --> 00:02:00.459 align:start position:0%
will appear to the left always make sure
you<00:01:58.369><c> select</c><00:01:58.579><c> the</c><00:01:58.850><c> entire</c><00:01:59.299><c> row</c><00:01:59.630><c> or</c><00:01:59.869><c> column</c><00:01:59.929><c> by</c>

00:02:00.459 --> 00:02:00.469 align:start position:0%
you select the entire row or column by
 

00:02:00.469 --> 00:02:01.989 align:start position:0%
you select the entire row or column by
clicking<00:02:00.529><c> the</c><00:02:00.920><c> heading</c><00:02:01.310><c> when</c><00:02:01.579><c> you're</c><00:02:01.729><c> getting</c>

00:02:01.989 --> 00:02:01.999 align:start position:0%
clicking the heading when you're getting
 

00:02:01.999 --> 00:02:04.149 align:start position:0%
clicking the heading when you're getting
ready<00:02:02.179><c> to</c><00:02:02.270><c> insert</c><00:02:02.719><c> a</c><00:02:02.779><c> new</c><00:02:02.990><c> one</c><00:02:03.200><c> otherwise</c>

00:02:04.149 --> 00:02:04.159 align:start position:0%
ready to insert a new one otherwise
 

00:02:04.159 --> 00:02:06.999 align:start position:0%
ready to insert a new one otherwise
you'll<00:02:04.490><c> only</c><00:02:04.850><c> insert</c><00:02:05.179><c> a</c><00:02:05.240><c> cell</c><00:02:05.659><c> this</c><00:02:06.499><c> is</c><00:02:06.679><c> also</c><00:02:06.979><c> a</c>

00:02:06.999 --> 00:02:07.009 align:start position:0%
you'll only insert a cell this is also a
 

00:02:07.009 --> 00:02:08.859 align:start position:0%
you'll only insert a cell this is also a
good<00:02:07.279><c> rule</c><00:02:07.459><c> to</c><00:02:07.490><c> remember</c><00:02:08.119><c> for</c><00:02:08.360><c> deleting</c>

00:02:08.859 --> 00:02:08.869 align:start position:0%
good rule to remember for deleting
 

00:02:08.869 --> 00:02:10.870 align:start position:0%
good rule to remember for deleting
columns<00:02:09.080><c> and</c><00:02:09.410><c> rows</c><00:02:09.590><c> you'll</c><00:02:10.369><c> want</c><00:02:10.580><c> to</c><00:02:10.729><c> make</c>

00:02:10.870 --> 00:02:10.880 align:start position:0%
columns and rows you'll want to make
 

00:02:10.880 --> 00:02:13.600 align:start position:0%
columns and rows you'll want to make
your<00:02:11.090><c> entire</c><00:02:11.360><c> selection</c><00:02:12.010><c> then</c><00:02:13.010><c> click</c><00:02:13.430><c> the</c>

00:02:13.600 --> 00:02:13.610 align:start position:0%
your entire selection then click the
 

00:02:13.610 --> 00:02:15.620 align:start position:0%
your entire selection then click the
delete<00:02:13.760><c> command</c>

00:02:15.620 --> 00:02:15.630 align:start position:0%
delete command
 

00:02:15.630 --> 00:02:17.660 align:start position:0%
delete command
now<00:02:15.840><c> let's</c><00:02:16.110><c> take</c><00:02:16.290><c> a</c><00:02:16.350><c> look</c><00:02:16.620><c> at</c><00:02:16.860><c> wrapping</c><00:02:17.370><c> text</c>

00:02:17.660 --> 00:02:17.670 align:start position:0%
now let's take a look at wrapping text
 

00:02:17.670 --> 00:02:19.640 align:start position:0%
now let's take a look at wrapping text
which<00:02:18.150><c> is</c><00:02:18.180><c> one</c><00:02:18.540><c> way</c><00:02:18.720><c> of</c><00:02:18.750><c> addressing</c><00:02:19.140><c> cells</c>

00:02:19.640 --> 00:02:19.650 align:start position:0%
which is one way of addressing cells
 

00:02:19.650 --> 00:02:21.230 align:start position:0%
which is one way of addressing cells
that<00:02:19.890><c> contain</c><00:02:20.280><c> more</c><00:02:20.490><c> text</c><00:02:20.940><c> than</c><00:02:21.090><c> they</c><00:02:21.180><c> can</c>

00:02:21.230 --> 00:02:21.240 align:start position:0%
that contain more text than they can
 

00:02:21.240 --> 00:02:24.200 align:start position:0%
that contain more text than they can
actually<00:02:21.540><c> display</c><00:02:22.100><c> for</c><00:02:23.100><c> example</c><00:02:23.130><c> I'd</c><00:02:23.820><c> like</c><00:02:23.850><c> to</c>

00:02:24.200 --> 00:02:24.210 align:start position:0%
actually display for example I'd like to
 

00:02:24.210 --> 00:02:26.480 align:start position:0%
actually display for example I'd like to
resize<00:02:24.360><c> my</c><00:02:24.990><c> column</c><00:02:25.350><c> of</c><00:02:25.470><c> addresses</c><00:02:25.980><c> to</c><00:02:26.190><c> about</c>

00:02:26.480 --> 00:02:26.490 align:start position:0%
resize my column of addresses to about
 

00:02:26.490 --> 00:02:29.030 align:start position:0%
resize my column of addresses to about
half<00:02:26.850><c> its</c><00:02:27.090><c> current</c><00:02:27.270><c> size</c><00:02:27.660><c> but</c><00:02:28.380><c> still</c><00:02:28.410><c> be</c><00:02:28.830><c> able</c>

00:02:29.030 --> 00:02:29.040 align:start position:0%
half its current size but still be able
 

00:02:29.040 --> 00:02:31.460 align:start position:0%
half its current size but still be able
to<00:02:29.160><c> see</c><00:02:29.370><c> the</c><00:02:29.550><c> contents</c><00:02:30.120><c> the</c><00:02:30.990><c> wrap</c><00:02:31.230><c> text</c>

00:02:31.460 --> 00:02:31.470 align:start position:0%
to see the contents the wrap text
 

00:02:31.470 --> 00:02:33.260 align:start position:0%
to see the contents the wrap text
command<00:02:31.680><c> can</c><00:02:32.190><c> help</c><00:02:32.430><c> by</c><00:02:32.610><c> displaying</c><00:02:33.060><c> the</c><00:02:33.150><c> text</c>

00:02:33.260 --> 00:02:33.270 align:start position:0%
command can help by displaying the text
 

00:02:33.270 --> 00:02:36.710 align:start position:0%
command can help by displaying the text
on<00:02:33.690><c> multiple</c><00:02:34.140><c> lines</c><00:02:34.350><c> just</c><00:02:35.340><c> click</c><00:02:35.610><c> and</c><00:02:35.820><c> the</c>

00:02:36.710 --> 00:02:36.720 align:start position:0%
on multiple lines just click and the
 

00:02:36.720 --> 00:02:38.920 align:start position:0%
on multiple lines just click and the
text<00:02:37.080><c> and</c><00:02:37.290><c> the</c><00:02:37.500><c> rows</c><00:02:37.680><c> adjust</c><00:02:38.160><c> automatically</c>

00:02:38.920 --> 00:02:38.930 align:start position:0%
text and the rows adjust automatically
 

00:02:38.930 --> 00:02:41.360 align:start position:0%
text and the rows adjust automatically
now<00:02:39.930><c> for</c><00:02:40.290><c> the</c><00:02:40.380><c> finishing</c><00:02:40.770><c> touch</c>

00:02:41.360 --> 00:02:41.370 align:start position:0%
now for the finishing touch
 

00:02:41.370 --> 00:02:43.460 align:start position:0%
now for the finishing touch
combining<00:02:42.030><c> the</c><00:02:42.150><c> cells</c><00:02:42.390><c> in</c><00:02:42.630><c> the</c><00:02:42.780><c> top</c><00:02:42.990><c> row</c><00:02:43.200><c> of</c><00:02:43.320><c> my</c>

00:02:43.460 --> 00:02:43.470 align:start position:0%
combining the cells in the top row of my
 

00:02:43.470 --> 00:02:45.500 align:start position:0%
combining the cells in the top row of my
spreadsheet<00:02:43.800><c> so</c><00:02:44.280><c> the</c><00:02:44.430><c> title</c><00:02:44.730><c> can</c><00:02:44.850><c> be</c><00:02:44.910><c> centered</c>

00:02:45.500 --> 00:02:45.510 align:start position:0%
spreadsheet so the title can be centered
 

00:02:45.510 --> 00:02:48.710 align:start position:0%
spreadsheet so the title can be centered
in<00:02:45.660><c> a</c><00:02:45.840><c> single</c><00:02:46.230><c> large</c><00:02:46.470><c> cell</c><00:02:46.830><c> to</c><00:02:47.640><c> do</c><00:02:47.790><c> this</c><00:02:47.970><c> select</c>

00:02:48.710 --> 00:02:48.720 align:start position:0%
in a single large cell to do this select
 

00:02:48.720 --> 00:02:50.980 align:start position:0%
in a single large cell to do this select
the<00:02:49.080><c> cells</c><00:02:49.320><c> you</c><00:02:49.500><c> want</c><00:02:49.530><c> to</c><00:02:49.740><c> merge</c><00:02:49.980><c> together</c>

00:02:50.980 --> 00:02:50.990 align:start position:0%
the cells you want to merge together
 

00:02:50.990 --> 00:02:53.890 align:start position:0%
the cells you want to merge together
then<00:02:51.990><c> click</c><00:02:52.380><c> the</c><00:02:52.590><c> merge</c><00:02:52.860><c> &amp;</c><00:02:53.160><c> Center</c><00:02:53.520><c> command</c>

00:02:53.890 --> 00:02:53.900 align:start position:0%
then click the merge &amp; Center command
 

00:02:53.900 --> 00:02:57.530 align:start position:0%
then click the merge &amp; Center command
there<00:02:54.900><c> that's</c><00:02:55.320><c> perfect</c><00:02:55.860><c> to</c><00:02:56.790><c> access</c><00:02:57.210><c> more</c>

00:02:57.530 --> 00:02:57.540 align:start position:0%
there that's perfect to access more
 

00:02:57.540 --> 00:02:59.870 align:start position:0%
there that's perfect to access more
merge<00:02:57.840><c> options</c><00:02:58.290><c> open</c><00:02:58.830><c> the</c><00:02:59.160><c> drop</c><00:02:59.370><c> down</c><00:02:59.550><c> menu</c>

00:02:59.870 --> 00:02:59.880 align:start position:0%
merge options open the drop down menu
 

00:02:59.880 --> 00:03:01.970 align:start position:0%
merge options open the drop down menu
here<00:02:59.910><c> you</c><00:03:00.840><c> can</c><00:03:01.050><c> merge</c><00:03:01.200><c> your</c><00:03:01.410><c> cells</c><00:03:01.650><c> across</c>

00:03:01.970 --> 00:03:01.980 align:start position:0%
here you can merge your cells across
 

00:03:01.980 --> 00:03:04.640 align:start position:0%
here you can merge your cells across
creating<00:03:02.970><c> merged</c><00:03:03.210><c> rows</c><00:03:03.570><c> instead</c><00:03:03.960><c> of</c><00:03:04.110><c> a</c><00:03:04.260><c> single</c>

00:03:04.640 --> 00:03:04.650 align:start position:0%
creating merged rows instead of a single
 

00:03:04.650 --> 00:03:06.440 align:start position:0%
creating merged rows instead of a single
large<00:03:04.830><c> cell</c><00:03:05.160><c> if</c><00:03:05.400><c> you</c><00:03:05.610><c> have</c><00:03:05.790><c> multiple</c><00:03:06.180><c> cells</c>

00:03:06.440 --> 00:03:06.450 align:start position:0%
large cell if you have multiple cells
 

00:03:06.450 --> 00:03:08.870 align:start position:0%
large cell if you have multiple cells
selected<00:03:06.990><c> you</c><00:03:07.740><c> can</c><00:03:07.860><c> also</c><00:03:08.040><c> merge</c><00:03:08.460><c> without</c>

00:03:08.870 --> 00:03:08.880 align:start position:0%
selected you can also merge without
 

00:03:08.880 --> 00:03:12.070 align:start position:0%
selected you can also merge without
centering<00:03:09.480><c> or</c><00:03:10.200><c> split</c><00:03:10.890><c> your</c><00:03:11.040><c> cells</c><00:03:11.310><c> up</c><00:03:11.520><c> again</c>

00:03:12.070 --> 00:03:12.080 align:start position:0%
centering or split your cells up again
 

00:03:12.080 --> 00:03:14.480 align:start position:0%
centering or split your cells up again
the<00:03:13.080><c> best</c><00:03:13.350><c> way</c><00:03:13.560><c> to</c><00:03:13.590><c> learn</c><00:03:13.800><c> about</c><00:03:13.950><c> merging</c>

00:03:14.480 --> 00:03:14.490 align:start position:0%
the best way to learn about merging
 

00:03:14.490 --> 00:03:17.060 align:start position:0%
the best way to learn about merging
cells<00:03:14.790><c> wrapping</c><00:03:15.510><c> text</c><00:03:15.750><c> and</c><00:03:16.050><c> inserting</c><00:03:16.920><c> and</c>

00:03:17.060 --> 00:03:17.070 align:start position:0%
cells wrapping text and inserting and
 

00:03:17.070 --> 00:03:19.280 align:start position:0%
cells wrapping text and inserting and
deleting<00:03:17.100><c> columns</c><00:03:17.700><c> and</c><00:03:18.030><c> rows</c><00:03:18.210><c> is</c><00:03:18.510><c> to</c><00:03:18.870><c> practice</c>

00:03:19.280 --> 00:03:19.290 align:start position:0%
deleting columns and rows is to practice
 

00:03:19.290 --> 00:03:21.500 align:start position:0%
deleting columns and rows is to practice
so<00:03:19.950><c> give</c><00:03:20.160><c> it</c><00:03:20.190><c> a</c><00:03:20.340><c> try</c><00:03:20.580><c> with</c><00:03:20.640><c> your</c><00:03:20.970><c> own</c><00:03:21.150><c> Excel</c>

00:03:21.500 --> 00:03:21.510 align:start position:0%
so give it a try with your own Excel
 

00:03:21.510 --> 00:03:27.740 align:start position:0%
so give it a try with your own Excel
spreadsheet<00:03:21.990><c> and</c><00:03:22.080><c> have</c><00:03:22.500><c> fun</c><00:03:26.390><c> like</c><00:03:27.390><c> what</c><00:03:27.570><c> you</c>

00:03:27.740 --> 00:03:27.750 align:start position:0%
spreadsheet and have fun like what you
 

00:03:27.750 --> 00:03:31.430 align:start position:0%
spreadsheet and have fun like what you
just<00:03:27.780><c> saw</c><00:03:28.610><c> rate</c><00:03:29.610><c> it</c><00:03:29.790><c> add</c><00:03:30.300><c> a</c><00:03:30.360><c> comment</c><00:03:30.690><c> subscribe</c>

00:03:31.430 --> 00:03:31.440 align:start position:0%
just saw rate it add a comment subscribe
 

00:03:31.440 --> 00:03:33.170 align:start position:0%
just saw rate it add a comment subscribe
to<00:03:31.860><c> our</c><00:03:31.980><c> Channel</c>

00:03:33.170 --> 00:03:33.180 align:start position:0%
to our Channel
 

00:03:33.180 --> 00:03:35.110 align:start position:0%
to our Channel
the<00:03:33.450><c> freedom</c><00:03:33.900><c> to</c><00:03:34.049><c> learn</c>

00:03:35.110 --> 00:03:35.120 align:start position:0%
the freedom to learn
 

00:03:35.120 --> 00:03:40.570 align:start position:0%
the freedom to learn
what<00:03:35.840><c> you</c><00:03:36.020><c> want</c><00:03:36.520><c> when</c><00:03:37.520><c> you</c><00:03:37.550><c> want</c><00:03:39.580><c> absolutely</c>

00:03:40.570 --> 00:03:40.580 align:start position:0%
what you want when you want absolutely
 

00:03:40.580 --> 00:03:47.709 align:start position:0%
what you want when you want absolutely
free<00:03:44.110><c> GCF</c><00:03:45.110><c> learn</c><00:03:45.680><c> free.org</c>