WEBVTT
Kind: captions
Language: en

00:00:00.000 --> 00:00:02.840 align:start position:0%
 
Excel<00:00:00.870><c> has</c><00:00:01.110><c> a</c><00:00:01.319><c> lot</c><00:00:01.709><c> of</c><00:00:01.740><c> great</c><00:00:02.190><c> features</c><00:00:02.429><c> that</c>

00:00:02.840 --> 00:00:02.850 align:start position:0%
Excel has a lot of great features that
 

00:00:02.850 --> 00:00:04.430 align:start position:0%
Excel has a lot of great features that
can<00:00:03.030><c> make</c><00:00:03.149><c> your</c><00:00:03.300><c> spreadsheets</c><00:00:03.810><c> run</c><00:00:04.080><c> more</c>

00:00:04.430 --> 00:00:04.440 align:start position:0%
can make your spreadsheets run more
 

00:00:04.440 --> 00:00:08.059 align:start position:0%
can make your spreadsheets run more
smoothly<00:00:04.830><c> but</c><00:00:05.819><c> merging</c><00:00:06.509><c> cells</c><00:00:06.810><c> is</c><00:00:07.170><c> not</c><00:00:07.680><c> one</c><00:00:08.040><c> of</c>

00:00:08.059 --> 00:00:08.069 align:start position:0%
smoothly but merging cells is not one of
 

00:00:08.069 --> 00:00:11.060 align:start position:0%
smoothly but merging cells is not one of
them<00:00:08.389><c> merged</c><00:00:09.389><c> cells</c><00:00:09.900><c> are</c><00:00:10.200><c> notorious</c><00:00:11.040><c> for</c>

00:00:11.060 --> 00:00:11.070 align:start position:0%
them merged cells are notorious for
 

00:00:11.070 --> 00:00:12.980 align:start position:0%
them merged cells are notorious for
creating<00:00:11.639><c> problems</c><00:00:12.090><c> in</c><00:00:12.210><c> spreadsheets</c><00:00:12.780><c> and</c>

00:00:12.980 --> 00:00:12.990 align:start position:0%
creating problems in spreadsheets and
 

00:00:12.990 --> 00:00:14.600 align:start position:0%
creating problems in spreadsheets and
I'm<00:00:13.620><c> going</c><00:00:13.830><c> to</c><00:00:13.860><c> show</c><00:00:14.040><c> you</c><00:00:14.099><c> a</c><00:00:14.219><c> couple</c><00:00:14.580><c> of</c>

00:00:14.600 --> 00:00:14.610 align:start position:0%
I'm going to show you a couple of
 

00:00:14.610 --> 00:00:16.250 align:start position:0%
I'm going to show you a couple of
reasons<00:00:15.000><c> why</c><00:00:15.150><c> you</c><00:00:15.210><c> shouldn't</c><00:00:15.780><c> use</c><00:00:16.049><c> them</c>

00:00:16.250 --> 00:00:16.260 align:start position:0%
reasons why you shouldn't use them
 

00:00:16.260 --> 00:00:18.650 align:start position:0%
reasons why you shouldn't use them
unless<00:00:16.680><c> you</c><00:00:16.830><c> absolutely</c><00:00:17.039><c> have</c><00:00:17.730><c> to</c><00:00:17.760><c> and</c><00:00:18.539><c> I'll</c>

00:00:18.650 --> 00:00:18.660 align:start position:0%
unless you absolutely have to and I'll
 

00:00:18.660 --> 00:00:20.450 align:start position:0%
unless you absolutely have to and I'll
also<00:00:18.810><c> show</c><00:00:18.960><c> you</c><00:00:19.230><c> an</c><00:00:19.470><c> alternative</c><00:00:19.980><c> you</c><00:00:20.160><c> can</c><00:00:20.279><c> use</c>

00:00:20.450 --> 00:00:20.460 align:start position:0%
also show you an alternative you can use
 

00:00:20.460 --> 00:00:23.509 align:start position:0%
also show you an alternative you can use
instead<00:00:20.789><c> in</c><00:00:21.410><c> this</c><00:00:22.410><c> example</c><00:00:22.769><c> we</c><00:00:23.010><c> didn't</c><00:00:23.369><c> have</c>

00:00:23.509 --> 00:00:23.519 align:start position:0%
instead in this example we didn't have
 

00:00:23.519 --> 00:00:26.509 align:start position:0%
instead in this example we didn't have
sales<00:00:23.910><c> data</c><00:00:24.269><c> for</c><00:00:24.480><c> this</c><00:00:24.660><c> row</c><00:00:24.900><c> so</c><00:00:25.140><c> we</c><00:00:25.590><c> merged</c><00:00:26.250><c> all</c>

