WEBVTT
Kind: captions
Language: en

00:00:00.210 --> 00:00:03.290 align:start position:0%
 
in<00:00:00.860><c> Google</c><00:00:01.860><c> sheets</c><00:00:02.159><c> every</c><00:00:02.700><c> project</c><00:00:02.939><c> is</c>

00:00:03.290 --> 00:00:03.300 align:start position:0%
in Google sheets every project is
 

00:00:03.300 --> 00:00:04.849 align:start position:0%
in Google sheets every project is
different<00:00:03.330><c> that</c><00:00:04.110><c> means</c><00:00:04.259><c> you</c><00:00:04.440><c> may</c><00:00:04.620><c> want</c><00:00:04.830><c> to</c>

00:00:04.849 --> 00:00:04.859 align:start position:0%
different that means you may want to
 

00:00:04.859 --> 00:00:06.980 align:start position:0%
different that means you may want to
modify<00:00:05.069><c> certain</c><00:00:05.490><c> things</c><00:00:05.910><c> including</c><00:00:06.629><c> the</c><00:00:06.750><c> size</c>

00:00:06.980 --> 00:00:06.990 align:start position:0%
modify certain things including the size
 

00:00:06.990 --> 00:00:09.169 align:start position:0%
modify certain things including the size
and<00:00:07.379><c> layout</c><00:00:07.529><c> of</c><00:00:07.830><c> your</c><00:00:07.859><c> cells</c><00:00:08.250><c> to</c><00:00:08.790><c> better</c><00:00:08.970><c> fit</c>

00:00:09.169 --> 00:00:09.179 align:start position:0%
and layout of your cells to better fit
 

00:00:09.179 --> 00:00:11.780 align:start position:0%
and layout of your cells to better fit
the<00:00:09.240><c> data</c><00:00:09.480><c> you're</c><00:00:09.780><c> working</c><00:00:09.809><c> with</c><00:00:10.349><c> for</c><00:00:11.250><c> example</c>

00:00:11.780 --> 00:00:11.790 align:start position:0%
the data you're working with for example
 

00:00:11.790 --> 00:00:14.509 align:start position:0%
the data you're working with for example
this<00:00:12.210><c> column</c><00:00:12.599><c> has</c><00:00:12.809><c> already</c><00:00:13.259><c> been</c><00:00:13.440><c> resized</c><00:00:13.920><c> but</c>

00:00:14.509 --> 00:00:14.519 align:start position:0%
this column has already been resized but
 

00:00:14.519 --> 00:00:16.250 align:start position:0%
this column has already been resized but
not<00:00:14.670><c> quite</c><00:00:14.940><c> enough</c><00:00:15.059><c> a</c><00:00:15.480><c> couple</c><00:00:15.900><c> of</c><00:00:16.139><c> the</c>

00:00:16.250 --> 00:00:16.260 align:start position:0%
not quite enough a couple of the
 

00:00:16.260 --> 00:00:18.320 align:start position:0%
not quite enough a couple of the
addresses<00:00:16.590><c> are</c><00:00:16.980><c> still</c><00:00:17.340><c> getting</c><00:00:17.490><c> cut</c><00:00:17.820><c> off</c><00:00:17.850><c> I'm</c>

00:00:18.320 --> 00:00:18.330 align:start position:0%
addresses are still getting cut off I'm
 

00:00:18.330 --> 00:00:20.480 align:start position:0%
addresses are still getting cut off I'm
going<00:00:18.990><c> to</c><00:00:19.109><c> increase</c><00:00:19.470><c> the</c><00:00:19.650><c> width</c><00:00:19.830><c> a</c><00:00:20.039><c> little</c><00:00:20.369><c> bit</c>

00:00:20.480 --> 00:00:20.490 align:start position:0%
going to increase the width a little bit
 

00:00:20.490 --> 00:00:22.310 align:start position:0%
going to increase the width a little bit
more<00:00:20.760><c> by</c><00:00:21.029><c> positioning</c><00:00:21.600><c> my</c><00:00:21.750><c> mouse</c><00:00:21.930><c> over</c><00:00:22.170><c> the</c>

00:00:22.310 --> 00:00:22.320 align:start position:0%
more by positioning my mouse over the
 

00:00:22.320 --> 00:00:24.439 align:start position:0%
more by positioning my mouse over the
line<00:00:22.410><c> in</c><00:00:22.769><c> the</c><00:00:22.890><c> column</c><00:00:22.920><c> heading</c><00:00:23.519><c> then</c><00:00:24.060><c> clicking</c>

