WEBVTT
Kind: captions
Language: en

00:00:06.770 --> 00:00:09.919 align:start position:0%
 
now<00:00:07.770><c> that</c><00:00:07.980><c> our</c><00:00:08.099><c> table</c><00:00:08.429><c> is</c><00:00:08.700><c> formatted</c><00:00:09.389><c> let's</c>

00:00:09.919 --> 00:00:09.929 align:start position:0%
now that our table is formatted let's
 

00:00:09.929 --> 00:00:11.690 align:start position:0%
now that our table is formatted let's
take<00:00:10.200><c> a</c><00:00:10.230><c> look</c><00:00:10.590><c> at</c><00:00:10.679><c> some</c><00:00:10.889><c> of</c><00:00:11.010><c> our</c><00:00:11.130><c> text</c>

00:00:11.690 --> 00:00:11.700 align:start position:0%
take a look at some of our text
 

00:00:11.700 --> 00:00:14.419 align:start position:0%
take a look at some of our text
alignment<00:00:12.120><c> options</c><00:00:12.870><c> before</c><00:00:13.799><c> we</c><00:00:14.070><c> do</c><00:00:14.400><c> that</c>

00:00:14.419 --> 00:00:14.429 align:start position:0%
alignment options before we do that
 

00:00:14.429 --> 00:00:18.500 align:start position:0%
alignment options before we do that
let's<00:00:15.120><c> turn</c><00:00:15.420><c> off</c><00:00:15.719><c> filtering</c><00:00:16.470><c> and</c><00:00:16.850><c> Excel</c><00:00:17.850><c> every</c>

00:00:18.500 --> 00:00:18.510 align:start position:0%
let's turn off filtering and Excel every
 

00:00:18.510 --> 00:00:20.450 align:start position:0%
let's turn off filtering and Excel every
column<00:00:19.020><c> in</c><00:00:19.140><c> the</c><00:00:19.230><c> table</c><00:00:19.470><c> has</c><00:00:19.859><c> filtering</c>

00:00:20.450 --> 00:00:20.460 align:start position:0%
column in the table has filtering
 

00:00:20.460 --> 00:00:23.689 align:start position:0%
column in the table has filtering
enabled<00:00:21.060><c> in</c><00:00:21.300><c> the</c><00:00:21.990><c> header</c><00:00:22.260><c> row</c><00:00:22.380><c> so</c><00:00:23.369><c> that</c><00:00:23.519><c> you</c>

00:00:23.689 --> 00:00:23.699 align:start position:0%
enabled in the header row so that you
 

00:00:23.699 --> 00:00:26.210 align:start position:0%
enabled in the header row so that you
can<00:00:23.880><c> filter</c><00:00:24.150><c> or</c><00:00:24.510><c> sort</c><00:00:25.080><c> your</c><00:00:25.529><c> table</c><00:00:25.980><c> data</c>

00:00:26.210 --> 00:00:26.220 align:start position:0%
can filter or sort your table data
 

00:00:26.220 --> 00:00:28.609 align:start position:0%
can filter or sort your table data
without<00:00:27.119><c> having</c><00:00:27.570><c> to</c><00:00:27.720><c> go</c><00:00:27.869><c> through</c><00:00:28.140><c> a</c><00:00:28.170><c> lot</c><00:00:28.560><c> of</c>

00:00:28.609 --> 00:00:28.619 align:start position:0%
without having to go through a lot of
 

00:00:28.619 --> 00:00:31.849 align:start position:0%
without having to go through a lot of
extra<00:00:29.039><c> steps</c><00:00:29.340><c> to</c><00:00:29.699><c> do</c><00:00:30.599><c> this</c><00:00:30.840><c> we</c><00:00:31.349><c> can</c><00:00:31.529><c> just</c><00:00:31.560><c> go</c>

00:00:31.849 --> 00:00:31.859 align:start position:0%
extra steps to do this we can just go
 

00:00:31.859 --> 00:00:34.729 align:start position:0%
extra steps to do this we can just go
back<00:00:31.890><c> to</c><00:00:32.369><c> the</c><00:00:32.489><c> Home</c><00:00:32.669><c> tab</c><00:00:32.969><c> and</c><00:00:33.329><c> click</c><00:00:34.200><c> the</c><00:00:34.230><c> sort</c>

00:00:34.729 --> 00:00:34.739 align:start position:0%
back to the Home tab and click the sort
 

00:00:34.739 --> 00:00:37.580 align:start position:0%
back to the Home tab and click the sort
and<00:00:34.920><c> filter</c><00:00:34.980><c> command</c><00:00:35.820><c> and</c><00:00:36.120><c> select</c><00:00:37.079><c> filter</c>

00:00:37.580 --> 00:00:37.590 align:start position:0%
and filter command and select filter
 

00:00:37.590 --> 00:00:43.729 align:start position:0%
and filter command and select filter
from<00:00:38.190><c> the</c><00:00:38.250><c> list</c><00:00:40.879><c> now</c><00:00:41.899><c> over</c><00:00:42.899><c> in</c><00:00:43.050><c> the</c><00:00:43.170><c> alignment</c>