00:00:26.509 --> 00:00:26.519 align:start position:0%
sales data for this row so we merged all
 

00:00:26.519 --> 00:00:29.419 align:start position:0%
sales data for this row so we merged all
four<00:00:26.939><c> cells</c><00:00:27.240><c> into</c><00:00:27.720><c> one</c><00:00:27.750><c> cell</c><00:00:28.320><c> mainly</c><00:00:29.160><c> so</c><00:00:29.310><c> we</c>

00:00:29.419 --> 00:00:29.429 align:start position:0%
four cells into one cell mainly so we
 

00:00:29.429 --> 00:00:30.890 align:start position:0%
four cells into one cell mainly so we
could<00:00:29.580><c> Center</c><00:00:29.910><c> the</c><00:00:30.029><c> text</c><00:00:30.179><c> across</c><00:00:30.570><c> several</c>

00:00:30.890 --> 00:00:30.900 align:start position:0%
could Center the text across several
 

00:00:30.900 --> 00:00:33.110 align:start position:0%
could Center the text across several
columns<00:00:31.439><c> and</c><00:00:31.590><c> sort</c><00:00:32.250><c> of</c><00:00:32.340><c> set</c><00:00:32.550><c> it</c><00:00:32.640><c> apart</c><00:00:32.910><c> from</c>

00:00:33.110 --> 00:00:33.120 align:start position:0%
columns and sort of set it apart from
 

00:00:33.120 --> 00:00:35.780 align:start position:0%
columns and sort of set it apart from
the<00:00:33.210><c> other</c><00:00:33.360><c> data</c><00:00:33.899><c> but</c><00:00:34.890><c> there's</c><00:00:35.100><c> a</c><00:00:35.160><c> problem</c>

00:00:35.780 --> 00:00:35.790 align:start position:0%
the other data but there's a problem
 

00:00:35.790 --> 00:00:37.790 align:start position:0%
the other data but there's a problem
watch<00:00:36.390><c> what</c><00:00:36.600><c> happens</c><00:00:36.899><c> when</c><00:00:37.050><c> I</c><00:00:37.079><c> try</c><00:00:37.320><c> to</c><00:00:37.350><c> sort</c>

00:00:37.790 --> 00:00:37.800 align:start position:0%
watch what happens when I try to sort
 

00:00:37.800 --> 00:00:40.790 align:start position:0%
watch what happens when I try to sort
this<00:00:37.950><c> data</c><00:00:38.360><c> I'll</c><00:00:39.360><c> try</c><00:00:39.780><c> to</c><00:00:39.840><c> sort</c><00:00:40.200><c> largest</c><00:00:40.680><c> to</c>

00:00:40.790 --> 00:00:40.800 align:start position:0%
this data I'll try to sort largest to
 

00:00:40.800 --> 00:00:44.119 align:start position:0%
this data I'll try to sort largest to
smallest<00:00:40.829><c> and</c><00:00:41.719><c> it</c><00:00:42.719><c> doesn't</c><00:00:43.050><c> work</c><00:00:43.170><c> it</c><00:00:43.739><c> gives</c><00:00:43.950><c> us</c>

00:00:44.119 --> 00:00:44.129 align:start position:0%
smallest and it doesn't work it gives us
 

00:00:44.129 --> 00:00:46.080 align:start position:0%
smallest and it doesn't work it gives us
an<00:00:44.280><c> error</c><00:00:44.460><c> message</c>

00:00:46.080 --> 00:00:46.090 align:start position:0%
an error message
 

00:00:46.090 --> 00:00:48.540 align:start position:0%
an error message
or<00:00:46.570><c> let's</c><00:00:47.050><c> say</c><00:00:47.230><c> we</c><00:00:47.380><c> wanted</c><00:00:47.650><c> to</c><00:00:47.710><c> copy</c><00:00:47.980><c> some</c><00:00:48.310><c> data</c>

00:00:48.540 --> 00:00:48.550 align:start position:0%
or let's say we wanted to copy some data
 

00:00:48.550 --> 00:00:51.580 align:start position:0%
or let's say we wanted to copy some data
from<00:00:48.880><c> one</c><00:00:49.180><c> part</c><00:00:49.420><c> of</c><00:00:49.510><c> our</c><00:00:49.630><c> sheet</c>

00:00:51.580 --> 00:00:51.590 align:start position:0%
from one part of our sheet
 