00:00:24.439 --> 00:00:24.449 align:start position:0%
line in the column heading then clicking
 

00:00:24.449 --> 00:00:26.839 align:start position:0%
line in the column heading then clicking
and<00:00:24.779><c> dragging</c><00:00:24.840><c> it</c><00:00:25.380><c> to</c><00:00:25.410><c> the</c><00:00:25.560><c> right</c><00:00:25.849><c> another</c>

00:00:26.839 --> 00:00:26.849 align:start position:0%
and dragging it to the right another
 

00:00:26.849 --> 00:00:29.630 align:start position:0%
and dragging it to the right another
option<00:00:27.330><c> is</c><00:00:27.510><c> to</c><00:00:27.539><c> auto</c><00:00:27.900><c> size</c><00:00:28.289><c> the</c><00:00:28.560><c> column</c><00:00:28.920><c> this</c>

00:00:29.630 --> 00:00:29.640 align:start position:0%
option is to auto size the column this
 

00:00:29.640 --> 00:00:31.609 align:start position:0%
option is to auto size the column this
will<00:00:29.880><c> automatically</c><00:00:30.630><c> adjust</c><00:00:30.929><c> the</c><00:00:31.050><c> width</c><00:00:31.320><c> so</c>

00:00:31.609 --> 00:00:31.619 align:start position:0%
will automatically adjust the width so
 

00:00:31.619 --> 00:00:33.440 align:start position:0%
will automatically adjust the width so
it<00:00:31.920><c> fits</c><00:00:32.309><c> the</c><00:00:32.460><c> contents</c><00:00:32.640><c> of</c><00:00:33.059><c> the</c><00:00:33.210><c> cells</c>

00:00:33.440 --> 00:00:33.450 align:start position:0%
it fits the contents of the cells
 

00:00:33.450 --> 00:00:36.020 align:start position:0%
it fits the contents of the cells
exactly<00:00:34.020><c> just</c><00:00:35.010><c> double</c><00:00:35.460><c> click</c><00:00:35.640><c> the</c><00:00:35.790><c> line</c>

00:00:36.020 --> 00:00:36.030 align:start position:0%
exactly just double click the line
 

00:00:36.030 --> 00:00:38.869 align:start position:0%
exactly just double click the line
instead<00:00:36.420><c> of</c><00:00:36.570><c> dragging</c><00:00:36.840><c> it</c><00:00:37.219><c> now</c><00:00:38.219><c> the</c><00:00:38.280><c> column</c><00:00:38.700><c> is</c>

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

00:00:38.879 --> 00:00:41.750 align:start position:0%
instead of dragging it now the column is
perfectly<00:00:39.120><c> sized</c><00:00:39.690><c> to</c><00:00:39.899><c> the</c><00:00:40.110><c> text</c><00:00:40.500><c> rows</c><00:00:41.430><c> work</c>

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

00:00:41.760 --> 00:00:44.030 align:start position:0%
perfectly sized to the text rows work
very<00:00:42.180><c> much</c><00:00:42.270><c> the</c><00:00:42.629><c> same</c><00:00:42.809><c> way</c><00:00:43.050><c> they</c><00:00:43.559><c> start</c><00:00:43.920><c> out</c>

00:00:44.030 --> 00:00:44.040 align:start position:0%
very much the same way they start out
 

00:00:44.040 --> 00:00:46.490 align:start position:0%
very much the same way they start out
auto<00:00:44.340><c> size</c><00:00:44.730><c> to</c><00:00:45.059><c> fit</c><00:00:45.239><c> your</c><00:00:45.329><c> text</c><00:00:45.870><c> but</c><00:00:46.230><c> you</c><00:00:46.260><c> can</c>

00:00:46.490 --> 00:00:46.500 align:start position:0%
auto size to fit your text but you can
 

00:00:46.500 --> 00:00:48.410 align:start position:0%
auto size to fit your text but you can
easily<00:00:46.739><c> adjust</c><00:00:47.070><c> their</c><00:00:47.520><c> height</c><00:00:47.730><c> by</c><00:00:48.000><c> clicking</c>

00:00:48.410 --> 00:00:48.420 align:start position:0%
easily adjust their height by clicking
 

00:00:48.420 --> 00:00:51.560 align:start position:0%
easily adjust their height by clicking
and<00:00:48.629><c> dragging</c><00:00:48.660><c> the</c><00:00:49.079><c> lines</c><00:00:50.120><c> sometimes</c><00:00:51.120><c> it's</c>