00:00:43.729 --> 00:00:43.739 align:start position:0%
from the list now over in the alignment
 

00:00:43.739 --> 00:00:45.950 align:start position:0%
from the list now over in the alignment
group<00:00:43.770><c> we</c><00:00:44.460><c> have</c><00:00:44.670><c> some</c><00:00:44.879><c> alignment</c><00:00:45.180><c> commands</c>

00:00:45.950 --> 00:00:45.960 align:start position:0%
group we have some alignment commands
 

00:00:45.960 --> 00:00:49.310 align:start position:0%
group we have some alignment commands
that<00:00:46.590><c> we</c><00:00:46.950><c> can</c><00:00:47.160><c> use</c><00:00:47.460><c> to</c><00:00:47.640><c> format</c><00:00:47.879><c> our</c><00:00:48.180><c> text</c><00:00:48.809><c> so</c>

00:00:49.310 --> 00:00:49.320 align:start position:0%
that we can use to format our text so
 

00:00:49.320 --> 00:00:52.119 align:start position:0%
that we can use to format our text so
our<00:00:49.500><c> table</c><00:00:49.800><c> really</c><00:00:50.309><c> looks</c><00:00:50.760><c> professional</c><00:00:51.539><c> I</c>

00:00:52.119 --> 00:00:52.129 align:start position:0%
our table really looks professional I
 

00:00:52.129 --> 00:00:55.459 align:start position:0%
our table really looks professional I
think<00:00:53.129><c> I</c><00:00:53.309><c> want</c><00:00:53.550><c> to</c><00:00:53.640><c> insert</c><00:00:54.030><c> another</c><00:00:54.420><c> row</c><00:00:54.570><c> with</c>

00:00:55.459 --> 00:00:55.469 align:start position:0%
think I want to insert another row with
 

00:00:55.469 --> 00:01:00.290 align:start position:0%
think I want to insert another row with
the<00:00:55.590><c> title</c><00:00:56.039><c> of</c><00:00:56.190><c> our</c><00:00:56.309><c> table</c><00:00:56.850><c> and</c><00:00:57.030><c> a</c><00:00:57.270><c> one</c><00:00:59.300><c> we'll</c>

00:01:00.290 --> 00:01:00.300 align:start position:0%
the title of our table and a one we'll
 

00:01:00.300 --> 00:01:01.279 align:start position:0%
the title of our table and a one we'll
call<00:01:00.660><c> this</c>

00:01:01.279 --> 00:01:01.289 align:start position:0%
call this
 

00:01:01.289 --> 00:01:04.579 align:start position:0%
call this
scoops<00:01:01.649><c> shop</c><00:01:02.129><c> inventory</c><00:01:03.110><c> you</c><00:01:04.110><c> know</c><00:01:04.260><c> that's</c>

00:01:04.579 --> 00:01:04.589 align:start position:0%
scoops shop inventory you know that's
 

00:01:04.589 --> 00:01:06.289 align:start position:0%
scoops shop inventory you know that's
the<00:01:04.769><c> name</c><00:01:04.949><c> of</c><00:01:05.100><c> my</c><00:01:05.250><c> ice</c><00:01:05.400><c> cream</c><00:01:05.729><c> shop</c>

00:01:06.289 --> 00:01:06.299 align:start position:0%
the name of my ice cream shop
 

00:01:06.299 --> 00:01:10.820 align:start position:0%
the name of my ice cream shop
I<00:01:08.299><c> want</c><00:01:09.299><c> this</c><00:01:09.420><c> title</c><00:01:09.689><c> to</c><00:01:09.900><c> appear</c><00:01:10.049><c> centered</c>

00:01:10.820 --> 00:01:10.830 align:start position:0%
I want this title to appear centered
 

00:01:10.830 --> 00:01:14.120 align:start position:0%
I want this title to appear centered
over<00:01:11.280><c> my</c><00:01:11.430><c> entire</c><00:01:11.850><c> table</c><00:01:12.479><c> so</c><00:01:13.320><c> I'll</c><00:01:13.650><c> just</c><00:01:13.920><c> select</c>

00:01:14.120 --> 00:01:14.130 align:start position:0%
over my entire table so I'll just select
 

00:01:14.130 --> 00:01:17.570 align:start position:0%
over my entire table so I'll just select
a1<00:01:14.549><c> through</c><00:01:15.210><c> g1</c><00:01:15.630><c> and</c><00:01:15.960><c> then</c><00:01:16.950><c> in</c><00:01:17.100><c> the</c><00:01:17.220><c> alignment</c>

00:01:17.570 --> 00:01:17.580 align:start position:0%
a1 through g1 and then in the alignment
 

00:01:17.580 --> 00:01:20.660 align:start position:0%
a1 through g1 and then in the alignment
group<00:01:18.270><c> I'll</c><00:01:18.570><c> select</c><00:01:19.380><c> the</c><00:01:19.770><c> merge</c><00:01:20.009><c> &amp;</c><00:01:20.369><c> Center</c>

00:01:20.660 --> 00:01:20.670 align:start position:0%
group I'll select the merge &amp; Center
 