00:00:51.590 --> 00:00:55.300 align:start position:0%
from one part of our sheet
and<00:00:51.680><c> paste</c><00:00:52.160><c> it</c><00:00:52.340><c> into</c><00:00:52.520><c> the</c><00:00:52.790><c> merge</c><00:00:52.970><c> self</c>

00:00:55.300 --> 00:00:55.310 align:start position:0%
and paste it into the merge self
 

00:00:55.310 --> 00:00:57.460 align:start position:0%
and paste it into the merge self
that<00:00:55.880><c> doesn't</c><00:00:56.180><c> work</c><00:00:56.300><c> either</c><00:00:56.450><c> it</c><00:00:56.900><c> gives</c><00:00:57.170><c> us</c><00:00:57.320><c> a</c>

00:00:57.460 --> 00:00:57.470 align:start position:0%
that doesn't work either it gives us a
 

00:00:57.470 --> 00:01:00.310 align:start position:0%
that doesn't work either it gives us a
different<00:00:57.500><c> error</c><00:00:58.100><c> message</c><00:00:58.690><c> so</c><00:00:59.690><c> what's</c><00:01:00.170><c> the</c>

00:01:00.310 --> 00:01:00.320 align:start position:0%
different error message so what's the
 

00:01:00.320 --> 00:01:00.850 align:start position:0%
different error message so what's the
problem

00:01:00.850 --> 00:01:00.860 align:start position:0%
problem
 

00:01:00.860 --> 00:01:03.640 align:start position:0%
problem
well<00:01:01.610><c> many</c><00:01:02.030><c> Excel</c><00:01:02.420><c> features</c><00:01:02.600><c> rely</c><00:01:03.140><c> on</c><00:01:03.170><c> the</c>

00:01:03.640 --> 00:01:03.650 align:start position:0%
well many Excel features rely on the
 

00:01:03.650 --> 00:01:06.160 align:start position:0%
well many Excel features rely on the
consistent<00:01:04.309><c> grid</c><00:01:04.580><c> of</c><00:01:04.820><c> rows</c><00:01:05.180><c> and</c><00:01:05.480><c> columns</c><00:01:05.540><c> that</c>

00:01:06.160 --> 00:01:06.170 align:start position:0%
consistent grid of rows and columns that
 

00:01:06.170 --> 00:01:09.070 align:start position:0%
consistent grid of rows and columns that
every<00:01:06.710><c> spreadsheet</c><00:01:07.190><c> has</c><00:01:07.370><c> by</c><00:01:07.670><c> default</c><00:01:08.080><c> merge</c>

00:01:09.070 --> 00:01:09.080 align:start position:0%
every spreadsheet has by default merge
 

00:01:09.080 --> 00:01:11.860 align:start position:0%
every spreadsheet has by default merge
cells<00:01:09.470><c> break</c><00:01:09.890><c> out</c><00:01:10.070><c> of</c><00:01:10.310><c> this</c><00:01:10.460><c> grid</c><00:01:10.730><c> so</c><00:01:11.330><c> Excel</c>

00:01:11.860 --> 00:01:11.870 align:start position:0%
cells break out of this grid so Excel
 

00:01:11.870 --> 00:01:13.210 align:start position:0%
cells break out of this grid so Excel
may<00:01:12.050><c> not</c><00:01:12.200><c> know</c><00:01:12.380><c> how</c><00:01:12.530><c> to</c><00:01:12.560><c> handle</c><00:01:12.800><c> it</c>

00:01:13.210 --> 00:01:13.220 align:start position:0%
may not know how to handle it
 

00:01:13.220 --> 00:01:15.820 align:start position:0%
may not know how to handle it
luckily<00:01:14.210><c> there</c><00:01:14.720><c> is</c><00:01:14.870><c> another</c><00:01:15.230><c> way</c><00:01:15.440><c> to</c><00:01:15.470><c> get</c><00:01:15.710><c> the</c>

00:01:15.820 --> 00:01:15.830 align:start position:0%
luckily there is another way to get the
 

00:01:15.830 --> 00:01:18.570 align:start position:0%
luckily there is another way to get the
same<00:01:16.130><c> basic</c><00:01:16.670><c> look</c><00:01:16.880><c> without</c><00:01:17.210><c> merging</c><00:01:17.960><c> cells</c>

00:01:18.570 --> 00:01:18.580 align:start position:0%
same basic look without merging cells
 