00:00:51.560 --> 00:00:51.570 align:start position:0%
and dragging the lines sometimes it's
 

00:00:51.570 --> 00:00:53.600 align:start position:0%
and dragging the lines sometimes it's
useful<00:00:51.960><c> to</c><00:00:51.989><c> be</c><00:00:52.110><c> able</c><00:00:52.440><c> to</c><00:00:52.559><c> resize</c><00:00:52.920><c> all</c><00:00:53.250><c> of</c><00:00:53.489><c> your</c>

00:00:53.600 --> 00:00:53.610 align:start position:0%
useful to be able to resize all of your
 

00:00:53.610 --> 00:00:56.060 align:start position:0%
useful to be able to resize all of your
cells<00:00:53.879><c> at</c><00:00:54.059><c> once</c><00:00:54.110><c> for</c><00:00:55.110><c> example</c><00:00:55.590><c> in</c><00:00:55.800><c> this</c>

00:00:56.060 --> 00:00:56.070 align:start position:0%
cells at once for example in this
 

00:00:56.070 --> 00:00:58.040 align:start position:0%
cells at once for example in this
spreadsheet<00:00:56.699><c> I'd</c><00:00:56.910><c> like</c><00:00:57.180><c> to</c><00:00:57.329><c> make</c><00:00:57.480><c> all</c><00:00:57.690><c> of</c><00:00:57.899><c> my</c>

00:00:58.040 --> 00:00:58.050 align:start position:0%
spreadsheet I'd like to make all of my
 

00:00:58.050 --> 00:01:00.529 align:start position:0%
spreadsheet I'd like to make all of my
rows<00:00:58.320><c> the</c><00:00:58.620><c> exact</c><00:00:59.010><c> same</c><00:00:59.280><c> height</c><00:00:59.520><c> to</c><00:01:00.149><c> do</c><00:01:00.329><c> this</c>

00:01:00.529 --> 00:01:00.539 align:start position:0%
rows the exact same height to do this
 

00:01:00.539 --> 00:01:02.660 align:start position:0%
rows the exact same height to do this
click<00:01:01.140><c> the</c><00:01:01.199><c> Select</c><00:01:01.920><c> All</c><00:01:02.039><c> button</c>

00:01:02.660 --> 00:01:02.670 align:start position:0%
click the Select All button
 

00:01:02.670 --> 00:01:05.929 align:start position:0%
click the Select All button
just<00:01:03.059><c> below</c><00:01:03.359><c> the</c><00:01:03.510><c> formula</c><00:01:03.960><c> bar</c><00:01:04.250><c> then</c><00:01:05.250><c> resize</c><00:01:05.909><c> a</c>

00:01:05.929 --> 00:01:05.939 align:start position:0%
just below the formula bar then resize a
 

00:01:05.939 --> 00:01:08.660 align:start position:0%
just below the formula bar then resize a
row<00:01:06.090><c> it</c><00:01:06.540><c> doesn't</c><00:01:06.960><c> matter</c><00:01:07.110><c> which</c><00:01:07.350><c> one</c><00:01:07.560><c> and</c><00:01:07.830><c> the</c>

00:01:08.660 --> 00:01:08.670 align:start position:0%
row it doesn't matter which one and the
 

00:01:08.670 --> 00:01:10.010 align:start position:0%
row it doesn't matter which one and the
change<00:01:08.909><c> will</c><00:01:09.150><c> be</c><00:01:09.210><c> applied</c><00:01:09.630><c> to</c><00:01:09.869><c> the</c><00:01:09.990><c> entire</c>

00:01:10.010 --> 00:01:10.020 align:start position:0%
change will be applied to the entire
 

00:01:10.020 --> 00:01:13.160 align:start position:0%
change will be applied to the entire
spreadsheet<00:01:11.540><c> next</c><00:01:12.540><c> I</c><00:01:12.720><c> need</c><00:01:12.780><c> to</c><00:01:12.930><c> add</c><00:01:13.140><c> another</c>

00:01:13.160 --> 00:01:13.170 align:start position:0%
spreadsheet next I need to add another
 

00:01:13.170 --> 00:01:15.920 align:start position:0%
spreadsheet next I need to add another
row<00:01:13.680><c> to</c><00:01:13.740><c> this</c><00:01:13.979><c> list</c><00:01:14.310><c> I'd</c><00:01:15.090><c> like</c><00:01:15.360><c> to</c><00:01:15.479><c> put</c><00:01:15.659><c> it</c><00:01:15.780><c> in</c>