00:01:20.670 --> 00:01:25.010 align:start position:0%
group I'll select the merge &amp; Center
command<00:01:22.250><c> now</c><00:01:23.250><c> my</c><00:01:23.490><c> title</c><00:01:23.970><c> appears</c><00:01:24.360><c> centered</c>

00:01:25.010 --> 00:01:25.020 align:start position:0%
command now my title appears centered
 

00:01:25.020 --> 00:01:28.010 align:start position:0%
command now my title appears centered
across<00:01:25.380><c> the</c><00:01:25.560><c> table</c><00:01:25.950><c> as</c><00:01:26.159><c> you</c><00:01:27.119><c> can</c><00:01:27.299><c> see</c><00:01:27.570><c> the</c>

00:01:28.010 --> 00:01:28.020 align:start position:0%
across the table as you can see the
 

00:01:28.020 --> 00:01:30.289 align:start position:0%
across the table as you can see the
column<00:01:28.500><c> markers</c><00:01:29.009><c> don't</c><00:01:29.340><c> appear</c><00:01:29.790><c> anymore</c><00:01:30.240><c> in</c>

00:01:30.289 --> 00:01:30.299 align:start position:0%
column markers don't appear anymore in
 

00:01:30.299 --> 00:01:33.020 align:start position:0%
column markers don't appear anymore in
Row<00:01:30.479><c> 1</c><00:01:30.780><c> which</c><00:01:31.470><c> indicates</c><00:01:32.070><c> those</c><00:01:32.340><c> cells</c><00:01:32.759><c> have</c>

00:01:33.020 --> 00:01:33.030 align:start position:0%
Row 1 which indicates those cells have
 

00:01:33.030 --> 00:01:35.990 align:start position:0%
Row 1 which indicates those cells have
been<00:01:33.150><c> merged</c><00:01:33.450><c> into</c><00:01:33.840><c> one</c><00:01:33.990><c> if</c><00:01:34.500><c> you</c><00:01:35.460><c> change</c><00:01:35.790><c> your</c>

00:01:35.990 --> 00:01:36.000 align:start position:0%
been merged into one if you change your
 

00:01:36.000 --> 00:01:38.420 align:start position:0%
been merged into one if you change your
minds<00:01:36.720><c> you</c><00:01:37.049><c> can</c><00:01:37.200><c> always</c><00:01:37.470><c> click</c><00:01:37.860><c> the</c><00:01:37.979><c> drop</c><00:01:38.400><c> down</c>

00:01:38.420 --> 00:01:38.430 align:start position:0%
minds you can always click the drop down
 

00:01:38.430 --> 00:01:41.260 align:start position:0%
minds you can always click the drop down
arrow<00:01:39.060><c> next</c><00:01:39.180><c> to</c><00:01:39.570><c> the</c><00:01:39.659><c> command</c><00:01:40.140><c> and</c><00:01:40.409><c> choose</c>

00:01:41.260 --> 00:01:41.270 align:start position:0%
arrow next to the command and choose
 

00:01:41.270 --> 00:01:45.980 align:start position:0%
arrow next to the command and choose
unmerge<00:01:42.270><c> cells</c><00:01:44.030><c> now</c><00:01:45.030><c> that</c><00:01:45.240><c> our</c><00:01:45.360><c> title</c><00:01:45.899><c> is</c>

00:01:45.980 --> 00:01:45.990 align:start position:0%
unmerge cells now that our title is
 

00:01:45.990 --> 00:01:48.440 align:start position:0%
unmerge cells now that our title is
centered<00:01:46.560><c> I'd</c><00:01:46.979><c> like</c><00:01:47.340><c> to</c><00:01:47.549><c> Center</c><00:01:47.909><c> my</c><00:01:48.030><c> column</c>

00:01:48.440 --> 00:01:48.450 align:start position:0%
centered I'd like to Center my column
 

00:01:48.450 --> 00:01:51.289 align:start position:0%
centered I'd like to Center my column
headings<00:01:49.250><c> first</c><00:01:50.250><c> I</c><00:01:50.520><c> just</c><00:01:50.640><c> need</c><00:01:51.000><c> to</c><00:01:51.119><c> select</c>

00:01:51.289 --> 00:01:51.299 align:start position:0%
headings first I just need to select
 

00:01:51.299 --> 00:01:53.510 align:start position:0%
headings first I just need to select
those<00:01:51.750><c> cells</c><00:01:51.810><c> and</c><00:01:52.409><c> then</c><00:01:52.680><c> click</c><00:01:53.009><c> the</c><00:01:53.159><c> center</c>

00:01:53.510 --> 00:01:53.520 align:start position:0%
those cells and then click the center
 

00:01:53.520 --> 00:01:58.459 align:start position:0%
those cells and then click the center
alignments<00:01:54.119><c> command</c><00:01:55.700><c> if</c><00:01:56.700><c> I</c><00:01:57.570><c> wanted</c><00:01:57.990><c> to</c><00:01:58.229><c> I</c>

00:01:58.459 --> 00:01:58.469 align:start position:0%
alignments command if I wanted to I
 