00:01:18.580 --> 00:01:21.640 align:start position:0%
same basic look without merging cells
first<00:01:19.580><c> we'll</c><00:01:19.910><c> need</c><00:01:19.940><c> to</c><00:01:20.180><c> unmerge</c><00:01:20.840><c> this</c><00:01:21.170><c> by</c>

00:01:21.640 --> 00:01:21.650 align:start position:0%
first we'll need to unmerge this by
 

00:01:21.650 --> 00:01:24.910 align:start position:0%
first we'll need to unmerge this by
clicking<00:01:21.890><c> the</c><00:01:22.100><c> merge</c><00:01:22.490><c> &amp;</c><00:01:22.790><c> Center</c><00:01:23.150><c> command</c><00:01:23.920><c> so</c>

00:01:24.910 --> 00:01:24.920 align:start position:0%
clicking the merge &amp; Center command so
 

00:01:24.920 --> 00:01:27.510 align:start position:0%
clicking the merge &amp; Center command so
these<00:01:25.040><c> are</c><00:01:25.190><c> now</c><00:01:25.340><c> separate</c><00:01:25.880><c> cells</c>

00:01:27.510 --> 00:01:27.520 align:start position:0%
these are now separate cells
 

00:01:27.520 --> 00:01:31.109 align:start position:0%
these are now separate cells
next<00:01:28.210><c> with</c><00:01:28.509><c> all</c><00:01:28.750><c> four</c><00:01:29.079><c> cells</c><00:01:29.380><c> selected</c><00:01:30.119><c> click</c>

00:01:31.109 --> 00:01:31.119 align:start position:0%
next with all four cells selected click
 

00:01:31.119 --> 00:01:35.670 align:start position:0%
next with all four cells selected click
this<00:01:31.360><c> little</c><00:01:31.630><c> arrow</c><00:01:31.990><c> in</c><00:01:32.320><c> the</c><00:01:32.590><c> alignment</c><00:01:33.130><c> group</c>

00:01:35.670 --> 00:01:35.680 align:start position:0%
 
 

00:01:35.680 --> 00:01:38.220 align:start position:0%
 
in<00:01:35.740><c> the</c><00:01:36.580><c> horizontal</c><00:01:36.880><c> menu</c><00:01:37.360><c> we'll</c><00:01:37.990><c> select</c>

00:01:38.220 --> 00:01:38.230 align:start position:0%
in the horizontal menu we'll select
 

00:01:38.230 --> 00:01:42.090 align:start position:0%
in the horizontal menu we'll select
center<00:01:39.070><c> across</c><00:01:39.400><c> selection</c>

00:01:42.090 --> 00:01:42.100 align:start position:0%
center across selection
 

00:01:42.100 --> 00:01:45.340 align:start position:0%
center across selection
and<00:01:42.189><c> click</c><00:01:42.729><c> okay</c>

00:01:45.340 --> 00:01:45.350 align:start position:0%
 
 

00:01:45.350 --> 00:01:48.010 align:start position:0%
 
this<00:01:46.010><c> has</c><00:01:46.280><c> centered</c><00:01:46.700><c> the</c><00:01:46.820><c> text</c><00:01:47.180><c> perfectly</c><00:01:47.810><c> and</c>

00:01:48.010 --> 00:01:48.020 align:start position:0%
this has centered the text perfectly and
 

00:01:48.020 --> 00:01:51.280 align:start position:0%
this has centered the text perfectly and
it<00:01:48.680><c> looks</c><00:01:49.009><c> exactly</c><00:01:49.220><c> like</c><00:01:49.610><c> a</c><00:01:49.790><c> merged</c><00:01:50.150><c> cell</c><00:01:50.360><c> but</c>

00:01:51.280 --> 00:01:51.290 align:start position:0%
it looks exactly like a merged cell but
 

00:01:51.290 --> 00:01:53.920 align:start position:0%
it looks exactly like a merged cell but
it's<00:01:51.439><c> actually</c><00:01:51.799><c> separate</c><00:01:52.250><c> cells</c><00:01:52.930><c> most</c>

00:01:53.920 --> 00:01:53.930 align:start position:0%
it's actually separate cells most
 

00:01:53.930 --> 00:01:56.109 align:start position:0%
it's actually separate cells most
importantly<00:01:54.440><c> it</c><00:01:54.740><c> won't</c><00:01:55.070><c> cause</c><00:01:55.310><c> problems</c><00:01:55.340><c> the</c>

00:01:56.109 --> 00:01:56.119 align:start position:0%
importantly it won't cause problems the
 