00:01:15.920 --> 00:01:15.930 align:start position:0%
row to this list I'd like to put it in
 

00:01:15.930 --> 00:01:19.460 align:start position:0%
row to this list I'd like to put it in
between<00:01:16.080><c> row</c><00:01:16.650><c> 6</c><00:01:17.009><c> and</c><00:01:17.310><c> row</c><00:01:17.670><c> 7</c><00:01:18.090><c> to</c><00:01:18.780><c> add</c><00:01:18.900><c> a</c><00:01:18.930><c> new</c><00:01:19.229><c> row</c>

00:01:19.460 --> 00:01:19.470 align:start position:0%
between row 6 and row 7 to add a new row
 

00:01:19.470 --> 00:01:22.039 align:start position:0%
between row 6 and row 7 to add a new row
all<00:01:19.830><c> you</c><00:01:20.159><c> have</c><00:01:20.310><c> to</c><00:01:20.460><c> do</c><00:01:20.580><c> is</c><00:01:20.700><c> right-click</c><00:01:21.049><c> then</c>

00:01:22.039 --> 00:01:22.049 align:start position:0%
all you have to do is right-click then
 

00:01:22.049 --> 00:01:24.830 align:start position:0%
all you have to do is right-click then
choose<00:01:22.110><c> from</c><00:01:22.619><c> the</c><00:01:22.710><c> menu</c><00:01:23.240><c> the</c><00:01:24.240><c> process</c><00:01:24.689><c> is</c>

00:01:24.830 --> 00:01:24.840 align:start position:0%
choose from the menu the process is
 

00:01:24.840 --> 00:01:27.020 align:start position:0%
choose from the menu the process is
similar<00:01:25.080><c> for</c><00:01:25.229><c> adding</c><00:01:25.710><c> a</c><00:01:25.770><c> new</c><00:01:25.920><c> column</c><00:01:26.340><c> again</c>

00:01:27.020 --> 00:01:27.030 align:start position:0%
similar for adding a new column again
 

00:01:27.030 --> 00:01:29.060 align:start position:0%
similar for adding a new column again
just<00:01:27.360><c> right-click</c><00:01:27.869><c> then</c><00:01:28.710><c> make</c><00:01:28.920><c> your</c>

00:01:29.060 --> 00:01:29.070 align:start position:0%
just right-click then make your
 

00:01:29.070 --> 00:01:31.070 align:start position:0%
just right-click then make your
selection

00:01:31.070 --> 00:01:31.080 align:start position:0%
selection
 

00:01:31.080 --> 00:01:33.950 align:start position:0%
selection
deleting<00:01:32.010><c> columns</c><00:01:32.190><c> and</c><00:01:32.550><c> rows</c><00:01:32.700><c> is</c><00:01:32.940><c> easy</c><00:01:33.150><c> first</c>

00:01:33.950 --> 00:01:33.960 align:start position:0%
deleting columns and rows is easy first
 

00:01:33.960 --> 00:01:35.840 align:start position:0%
deleting columns and rows is easy first
select<00:01:34.680><c> the</c><00:01:34.800><c> column</c><00:01:35.100><c> or</c><00:01:35.190><c> row</c><00:01:35.370><c> you</c><00:01:35.400><c> want</c><00:01:35.730><c> to</c>

00:01:35.840 --> 00:01:35.850 align:start position:0%
select the column or row you want to
 

00:01:35.850 --> 00:01:37.790 align:start position:0%
select the column or row you want to
delete<00:01:35.940><c> then</c><00:01:36.900><c> right-click</c><00:01:37.530><c> and</c><00:01:37.770><c> choose</c>

00:01:37.790 --> 00:01:37.800 align:start position:0%
delete then right-click and choose
 

00:01:37.800 --> 00:01:41.630 align:start position:0%
delete then right-click and choose
delete<00:01:38.790><c> column</c><00:01:39.600><c> from</c><00:01:39.780><c> the</c><00:01:39.930><c> menu</c><00:01:40.260><c> if</c><00:01:40.530><c> you</c><00:01:41.310><c> need</c>

00:01:41.630 --> 00:01:41.640 align:start position:0%
delete column from the menu if you need
 

00:01:41.640 --> 00:01:43.640 align:start position:0%
delete column from the menu if you need
to<00:01:41.790><c> move</c><00:01:41.970><c> a</c><00:01:42.210><c> column</c><00:01:42.390><c> or</c><00:01:42.660><c> row</c><00:01:42.900><c> start</c><00:01:43.530><c> by</c>

00:01:43.640 --> 00:01:43.650 align:start position:0%
to move a column or row start by
 