00:01:58.469 --> 00:02:01.899 align:start position:0%
alignments command if I wanted to I
could<00:01:58.890><c> align</c><00:01:59.280><c> the</c><00:01:59.460><c> text</c><00:01:59.759><c> to</c><00:01:59.969><c> the</c><00:02:00.180><c> left</c><00:02:00.570><c> or</c>

00:02:01.899 --> 00:02:01.909 align:start position:0%
could align the text to the left or
 

00:02:01.909 --> 00:02:06.319 align:start position:0%
could align the text to the left or
align<00:02:02.909><c> it</c><00:02:03.060><c> to</c><00:02:03.090><c> the</c><00:02:03.240><c> right</c><00:02:04.219><c> but</c><00:02:05.219><c> I</c><00:02:05.640><c> think</c><00:02:06.180><c> it</c>

00:02:06.319 --> 00:02:06.329 align:start position:0%
align it to the right but I think it
 

00:02:06.329 --> 00:02:10.790 align:start position:0%
align it to the right but I think it
looks<00:02:06.540><c> best</c><00:02:06.810><c> centered</c><00:02:08.929><c> now</c><00:02:09.929><c> I</c><00:02:09.989><c> do</c><00:02:10.170><c> think</c><00:02:10.649><c> the</c>

00:02:10.790 --> 00:02:10.800 align:start position:0%
looks best centered now I do think the
 

00:02:10.800 --> 00:02:13.130 align:start position:0%
looks best centered now I do think the
package<00:02:11.190><c> size</c><00:02:11.400><c> would</c><00:02:12.060><c> look</c><00:02:12.360><c> best</c><00:02:12.660><c> right</c>

00:02:13.130 --> 00:02:13.140 align:start position:0%
package size would look best right
 

00:02:13.140 --> 00:02:13.740 align:start position:0%
package size would look best right
aligned

00:02:13.740 --> 00:02:13.750 align:start position:0%
aligned
 

00:02:13.750 --> 00:02:17.010 align:start position:0%
aligned
so<00:02:14.080><c> I'll</c><00:02:14.650><c> just</c><00:02:15.280><c> left-click</c><00:02:16.150><c> the</c><00:02:16.600><c> column</c>

00:02:17.010 --> 00:02:17.020 align:start position:0%
so I'll just left-click the column
 

00:02:17.020 --> 00:02:20.460 align:start position:0%
so I'll just left-click the column
heading<00:02:17.440><c> to</c><00:02:18.160><c> select</c><00:02:18.580><c> column</c><00:02:19.060><c> E</c><00:02:19.180><c> and</c><00:02:19.690><c> then</c>

00:02:20.460 --> 00:02:20.470 align:start position:0%
heading to select column E and then
 

00:02:20.470 --> 00:02:25.460 align:start position:0%
heading to select column E and then
click<00:02:20.800><c> the</c><00:02:20.980><c> align</c><00:02:21.370><c> text</c><00:02:22.150><c> right</c><00:02:22.510><c> command</c>

00:02:25.460 --> 00:02:25.470 align:start position:0%
 
 

00:02:25.470 --> 00:02:28.350 align:start position:0%
 
another<00:02:26.470><c> set</c><00:02:26.890><c> of</c><00:02:27.070><c> alignment</c><00:02:27.550><c> commands</c><00:02:27.970><c> in</c><00:02:28.240><c> the</c>

00:02:28.350 --> 00:02:28.360 align:start position:0%
another set of alignment commands in the
 

00:02:28.360 --> 00:02:31.890 align:start position:0%
another set of alignment commands in the
group<00:02:28.660><c> are</c><00:02:28.900><c> the</c><00:02:29.530><c> top</c><00:02:29.860><c> align</c><00:02:30.250><c> middle</c><00:02:30.880><c> align</c><00:02:31.450><c> and</c>

00:02:31.890 --> 00:02:31.900 align:start position:0%
group are the top align middle align and
 

00:02:31.900 --> 00:02:36.210 align:start position:0%
group are the top align middle align and
bottom<00:02:32.530><c> align</c><00:02:32.860><c> commands</c><00:02:34.470><c> to</c><00:02:35.470><c> see</c><00:02:35.740><c> how</c><00:02:35.920><c> these</c>

00:02:36.210 --> 00:02:36.220 align:start position:0%
bottom align commands to see how these
 

00:02:36.220 --> 00:02:39.390 align:start position:0%
bottom align commands to see how these
work<00:02:36.670><c> let's</c><00:02:37.510><c> increase</c><00:02:38.050><c> the</c><00:02:38.290><c> heights</c><00:02:38.560><c> of</c><00:02:38.800><c> row</c><00:02:39.010><c> 1</c>

00:02:39.390 --> 00:02:39.400 align:start position:0%
work let's increase the heights of row 1
 

00:02:39.400 --> 00:02:44.250 align:start position:0%
work let's increase the heights of row 1
and<00:02:41.100><c> I'll</c><00:02:42.100><c> just</c><00:02:42.460><c> go</c><00:02:42.700><c> ahead</c><00:02:42.880><c> and</c><00:02:43.510><c> make</c><00:02:44.080><c> our</c>