00:01:56.119 --> 00:01:59.649 align:start position:0%
importantly it won't cause problems the
way<00:01:56.240><c> merged</c><00:01:56.600><c> cells</c><00:01:57.080><c> will</c><00:01:57.970><c> for</c><00:01:58.970><c> example</c><00:01:59.000><c> if</c><00:01:59.540><c> we</c>

00:01:59.649 --> 00:01:59.659 align:start position:0%
way merged cells will for example if we
 

00:01:59.659 --> 00:02:02.680 align:start position:0%
way merged cells will for example if we
try<00:01:59.869><c> to</c><00:01:59.899><c> sort</c><00:02:00.320><c> it</c>

00:02:02.680 --> 00:02:02.690 align:start position:0%
 
 

00:02:02.690 --> 00:02:05.280 align:start position:0%
 
works<00:02:02.960><c> and</c><00:02:03.290><c> we</c><00:02:03.860><c> don't</c><00:02:04.070><c> get</c><00:02:04.220><c> an</c><00:02:04.340><c> error</c><00:02:04.490><c> message</c>

00:02:05.280 --> 00:02:05.290 align:start position:0%
works and we don't get an error message
 

00:02:05.290 --> 00:02:07.750 align:start position:0%
works and we don't get an error message
it's<00:02:06.290><c> worth</c><00:02:06.500><c> noting</c><00:02:06.950><c> that</c><00:02:06.980><c> center</c><00:02:07.550><c> across</c>

00:02:07.750 --> 00:02:07.760 align:start position:0%
it's worth noting that center across
 

00:02:07.760 --> 00:02:10.960 align:start position:0%
it's worth noting that center across
selection<00:02:08.479><c> only</c><00:02:08.930><c> works</c><00:02:09.140><c> horizontally</c><00:02:09.979><c> so</c><00:02:10.670><c> for</c>

00:02:10.960 --> 00:02:10.970 align:start position:0%
selection only works horizontally so for
 

00:02:10.970 --> 00:02:13.000 align:start position:0%
selection only works horizontally so for
vertical<00:02:11.270><c> groups</c><00:02:11.630><c> of</c><00:02:11.810><c> cells</c><00:02:12.050><c> you</c><00:02:12.350><c> may</c><00:02:12.560><c> still</c>

00:02:13.000 --> 00:02:13.010 align:start position:0%
vertical groups of cells you may still
 

00:02:13.010 --> 00:02:15.130 align:start position:0%
vertical groups of cells you may still
need<00:02:13.220><c> to</c><00:02:13.340><c> merge</c><00:02:13.640><c> but</c><00:02:14.420><c> I</c><00:02:14.450><c> recommend</c><00:02:14.930><c> using</c>

00:02:15.130 --> 00:02:15.140 align:start position:0%
need to merge but I recommend using
 

00:02:15.140 --> 00:02:17.170 align:start position:0%
need to merge but I recommend using
center<00:02:15.650><c> across</c><00:02:15.890><c> selection</c><00:02:16.490><c> whenever</c><00:02:16.670><c> you</c><00:02:16.940><c> can</c>

00:02:17.170 --> 00:02:17.180 align:start position:0%
center across selection whenever you can
 

00:02:17.180 --> 00:02:19.090 align:start position:0%
center across selection whenever you can
because<00:02:17.810><c> it</c><00:02:17.930><c> will</c><00:02:17.990><c> help</c><00:02:18.230><c> you</c><00:02:18.350><c> avoid</c><00:02:18.470><c> all</c><00:02:18.920><c> of</c>

00:02:19.090 --> 00:02:19.100 align:start position:0%
because it will help you avoid all of
 

00:02:19.100 --> 00:02:20.950 align:start position:0%
because it will help you avoid all of
the<00:02:19.220><c> problems</c><00:02:19.730><c> associated</c><00:02:20.090><c> with</c><00:02:20.480><c> merged</c>

00:02:20.950 --> 00:02:20.960 align:start position:0%
the problems associated with merged
 

00:02:20.960 --> 00:02:25.180 align:start position:0%
the problems associated with merged
cells

00:02:25.180 --> 00:02:25.190 align:start position:0%
 
 

00:02:25.190 --> 00:02:27.580 align:start position:0%
 
Goodwill<00:02:25.970><c> Community</c><00:02:26.450><c> Foundation</c><00:02:27.110><c> creating</c>

00:02:27.580 --> 00:02:27.590 align:start position:0%
Goodwill Community Foundation creating
 

00:02:27.590 --> 00:02:30.640 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:02:28.160><c> for</c><00:02:28.370><c> a</c><00:02:28.430><c> better</c><00:02:28.460><c> life</c>