00:01:43.650 --> 00:01:46.460 align:start position:0%
to move a column or row start by
selecting<00:01:44.250><c> it</c><00:01:44.400><c> then</c><00:01:45.150><c> drag</c><00:01:45.630><c> and</c><00:01:45.930><c> drop</c><00:01:45.990><c> it</c><00:01:46.200><c> into</c>

00:01:46.460 --> 00:01:46.470 align:start position:0%
selecting it then drag and drop it into
 

00:01:46.470 --> 00:01:47.800 align:start position:0%
selecting it then drag and drop it into
place

00:01:47.800 --> 00:01:47.810 align:start position:0%
place
 

00:01:47.810 --> 00:01:49.910 align:start position:0%
place
let's<00:01:48.810><c> fast</c><00:01:49.080><c> forward</c><00:01:49.200><c> to</c><00:01:49.530><c> the</c><00:01:49.770><c> finished</c>

00:01:49.910 --> 00:01:49.920 align:start position:0%
let's fast forward to the finished
 

00:01:49.920 --> 00:01:52.760 align:start position:0%
let's fast forward to the finished
spreadsheet<00:01:50.900><c> next</c><00:01:51.900><c> I'd</c><00:01:52.080><c> like</c><00:01:52.260><c> to</c><00:01:52.410><c> take</c><00:01:52.530><c> a</c><00:01:52.590><c> look</c>

00:01:52.760 --> 00:01:52.770 align:start position:0%
spreadsheet next I'd like to take a look
 

00:01:52.770 --> 00:01:54.620 align:start position:0%
spreadsheet next I'd like to take a look
at<00:01:52.920><c> wrapping</c><00:01:53.340><c> text</c><00:01:53.610><c> which</c><00:01:54.090><c> is</c><00:01:54.120><c> one</c><00:01:54.420><c> of</c><00:01:54.540><c> the</c>

00:01:54.620 --> 00:01:54.630 align:start position:0%
at wrapping text which is one of the
 

00:01:54.630 --> 00:01:56.330 align:start position:0%
at wrapping text which is one of the
ways<00:01:54.810><c> of</c><00:01:54.990><c> addressing</c><00:01:55.470><c> cells</c><00:01:55.740><c> that</c><00:01:56.010><c> contain</c>

00:01:56.330 --> 00:01:56.340 align:start position:0%
ways of addressing cells that contain
 

00:01:56.340 --> 00:01:58.390 align:start position:0%
ways of addressing cells that contain
more<00:01:56.640><c> text</c><00:01:57.090><c> than</c><00:01:57.150><c> they</c><00:01:57.480><c> can</c><00:01:57.540><c> actually</c><00:01:57.840><c> display</c>

00:01:58.390 --> 00:01:58.400 align:start position:0%
more text than they can actually display
 

00:01:58.400 --> 00:02:01.610 align:start position:0%
more text than they can actually display
for<00:01:59.400><c> example</c><00:02:00.000><c> I'd</c><00:02:00.300><c> like</c><00:02:00.330><c> to</c><00:02:00.570><c> resize</c><00:02:00.720><c> my</c><00:02:01.260><c> column</c>

00:02:01.610 --> 00:02:01.620 align:start position:0%
for example I'd like to resize my column
 

00:02:01.620 --> 00:02:03.320 align:start position:0%
for example I'd like to resize my column
of<00:02:01.710><c> addresses</c><00:02:02.190><c> to</c><00:02:02.220><c> about</c><00:02:02.640><c> half</c><00:02:02.910><c> its</c><00:02:03.150><c> current</c>

00:02:03.320 --> 00:02:03.330 align:start position:0%
of addresses to about half its current
 

00:02:03.330 --> 00:02:05.270 align:start position:0%
of addresses to about half its current
size<00:02:03.540><c> but</c><00:02:04.260><c> still</c><00:02:04.560><c> be</c><00:02:04.680><c> able</c><00:02:04.800><c> to</c><00:02:04.920><c> see</c><00:02:05.160><c> the</c>

00:02:05.270 --> 00:02:05.280 align:start position:0%
size but still be able to see the
 

00:02:05.280 --> 00:02:07.760 align:start position:0%
size but still be able to see the
contents<00:02:05.850><c> we</c><00:02:06.570><c> can</c><00:02:06.720><c> do</c><00:02:06.870><c> this</c><00:02:07.050><c> by</c><00:02:07.290><c> using</c><00:02:07.350><c> the</c>