00:02:44.250 --> 00:02:44.260 align:start position:0%
and I'll just go ahead and make our
 

00:02:44.260 --> 00:02:51.240 align:start position:0%
and I'll just go ahead and make our
title<00:02:44.800><c> bigger</c><00:02:45.540><c> and</c><00:02:47.820><c> bold</c><00:02:48.820><c> it</c><00:02:49.530><c> now</c><00:02:50.530><c> if</c><00:02:50.890><c> I</c><00:02:51.190><c> click</c>

00:02:51.240 --> 00:02:51.250 align:start position:0%
title bigger and bold it now if I click
 

00:02:51.250 --> 00:02:54.240 align:start position:0%
title bigger and bold it now if I click
the<00:02:51.700><c> top</c><00:02:52.000><c> align</c><00:02:52.480><c> command</c><00:02:52.750><c> the</c><00:02:53.620><c> title</c><00:02:54.130><c> will</c>

00:02:54.240 --> 00:02:54.250 align:start position:0%
the top align command the title will
 

00:02:54.250 --> 00:02:57.210 align:start position:0%
the top align command the title will
align<00:02:54.610><c> to</c><00:02:54.910><c> the</c><00:02:55.030><c> top</c><00:02:55.330><c> of</c><00:02:55.630><c> the</c><00:02:55.750><c> cell</c><00:02:56.020><c> the</c><00:02:56.770><c> bottom</c>

00:02:57.210 --> 00:02:57.220 align:start position:0%
align to the top of the cell the bottom
 

00:02:57.220 --> 00:02:59.220 align:start position:0%
align to the top of the cell the bottom
align<00:02:57.580><c> command</c><00:02:57.820><c> moves</c><00:02:58.480><c> the</c><00:02:58.630><c> text</c><00:02:58.870><c> to</c><00:02:59.110><c> the</c>

00:02:59.220 --> 00:02:59.230 align:start position:0%
align command moves the text to the
 

00:02:59.230 --> 00:03:01.470 align:start position:0%
align command moves the text to the
bottom<00:02:59.620><c> of</c><00:02:59.740><c> the</c><00:02:59.830><c> cell</c><00:03:00.070><c> and</c><00:03:00.370><c> the</c><00:03:00.880><c> middle</c><00:03:01.180><c> align</c>

00:03:01.470 --> 00:03:01.480 align:start position:0%
bottom of the cell and the middle align
 

00:03:01.480 --> 00:03:04.190 align:start position:0%
bottom of the cell and the middle align
command<00:03:01.930><c> centers</c><00:03:02.560><c> it</c><00:03:02.740><c> in</c><00:03:02.920><c> the</c><00:03:03.100><c> middle</c><00:03:03.459><c> a</c>

00:03:04.190 --> 00:03:04.200 align:start position:0%
command centers it in the middle a
 

00:03:04.200 --> 00:03:07.320 align:start position:0%
command centers it in the middle a
really<00:03:05.200><c> useful</c><00:03:05.530><c> alignment</c><00:03:06.430><c> command</c><00:03:06.940><c> is</c><00:03:07.180><c> the</c>

00:03:07.320 --> 00:03:07.330 align:start position:0%
really useful alignment command is the
 

00:03:07.330 --> 00:03:10.710 align:start position:0%
really useful alignment command is the
wrap<00:03:07.630><c> text</c><00:03:08.140><c> command</c><00:03:08.760><c> to</c><00:03:09.760><c> show</c><00:03:10.030><c> you</c><00:03:10.090><c> how</c><00:03:10.390><c> this</c>

00:03:10.710 --> 00:03:10.720 align:start position:0%
wrap text command to show you how this
 

00:03:10.720 --> 00:03:11.280 align:start position:0%
wrap text command to show you how this
works

00:03:11.280 --> 00:03:11.290 align:start position:0%
works
 

00:03:11.290 --> 00:03:17.880 align:start position:0%
works
let<00:03:11.620><c> me</c><00:03:11.830><c> start</c><00:03:12.160><c> a</c><00:03:12.370><c> new</c><00:03:12.550><c> column</c><00:03:13.030><c> in</c><00:03:13.150><c> h1</c><00:03:14.340><c> as</c><00:03:16.890><c> I</c>

00:03:17.880 --> 00:03:17.890 align:start position:0%
let me start a new column in h1 as I
 

00:03:17.890 --> 00:03:20.550 align:start position:0%
let me start a new column in h1 as I
move<00:03:18.160><c> down</c><00:03:18.430><c> to</c><00:03:18.640><c> the</c><00:03:18.730><c> next</c><00:03:18.760><c> cell</c><00:03:19.560><c> Excel</c>

00:03:20.550 --> 00:03:20.560 align:start position:0%
move down to the next cell Excel
 

00:03:20.560 --> 00:03:22.920 align:start position:0%
move down to the next cell Excel
realizes<00:03:21.400><c> that</c><00:03:21.430><c> I</c><00:03:21.640><c> am</c><00:03:21.760><c> adding</c><00:03:22.269><c> to</c><00:03:22.390><c> the</c><00:03:22.510><c> table</c>