00:02:07.760 --> 00:02:07.770 align:start position:0%
contents we can do this by using the
 

00:02:07.770 --> 00:02:11.480 align:start position:0%
contents we can do this by using the
wrap<00:02:08.010><c> text</c><00:02:08.310><c> button</c><00:02:08.700><c> on</c><00:02:08.820><c> the</c><00:02:08.940><c> toolbar</c><00:02:09.179><c> now</c><00:02:10.490><c> the</c>

00:02:11.480 --> 00:02:11.490 align:start position:0%
wrap text button on the toolbar now the
 

00:02:11.490 --> 00:02:14.510 align:start position:0%
wrap text button on the toolbar now the
text<00:02:11.970><c> is</c><00:02:12.030><c> on</c><00:02:12.270><c> multiple</c><00:02:12.510><c> lines</c><00:02:13.250><c> another</c><00:02:14.250><c> useful</c>

00:02:14.510 --> 00:02:14.520 align:start position:0%
text is on multiple lines another useful
 

00:02:14.520 --> 00:02:16.340 align:start position:0%
text is on multiple lines another useful
feature<00:02:14.850><c> for</c><00:02:15.060><c> spreadsheets</c><00:02:15.600><c> with</c><00:02:16.020><c> lots</c><00:02:16.230><c> of</c>

00:02:16.340 --> 00:02:16.350 align:start position:0%
feature for spreadsheets with lots of
 

00:02:16.350 --> 00:02:18.440 align:start position:0%
feature for spreadsheets with lots of
data<00:02:16.560><c> is</c><00:02:16.830><c> the</c><00:02:17.070><c> ability</c><00:02:17.340><c> to</c><00:02:17.550><c> freeze</c><00:02:18.000><c> certain</c>

00:02:18.440 --> 00:02:18.450 align:start position:0%
data is the ability to freeze certain
 

00:02:18.450 --> 00:02:20.990 align:start position:0%
data is the ability to freeze certain
rows<00:02:18.720><c> or</c><00:02:18.990><c> columns</c><00:02:19.020><c> it</c><00:02:19.650><c> works</c><00:02:20.340><c> just</c><00:02:20.820><c> like</c><00:02:20.880><c> it</c>

00:02:20.990 --> 00:02:21.000 align:start position:0%
rows or columns it works just like it
 

00:02:21.000 --> 00:02:23.930 align:start position:0%
rows or columns it works just like it
sounds<00:02:21.270><c> the</c><00:02:22.050><c> cells</c><00:02:22.350><c> become</c><00:02:22.740><c> frozen</c><00:02:23.040><c> or</c><00:02:23.430><c> fixed</c>

00:02:23.930 --> 00:02:23.940 align:start position:0%
sounds the cells become frozen or fixed
 

00:02:23.940 --> 00:02:25.850 align:start position:0%
sounds the cells become frozen or fixed
in<00:02:24.060><c> place</c><00:02:24.209><c> allowing</c><00:02:25.020><c> you</c><00:02:25.200><c> to</c><00:02:25.320><c> scroll</c><00:02:25.800><c> through</c>

00:02:25.850 --> 00:02:25.860 align:start position:0%
in place allowing you to scroll through
 

00:02:25.860 --> 00:02:28.010 align:start position:0%
in place allowing you to scroll through
your<00:02:26.100><c> spreadsheet</c><00:02:26.760><c> and</c><00:02:26.790><c> still</c><00:02:27.360><c> see</c><00:02:27.570><c> important</c>

00:02:28.010 --> 00:02:28.020 align:start position:0%
your spreadsheet and still see important
 

00:02:28.020 --> 00:02:30.440 align:start position:0%
your spreadsheet and still see important
information<00:02:28.590><c> like</c><00:02:28.620><c> your</c><00:02:28.920><c> header</c><00:02:29.130><c> row</c><00:02:29.370><c> to</c><00:02:29.610><c> get</c>

00:02:30.440 --> 00:02:30.450 align:start position:0%
information like your header row to get
 

00:02:30.450 --> 00:02:33.740 align:start position:0%
information like your header row to get
started<00:02:30.959><c> open</c><00:02:31.110><c> the</c><00:02:31.680><c> View</c><00:02:31.950><c> menu</c><00:02:32.390><c> select</c><00:02:33.390><c> freeze</c>

00:02:33.740 --> 00:02:33.750 align:start position:0%
started open the View menu select freeze
 