00:03:22.920 --> 00:03:22.930 align:start position:0%
realizes that I am adding to the table
 

00:03:22.930 --> 00:03:27.090 align:start position:0%
realizes that I am adding to the table
and<00:03:23.080><c> automatically</c><00:03:23.800><c> formats</c><00:03:24.370><c> it</c><00:03:24.550><c> for</c><00:03:24.820><c> me</c><00:03:26.100><c> now</c>

00:03:27.090 --> 00:03:27.100 align:start position:0%
and automatically formats it for me now
 

00:03:27.100 --> 00:03:29.940 align:start position:0%
and automatically formats it for me now
in<00:03:27.430><c> h2</c><00:03:28.120><c> I</c><00:03:28.390><c> want</c><00:03:28.780><c> to</c><00:03:28.900><c> type</c><00:03:29.140><c> a</c><00:03:29.290><c> reminder</c><00:03:29.800><c> to</c>

00:03:29.940 --> 00:03:29.950 align:start position:0%
in h2 I want to type a reminder to
 

00:03:29.950 --> 00:03:33.810 align:start position:0%
in h2 I want to type a reminder to
myself<00:03:30.100><c> this</c><00:03:31.000><c> is</c><00:03:31.390><c> a</c><00:03:31.420><c> bestseller</c><00:03:32.610><c> order</c><00:03:33.610><c> and</c>

00:03:33.810 --> 00:03:33.820 align:start position:0%
myself this is a bestseller order and
 

00:03:33.820 --> 00:03:37.170 align:start position:0%
myself this is a bestseller order and
more<00:03:34.060><c> as</c><00:03:35.160><c> you</c><00:03:36.160><c> can</c><00:03:36.310><c> see</c><00:03:36.489><c> the</c><00:03:36.640><c> text</c><00:03:37.090><c> is</c>

00:03:37.170 --> 00:03:37.180 align:start position:0%
more as you can see the text is
 

00:03:37.180 --> 00:03:40.110 align:start position:0%
more as you can see the text is
overflowing<00:03:37.750><c> to</c><00:03:38.200><c> the</c><00:03:38.320><c> next</c><00:03:38.620><c> cell</c><00:03:38.950><c> if</c><00:03:39.310><c> I</c><00:03:39.880><c> want</c>

00:03:40.110 --> 00:03:40.120 align:start position:0%
overflowing to the next cell if I want
 

00:03:40.120 --> 00:03:42.150 align:start position:0%
overflowing to the next cell if I want
to<00:03:40.300><c> format</c><00:03:40.780><c> this</c><00:03:41.019><c> so</c><00:03:41.230><c> I</c><00:03:41.260><c> can</c><00:03:41.560><c> view</c><00:03:41.739><c> all</c><00:03:41.980><c> the</c>

00:03:42.150 --> 00:03:42.160 align:start position:0%
to format this so I can view all the
 

00:03:42.160 --> 00:03:44.940 align:start position:0%
to format this so I can view all the
text<00:03:42.640><c> I</c><00:03:42.790><c> can</c><00:03:43.390><c> select</c><00:03:43.630><c> the</c><00:03:43.780><c> cell</c><00:03:44.049><c> and</c><00:03:44.290><c> click</c><00:03:44.380><c> the</c>

00:03:44.940 --> 00:03:44.950 align:start position:0%
text I can select the cell and click the
 

00:03:44.950 --> 00:03:48.330 align:start position:0%
text I can select the cell and click the
wrap<00:03:45.160><c> text</c><00:03:45.459><c> command</c><00:03:46.440><c> all</c><00:03:47.440><c> the</c><00:03:47.500><c> text</c><00:03:48.250><c> is</c>

00:03:48.330 --> 00:03:48.340 align:start position:0%
wrap text command all the text is
 

00:03:48.340 --> 00:03:52.740 align:start position:0%
wrap text command all the text is
wrapped<00:03:48.670><c> and</c><00:03:49.060><c> appears</c><00:03:49.750><c> in</c><00:03:49.840><c> the</c><00:03:49.959><c> cell</c><00:03:50.670><c> if</c><00:03:51.750><c> you</c>

00:03:52.740 --> 00:03:52.750 align:start position:0%
wrapped and appears in the cell if you
 

00:03:52.750 --> 00:03:54.840 align:start position:0%
wrapped and appears in the cell if you
don't<00:03:53.200><c> want</c><00:03:53.620><c> to</c><00:03:53.830><c> format</c><00:03:54.280><c> each</c><00:03:54.549><c> cell</c>

00:03:54.840 --> 00:03:54.850 align:start position:0%
don't want to format each cell
 

00:03:54.850 --> 00:03:57.509 align:start position:0%
don't want to format each cell
individually<00:03:55.200><c> you</c><00:03:56.200><c> can</c><00:03:56.380><c> select</c><00:03:56.560><c> multiple</c>

00:03:57.509 --> 00:03:57.519 align:start position:0%
individually you can select multiple
 

00:03:57.519 --> 00:04:00.210 align:start position:0%
individually you can select multiple
cells<00:03:57.730><c> and</c><00:03:58.209><c> then</c><00:03:58.840><c> click</c><00:03:59.290><c> the</c><00:03:59.500><c> wrap</c><00:03:59.769><c> text</c>

00:04:00.210 --> 00:04:00.220 align:start position:0%
cells and then click the wrap text
 

00:04:00.220 --> 00:04:03.509 align:start position:0%
cells and then click the wrap text
command<00:04:00.720><c> now</c><00:04:01.720><c> when</c><00:04:02.260><c> I</c><00:04:02.350><c> enter</c><00:04:02.739><c> text</c><00:04:03.040><c> into</c><00:04:03.310><c> the</c>

00:04:03.509 --> 00:04:03.519 align:start position:0%
command now when I enter text into the
 

00:04:03.519 --> 00:04:06.210 align:start position:0%
command now when I enter text into the
cell<00:04:03.790><c> it</c><00:04:04.209><c> will</c><00:04:04.600><c> automatically</c><00:04:05.230><c> wrap</c><00:04:05.620><c> so</c><00:04:06.070><c> that</c>

00:04:06.210 --> 00:04:06.220 align:start position:0%
cell it will automatically wrap so that
 

00:04:06.220 --> 00:04:11.460 align:start position:0%
cell it will automatically wrap so that
it<00:04:06.310><c> all</c><00:04:06.489><c> appears</c><00:04:09.269><c> you</c><00:04:10.269><c> can</c><00:04:10.299><c> still</c><00:04:10.780><c> adjust</c><00:04:11.019><c> the</c>

00:04:11.460 --> 00:04:11.470 align:start position:0%
it all appears you can still adjust the
 

00:04:11.470 --> 00:04:14.190 align:start position:0%
it all appears you can still adjust the
column<00:04:11.920><c> width</c><00:04:12.220><c> and</c><00:04:12.580><c> the</c><00:04:13.180><c> text</c><00:04:13.570><c> will</c><00:04:13.600><c> wrap</c><00:04:13.750><c> to</c>

00:04:14.190 --> 00:04:14.200 align:start position:0%
column width and the text will wrap to
 

00:04:14.200 --> 00:04:17.039 align:start position:0%
column width and the text will wrap to
fit<00:04:14.440><c> the</c><00:04:14.560><c> new</c><00:04:14.739><c> column</c><00:04:15.130><c> size</c><00:04:15.570><c> the</c><00:04:16.570><c> final</c>

00:04:17.039 --> 00:04:17.049 align:start position:0%
fit the new column size the final
 

00:04:17.049 --> 00:04:19.020 align:start position:0%
fit the new column size the final
command<00:04:17.470><c> I</c><00:04:17.769><c> want</c><00:04:18.070><c> to</c><00:04:18.220><c> show</c><00:04:18.459><c> you</c><00:04:18.519><c> is</c><00:04:18.880><c> the</c>

00:04:19.020 --> 00:04:19.030 align:start position:0%
command I want to show you is the
 

00:04:19.030 --> 00:04:21.930 align:start position:0%
command I want to show you is the
orientation<00:04:19.359><c> command</c><00:04:20.169><c> this</c><00:04:21.100><c> one</c><00:04:21.370><c> allows</c><00:04:21.700><c> you</c>

00:04:21.930 --> 00:04:21.940 align:start position:0%
orientation command this one allows you
 

00:04:21.940 --> 00:04:24.690 align:start position:0%
orientation command this one allows you
to<00:04:22.030><c> format</c><00:04:22.450><c> text</c><00:04:22.479><c> in</c><00:04:23.050><c> a</c><00:04:23.140><c> variety</c><00:04:23.289><c> of</c><00:04:23.710><c> ways</c><00:04:23.979><c> such</c>

00:04:24.690 --> 00:04:24.700 align:start position:0%
to format text in a variety of ways such
 

00:04:24.700 --> 00:04:27.120 align:start position:0%
to format text in a variety of ways such
as<00:04:24.760><c> clockwise</c><00:04:25.450><c> vertical</c><00:04:26.229><c> and</c><00:04:26.620><c> rotate</c>

00:04:27.120 --> 00:04:27.130 align:start position:0%
as clockwise vertical and rotate
 

00:04:27.130 --> 00:04:30.570 align:start position:0%
as clockwise vertical and rotate
it<00:04:27.490><c> I</c><00:04:28.080><c> think</c><00:04:29.080><c> I'll</c><00:04:29.260><c> insert</c><00:04:29.680><c> another</c><00:04:29.980><c> column</c>

00:04:30.570 --> 00:04:30.580 align:start position:0%
it I think I'll insert another column
 

00:04:30.580 --> 00:04:33.630 align:start position:0%
it I think I'll insert another column
and<00:04:30.790><c> add</c><00:04:31.420><c> more</c><00:04:31.840><c> information</c><00:04:32.220><c> here</c><00:04:33.220><c> along</c><00:04:33.490><c> the</c>