00:02:33.750 --> 00:02:36.890 align:start position:0%
started open the View menu select freeze
then<00:02:34.680><c> choose</c><00:02:35.100><c> the</c><00:02:35.310><c> option</c><00:02:35.700><c> you</c><00:02:35.820><c> want</c><00:02:36.000><c> in</c><00:02:36.269><c> this</c>

00:02:36.890 --> 00:02:36.900 align:start position:0%
then choose the option you want in this
 

00:02:36.900 --> 00:02:39.080 align:start position:0%
then choose the option you want in this
example<00:02:37.260><c> I</c><00:02:37.560><c> want</c><00:02:37.800><c> to</c><00:02:37.890><c> freeze</c><00:02:38.190><c> the</c><00:02:38.430><c> first</c><00:02:38.459><c> two</c>

00:02:39.080 --> 00:02:39.090 align:start position:0%
example I want to freeze the first two
 

00:02:39.090 --> 00:02:41.930 align:start position:0%
example I want to freeze the first two
rows<00:02:39.420><c> the</c><00:02:40.110><c> title</c><00:02:40.500><c> and</c><00:02:40.739><c> the</c><00:02:40.830><c> header</c><00:02:41.040><c> so</c><00:02:41.670><c> I'm</c>

00:02:41.930 --> 00:02:41.940 align:start position:0%
rows the title and the header so I'm
 

00:02:41.940 --> 00:02:45.830 align:start position:0%
rows the title and the header so I'm
going<00:02:42.239><c> to</c><00:02:42.330><c> choose</c><00:02:42.600><c> two</c><00:02:43.080><c> rows</c><00:02:44.269><c> now</c><00:02:45.269><c> the</c><00:02:45.330><c> top</c><00:02:45.660><c> two</c>

00:02:45.830 --> 00:02:45.840 align:start position:0%
going to choose two rows now the top two
 

00:02:45.840 --> 00:02:47.720 align:start position:0%
going to choose two rows now the top two
rows<00:02:45.870><c> will</c><00:02:46.440><c> stay</c><00:02:46.650><c> in</c><00:02:46.800><c> place</c><00:02:47.040><c> when</c><00:02:47.280><c> I</c><00:02:47.340><c> scroll</c>

00:02:47.720 --> 00:02:47.730 align:start position:0%
rows will stay in place when I scroll
 

00:02:47.730 --> 00:02:49.250 align:start position:0%
rows will stay in place when I scroll
through<00:02:47.760><c> the</c><00:02:48.060><c> rest</c><00:02:48.239><c> of</c><00:02:48.390><c> my</c><00:02:48.540><c> spreadsheet</c><00:02:49.080><c> a</c>

00:02:49.250 --> 00:02:49.260 align:start position:0%
through the rest of my spreadsheet a
 

00:02:49.260 --> 00:02:51.830 align:start position:0%
through the rest of my spreadsheet a
thin<00:02:49.980><c> gray</c><00:02:50.190><c> line</c><00:02:50.459><c> indicates</c><00:02:51.120><c> where</c><00:02:51.420><c> the</c><00:02:51.600><c> cells</c>

00:02:51.830 --> 00:02:51.840 align:start position:0%
thin gray line indicates where the cells
 

00:02:51.840 --> 00:02:54.530 align:start position:0%
thin gray line indicates where the cells
are<00:02:51.989><c> frozen</c><00:02:52.580><c> now</c><00:02:53.580><c> for</c><00:02:53.820><c> the</c><00:02:53.910><c> finishing</c><00:02:54.209><c> touch</c>

00:02:54.530 --> 00:02:54.540 align:start position:0%
are frozen now for the finishing touch
 

00:02:54.540 --> 00:02:56.900 align:start position:0%
are frozen now for the finishing touch
combining<00:02:55.350><c> the</c><00:02:55.530><c> cells</c><00:02:55.800><c> in</c><00:02:56.040><c> the</c><00:02:56.130><c> top</c><00:02:56.340><c> row</c><00:02:56.610><c> so</c>

00:02:56.900 --> 00:02:56.910 align:start position:0%
combining the cells in the top row so
 

00:02:56.910 --> 00:02:58.370 align:start position:0%
combining the cells in the top row so
the<00:02:57.060><c> title</c><00:02:57.300><c> of</c><00:02:57.480><c> my</c><00:02:57.540><c> spreadsheet</c><00:02:58.170><c> can</c><00:02:58.350><c> be</c>

00:02:58.370 --> 00:02:58.380 align:start position:0%
the title of my spreadsheet can be
 