00:04:33.630 --> 00:04:33.640 align:start position:0%
and add more information here along the
 

00:04:33.640 --> 00:04:36.960 align:start position:0%
and add more information here along the
left<00:04:34.260><c> after</c><00:04:35.260><c> inserting</c><00:04:35.770><c> the</c><00:04:35.980><c> column</c><00:04:36.460><c> I</c><00:04:36.610><c> need</c>

00:04:36.960 --> 00:04:36.970 align:start position:0%
left after inserting the column I need
 

00:04:36.970 --> 00:04:42.150 align:start position:0%
left after inserting the column I need
to<00:04:37.150><c> type</c><00:04:37.390><c> in</c><00:04:37.630><c> the</c><00:04:37.750><c> information</c><00:04:40.440><c> then</c><00:04:41.440><c> select</c><00:04:42.010><c> a</c>

00:04:42.150 --> 00:04:42.160 align:start position:0%
to type in the information then select a
 

00:04:42.160 --> 00:04:44.840 align:start position:0%
to type in the information then select a
couple<00:04:42.370><c> of</c><00:04:42.610><c> cells</c><00:04:42.970><c> here</c><00:04:43.360><c> on</c><00:04:43.480><c> the</c><00:04:43.570><c> side</c><00:04:43.810><c> and</c>

00:04:44.840 --> 00:04:44.850 align:start position:0%
couple of cells here on the side and
 

00:04:44.850 --> 00:04:50.610 align:start position:0%
couple of cells here on the side and
click<00:04:45.850><c> merge</c><00:04:46.300><c> and</c><00:04:46.690><c> center</c><00:04:49.050><c> now</c><00:04:50.050><c> if</c><00:04:50.410><c> I</c><00:04:50.560><c> click</c>

00:04:50.610 --> 00:04:50.620 align:start position:0%
click merge and center now if I click
 

00:04:50.620 --> 00:04:53.700 align:start position:0%
click merge and center now if I click
the<00:04:51.040><c> orientation</c><00:04:51.790><c> command</c><00:04:52.210><c> and</c><00:04:52.540><c> click</c><00:04:53.320><c> rotate</c>

00:04:53.700 --> 00:04:53.710 align:start position:0%
the orientation command and click rotate
 

00:04:53.710 --> 00:04:57.180 align:start position:0%
the orientation command and click rotate
text<00:04:54.430><c> up</c><00:04:54.790><c> the</c><00:04:55.630><c> text</c><00:04:56.080><c> will</c><00:04:56.230><c> be</c><00:04:56.380><c> formatted</c><00:04:56.980><c> here</c>

00:04:57.180 --> 00:04:57.190 align:start position:0%
text up the text will be formatted here
 

00:04:57.190 --> 00:05:00.510 align:start position:0%
text up the text will be formatted here
on<00:04:57.310><c> the</c><00:04:57.430><c> side</c><00:04:57.670><c> I</c><00:04:58.380><c> need</c><00:04:59.380><c> to</c><00:04:59.530><c> increase</c><00:04:59.860><c> my</c><00:04:59.920><c> text</c>

00:05:00.510 --> 00:05:00.520 align:start position:0%
on the side I need to increase my text
 

00:05:00.520 --> 00:05:03.090 align:start position:0%
on the side I need to increase my text
size<00:05:00.820><c> so</c><00:05:01.420><c> it</c><00:05:01.570><c> will</c><00:05:01.720><c> line</c><00:05:01.900><c> up</c><00:05:02.200><c> at</c><00:05:02.470><c> the</c><00:05:02.560><c> top</c><00:05:02.800><c> of</c><00:05:02.830><c> my</c>

00:05:03.090 --> 00:05:03.100 align:start position:0%
size so it will line up at the top of my
 

00:05:03.100 --> 00:05:09.260 align:start position:0%
size so it will line up at the top of my
spreadsheet<00:05:05.490><c> there</c><00:05:06.510><c> that</c><00:05:07.510><c> looks</c><00:05:07.690><c> pretty</c><00:05:07.870><c> good</c>

00:05:09.260 --> 00:05:09.270 align:start position:0%
spreadsheet there that looks pretty good
 

00:05:09.270 --> 00:05:12.180 align:start position:0%
spreadsheet there that looks pretty good
whether<00:05:10.270><c> we</c><00:05:10.540><c> are</c><00:05:10.720><c> moving</c><00:05:10.990><c> rotating</c><00:05:11.980><c> or</c>

00:05:12.180 --> 00:05:12.190 align:start position:0%
whether we are moving rotating or
 

00:05:12.190 --> 00:05:15.420 align:start position:0%
whether we are moving rotating or
wrapping<00:05:12.670><c> text</c><00:05:12.940><c> Excel</c><00:05:13.810><c> 2007</c><00:05:14.560><c> makes</c><00:05:14.890><c> aligning</c>

00:05:15.420 --> 00:05:15.430 align:start position:0%
wrapping text Excel 2007 makes aligning
 

00:05:15.430 --> 00:05:18.090 align:start position:0%
wrapping text Excel 2007 makes aligning
text<00:05:15.640><c> easy</c>