00:02:58.380 --> 00:03:01.610 align:start position:0%
the title of my spreadsheet can be
centered<00:02:58.860><c> in</c><00:02:59.070><c> single</c><00:02:59.610><c> large</c><00:02:59.910><c> cell</c><00:03:00.330><c> to</c><00:03:01.260><c> do</c><00:03:01.440><c> this</c>

00:03:01.610 --> 00:03:01.620 align:start position:0%
centered in single large cell to do this
 

00:03:01.620 --> 00:03:04.640 align:start position:0%
centered in single large cell to do this
select<00:03:02.190><c> the</c><00:03:02.550><c> cells</c><00:03:02.790><c> you</c><00:03:02.880><c> want</c><00:03:03.090><c> to</c><00:03:03.209><c> merge</c><00:03:03.650><c> then</c>

00:03:04.640 --> 00:03:04.650 align:start position:0%
select the cells you want to merge then
 

00:03:04.650 --> 00:03:08.540 align:start position:0%
select the cells you want to merge then
click<00:03:04.950><c> merge</c><00:03:05.430><c> cells</c><00:03:05.910><c> on</c><00:03:06.239><c> the</c><00:03:06.450><c> toolbar</c><00:03:07.550><c> there</c>

00:03:08.540 --> 00:03:08.550 align:start position:0%
click merge cells on the toolbar there
 

00:03:08.550 --> 00:03:10.970 align:start position:0%
click merge cells on the toolbar there
that's<00:03:09.030><c> perfect</c><00:03:09.510><c> the</c><00:03:10.260><c> best</c><00:03:10.500><c> way</c><00:03:10.709><c> to</c><00:03:10.739><c> learn</c>

00:03:10.970 --> 00:03:10.980 align:start position:0%
that's perfect the best way to learn
 

00:03:10.980 --> 00:03:13.400 align:start position:0%
that's perfect the best way to learn
about<00:03:11.040><c> modifying</c><00:03:11.820><c> cells</c><00:03:12.239><c> freezing</c><00:03:13.050><c> rows</c><00:03:13.200><c> and</c>

00:03:13.400 --> 00:03:13.410 align:start position:0%
about modifying cells freezing rows and
 

00:03:13.410 --> 00:03:15.680 align:start position:0%
about modifying cells freezing rows and
columns<00:03:13.830><c> and</c><00:03:14.010><c> wrapping</c><00:03:14.489><c> text</c><00:03:14.730><c> is</c><00:03:15.000><c> to</c><00:03:15.239><c> practice</c>

00:03:15.680 --> 00:03:15.690 align:start position:0%
columns and wrapping text is to practice
 

00:03:15.690 --> 00:03:17.330 align:start position:0%
columns and wrapping text is to practice
so<00:03:16.200><c> the</c><00:03:16.320><c> next</c><00:03:16.500><c> time</c><00:03:16.709><c> you're</c><00:03:16.890><c> working</c><00:03:17.040><c> on</c>

00:03:17.330 --> 00:03:17.340 align:start position:0%
so the next time you're working on
 

00:03:17.340 --> 00:03:19.310 align:start position:0%
so the next time you're working on
something<00:03:17.670><c> look</c><00:03:18.300><c> for</c><00:03:18.510><c> ways</c><00:03:18.600><c> that</c><00:03:18.660><c> you</c><00:03:18.930><c> can</c><00:03:19.170><c> use</c>

00:03:19.310 --> 00:03:19.320 align:start position:0%
something look for ways that you can use
 

00:03:19.320 --> 00:03:21.140 align:start position:0%
something look for ways that you can use
these<00:03:19.530><c> techniques</c><00:03:19.980><c> to</c><00:03:20.280><c> improve</c><00:03:20.489><c> the</c><00:03:20.730><c> look</c><00:03:21.000><c> of</c>

00:03:21.140 --> 00:03:21.150 align:start position:0%
these techniques to improve the look of
 

00:03:21.150 --> 00:03:26.060 align:start position:0%
these techniques to improve the look of
your<00:03:21.209><c> spreadsheet</c>

00:03:26.060 --> 00:03:26.070 align:start position:0%
 
 

00:03:26.070 --> 00:03:29.790 align:start position:0%
 
GCF<00:03:27.070><c> global</c><00:03:27.720><c> creating</c><00:03:28.720><c> opportunities</c><00:03:29.410><c> for</c><00:03:29.740><c> a</c>

00:03:29.790 --> 00:03:29.800 align:start position:0%
GCF global creating opportunities for a
 

00:03:29.800 --> 00:03:32.310 align:start position:0%
GCF global creating opportunities for a
better<00:03:29.860><c> life</c>