WEBVTT
Kind: captions
Language: en

00:00:06.109 --> 00:00:11.660 align:start position:0%
 
in<00:00:07.730><c> all</c><00:00:08.730><c> the</c><00:00:09.170><c> 2007</c><00:00:10.170><c> Microsoft</c><00:00:10.830><c> applications</c>

00:00:11.660 --> 00:00:11.670 align:start position:0%
in all the 2007 Microsoft applications
 

00:00:11.670 --> 00:00:14.720 align:start position:0%
in all the 2007 Microsoft applications
you'll<00:00:12.360><c> see</c><00:00:12.660><c> a</c><00:00:12.690><c> clipboard</c><00:00:13.590><c> group</c><00:00:13.920><c> on</c><00:00:14.280><c> the</c><00:00:14.519><c> Home</c>

00:00:14.720 --> 00:00:14.730 align:start position:0%
you'll see a clipboard group on the Home
 

00:00:14.730 --> 00:00:17.120 align:start position:0%
you'll see a clipboard group on the Home
tab<00:00:14.780><c> which</c><00:00:15.780><c> is</c><00:00:15.809><c> where</c><00:00:16.170><c> you'll</c><00:00:16.350><c> find</c><00:00:16.590><c> the</c><00:00:16.800><c> cut</c>

00:00:17.120 --> 00:00:17.130 align:start position:0%
tab which is where you'll find the cut
 

00:00:17.130 --> 00:00:20.779 align:start position:0%
tab which is where you'll find the cut
copy<00:00:17.670><c> and</c><00:00:18.029><c> paste</c><00:00:18.119><c> commands</c><00:00:19.070><c> these</c><00:00:20.070><c> commands</c>

00:00:20.779 --> 00:00:20.789 align:start position:0%
copy and paste commands these commands
 

00:00:20.789 --> 00:00:23.480 align:start position:0%
copy and paste commands these commands
make<00:00:21.029><c> it</c><00:00:21.150><c> very</c><00:00:21.510><c> easy</c><00:00:21.869><c> to</c><00:00:22.020><c> copy</c><00:00:22.410><c> or</c><00:00:22.769><c> cut</c><00:00:23.070><c> and</c>

00:00:23.480 --> 00:00:23.490 align:start position:0%
make it very easy to copy or cut and
 

00:00:23.490 --> 00:00:25.750 align:start position:0%
make it very easy to copy or cut and
then<00:00:24.000><c> paste</c><00:00:24.390><c> information</c><00:00:25.230><c> from</c><00:00:25.410><c> cell-to-cell</c>

00:00:25.750 --> 00:00:25.760 align:start position:0%
then paste information from cell-to-cell
 

00:00:25.760 --> 00:00:28.160 align:start position:0%
then paste information from cell-to-cell
so<00:00:26.760><c> that</c><00:00:26.939><c> you</c><00:00:27.060><c> don't</c><00:00:27.240><c> have</c><00:00:27.480><c> to</c><00:00:27.599><c> type</c><00:00:27.869><c> and</c>

00:00:28.160 --> 00:00:28.170 align:start position:0%
so that you don't have to type and
 

00:00:28.170 --> 00:00:31.310 align:start position:0%
so that you don't have to type and
retype<00:00:28.800><c> information</c><00:00:29.570><c> let's</c><00:00:30.570><c> take</c><00:00:30.869><c> a</c><00:00:30.900><c> look</c><00:00:31.230><c> at</c>

00:00:31.310 --> 00:00:31.320 align:start position:0%
retype information let's take a look at
 

00:00:31.320 --> 00:00:32.590 align:start position:0%
retype information let's take a look at
how<00:00:31.529><c> this</c><00:00:31.769><c> works</c>

00:00:32.590 --> 00:00:32.600 align:start position:0%
how this works
 

00:00:32.600 --> 00:00:35.360 align:start position:0%
how this works
I'm<00:00:33.600><c> happy</c><00:00:34.170><c> with</c><00:00:34.290><c> my</c><00:00:34.350><c> spreadsheet</c><00:00:35.100><c> that</c><00:00:35.250><c> I've</c>

00:00:35.360 --> 00:00:35.370 align:start position:0%
I'm happy with my spreadsheet that I've
 

00:00:35.370 --> 00:00:37.610 align:start position:0%
I'm happy with my spreadsheet that I've
created<00:00:35.610><c> but</c><00:00:36.480><c> I</c><00:00:36.510><c> do</c><00:00:36.630><c> think</c><00:00:37.020><c> I'd</c><00:00:37.200><c> like</c><00:00:37.410><c> to</c><00:00:37.440><c> add</c>

00:00:37.610 --> 00:00:37.620 align:start position:0%
created but I do think I'd like to add
 

00:00:37.620 --> 00:00:40.670 align:start position:0%
created but I do think I'd like to add
the<00:00:37.980><c> column</c><00:00:38.399><c> back</c><00:00:38.610><c> here</c><00:00:39.300><c> so</c><00:00:40.050><c> I</c><00:00:40.079><c> can</c><00:00:40.469><c> mark</c>

00:00:40.670 --> 00:00:40.680 align:start position:0%
the column back here so I can mark
 

00:00:40.680 --> 00:00:45.650 align:start position:0%
the column back here so I can mark
whether<00:00:41.010><c> I've</c><00:00:41.219><c> paid</c><00:00:41.520><c> my</c><00:00:41.550><c> bills</c><00:00:42.059><c> or</c><00:00:42.270><c> not</c><00:00:44.660><c> let's</c>

00:00:45.650 --> 00:00:45.660 align:start position:0%
whether I've paid my bills or not let's
 

00:00:45.660 --> 00:00:48.110 align:start position:0%
whether I've paid my bills or not let's
say<00:00:45.989><c> I</c><00:00:46.020><c> want</c><00:00:46.410><c> to</c><00:00:46.559><c> mark</c><00:00:46.829><c> everything</c><00:00:47.399><c> from</c><00:00:47.850><c> cell</c>

00:00:48.110 --> 00:00:48.120 align:start position:0%
say I want to mark everything from cell
 

00:00:48.120 --> 00:00:53.720 align:start position:0%
say I want to mark everything from cell
c9<00:00:48.800><c> to</c><00:00:49.800><c> c-13</c><00:00:50.610><c> as</c><00:00:50.910><c> paid</c><00:00:51.800><c> instead</c><00:00:52.800><c> of</c><00:00:52.920><c> typing</c><00:00:53.160><c> yes</c>

00:00:53.720 --> 00:00:53.730 align:start position:0%
c9 to c-13 as paid instead of typing yes
 

00:00:53.730 --> 00:00:58.029 align:start position:0%
c9 to c-13 as paid instead of typing yes
in<00:00:53.969><c> each</c><00:00:54.120><c> cell</c><00:00:54.480><c> I</c><00:00:54.840><c> can</c><00:00:55.440><c> type</c><00:00:55.680><c> yes</c><00:00:56.219><c> and</c><00:00:56.550><c> c9</c><00:00:57.360><c> and</c>

00:00:58.029 --> 00:00:58.039 align:start position:0%
in each cell I can type yes and c9 and
 

00:00:58.039 --> 00:01:01.069 align:start position:0%
in each cell I can type yes and c9 and
copy<00:00:59.039><c> and</c><00:00:59.340><c> paste</c><00:00:59.430><c> it</c><00:00:59.969><c> in</c><00:01:00.120><c> all</c><00:01:00.329><c> the</c><00:01:00.480><c> other</c><00:01:00.660><c> cells</c>

00:01:01.069 --> 00:01:01.079 align:start position:0%
copy and paste it in all the other cells
 

00:01:01.079 --> 00:01:04.939 align:start position:0%
copy and paste it in all the other cells
to<00:01:01.489><c> do</c><00:01:02.489><c> this</c><00:01:02.760><c> left</c><00:01:03.480><c> click</c><00:01:03.870><c> the</c><00:01:04.019><c> cell</c><00:01:04.320><c> to</c><00:01:04.559><c> select</c>

00:01:04.939 --> 00:01:04.949 align:start position:0%
to do this left click the cell to select
 

00:01:04.949 --> 00:01:11.780 align:start position:0%
to do this left click the cell to select
it<00:01:05.189><c> then</c><00:01:07.280><c> click</c><00:01:08.280><c> the</c><00:01:08.340><c> copy</c><00:01:08.729><c> command</c><00:01:10.790><c> the</c>

00:01:11.780 --> 00:01:11.790 align:start position:0%
it then click the copy command the
 

00:01:11.790 --> 00:01:14.570 align:start position:0%
it then click the copy command the
border<00:01:12.270><c> of</c><00:01:12.299><c> the</c><00:01:12.570><c> copied</c><00:01:12.990><c> cell</c><00:01:13.350><c> now</c><00:01:14.040><c> looks</c><00:01:14.460><c> like</c>

00:01:14.570 --> 00:01:14.580 align:start position:0%
border of the copied cell now looks like
 

00:01:14.580 --> 00:01:18.740 align:start position:0%
border of the copied cell now looks like
marching<00:01:15.000><c> ants</c><00:01:16.400><c> now</c><00:01:17.400><c> select</c><00:01:17.909><c> the</c><00:01:18.030><c> cell</c><00:01:18.360><c> or</c>

00:01:18.740 --> 00:01:18.750 align:start position:0%
marching ants now select the cell or
 

00:01:18.750 --> 00:01:21.020 align:start position:0%
marching ants now select the cell or
cells<00:01:19.320><c> where</c><00:01:19.920><c> you</c><00:01:20.040><c> want</c><00:01:20.280><c> to</c><00:01:20.460><c> paste</c><00:01:20.700><c> the</c>

00:01:21.020 --> 00:01:21.030 align:start position:0%
cells where you want to paste the
 

00:01:21.030 --> 00:01:23.840 align:start position:0%
cells where you want to paste the
information<00:01:21.180><c> if</c><00:01:22.020><c> you</c><00:01:22.950><c> just</c><00:01:23.189><c> want</c><00:01:23.460><c> to</c><00:01:23.520><c> paste</c>

00:01:23.840 --> 00:01:23.850 align:start position:0%
information if you just want to paste
 

00:01:23.850 --> 00:01:26.420 align:start position:0%
information if you just want to paste
the<00:01:24.000><c> information</c><00:01:24.659><c> into</c><00:01:24.810><c> one</c><00:01:25.170><c> cell</c><00:01:25.470><c> all</c><00:01:26.130><c> you</c>

00:01:26.420 --> 00:01:26.430 align:start position:0%
the information into one cell all you
 

00:01:26.430 --> 00:01:28.910 align:start position:0%
the information into one cell all you
have<00:01:26.580><c> to</c><00:01:26.700><c> do</c><00:01:26.880><c> is</c><00:01:27.030><c> left-click</c><00:01:27.540><c> that</c><00:01:28.110><c> cell</c><00:01:28.439><c> to</c>

00:01:28.910 --> 00:01:28.920 align:start position:0%
have to do is left-click that cell to
 

00:01:28.920 --> 00:01:34.609 align:start position:0%
have to do is left-click that cell to
select<00:01:29.100><c> it</c><00:01:31.939><c> if</c><00:01:32.939><c> you</c><00:01:33.780><c> want</c><00:01:34.049><c> to</c><00:01:34.200><c> paste</c><00:01:34.409><c> the</c>

00:01:34.609 --> 00:01:34.619 align:start position:0%
select it if you want to paste the
 

00:01:34.619 --> 00:01:37.280 align:start position:0%
select it if you want to paste the
copied<00:01:34.920><c> information</c><00:01:35.310><c> and</c><00:01:36.240><c> more</c><00:01:36.869><c> than</c><00:01:37.079><c> one</c>

00:01:37.280 --> 00:01:37.290 align:start position:0%
copied information and more than one
 

00:01:37.290 --> 00:01:40.130 align:start position:0%
copied information and more than one
adjoining<00:01:37.619><c> cell</c><00:01:38.040><c> just</c><00:01:38.909><c> left-click</c><00:01:39.390><c> one</c><00:01:40.020><c> of</c>

00:01:40.130 --> 00:01:40.140 align:start position:0%
adjoining cell just left-click one of
 

00:01:40.140 --> 00:01:43.069 align:start position:0%
adjoining cell just left-click one of
the<00:01:40.259><c> cells</c><00:01:40.590><c> and</c><00:01:40.950><c> drag</c><00:01:41.460><c> your</c><00:01:41.640><c> cursor</c><00:01:41.880><c> until</c><00:01:42.810><c> all</c>

00:01:43.069 --> 00:01:43.079 align:start position:0%
the cells and drag your cursor until all
 

00:01:43.079 --> 00:01:47.389 align:start position:0%
the cells and drag your cursor until all
the<00:01:43.320><c> cells</c><00:01:43.590><c> are</c><00:01:43.890><c> selected</c><00:01:45.439><c> now</c><00:01:46.439><c> release</c><00:01:47.369><c> the</c>

00:01:47.389 --> 00:01:47.399 align:start position:0%
the cells are selected now release the
 

00:01:47.399 --> 00:01:51.249 align:start position:0%
the cells are selected now release the
mouse<00:01:47.640><c> button</c><00:01:48.270><c> and</c><00:01:48.479><c> click</c><00:01:48.899><c> the</c><00:01:49.079><c> paste</c><00:01:49.320><c> command</c>

00:01:51.249 --> 00:01:51.259 align:start position:0%
mouse button and click the paste command
 

00:01:51.259 --> 00:01:55.520 align:start position:0%
mouse button and click the paste command
the<00:01:52.259><c> copied</c><00:01:52.770><c> cell</c><00:01:53.100><c> will</c><00:01:53.610><c> stay</c><00:01:53.880><c> selected</c><00:01:54.630><c> until</c>

00:01:55.520 --> 00:01:55.530 align:start position:0%
the copied cell will stay selected until
 

00:01:55.530 --> 00:01:58.219 align:start position:0%
the copied cell will stay selected until
you<00:01:55.829><c> perform</c><00:01:56.310><c> your</c><00:01:56.460><c> next</c><00:01:56.850><c> task</c><00:01:57.119><c> or</c><00:01:57.600><c> you</c><00:01:58.110><c> can</c>

00:01:58.219 --> 00:01:58.229 align:start position:0%
you perform your next task or you can
 

00:01:58.229 --> 00:02:03.459 align:start position:0%
you perform your next task or you can
always<00:01:58.530><c> double</c><00:01:58.740><c> click</c><00:01:59.219><c> it</c><00:01:59.369><c> to</c><00:01:59.399><c> deselected</c><00:02:00.299><c> the</c>

00:02:03.459 --> 00:02:03.469 align:start position:0%
 
 

00:02:03.469 --> 00:02:06.260 align:start position:0%
 
cut<00:02:04.469><c> command</c><00:02:05.009><c> is</c><00:02:05.310><c> different</c><00:02:05.820><c> from</c><00:02:05.880><c> the</c><00:02:06.060><c> copy</c>

00:02:06.260 --> 00:02:06.270 align:start position:0%
cut command is different from the copy
 

00:02:06.270 --> 00:02:08.770 align:start position:0%
cut command is different from the copy
commands<00:02:06.960><c> because</c><00:02:07.320><c> it</c><00:02:07.560><c> actually</c><00:02:08.160><c> removes</c>

00:02:08.770 --> 00:02:08.780 align:start position:0%
commands because it actually removes
 

00:02:08.780 --> 00:02:11.150 align:start position:0%
commands because it actually removes
information<00:02:09.780><c> from</c><00:02:09.929><c> the</c><00:02:10.050><c> selected</c><00:02:10.530><c> cell</c><00:02:10.830><c> and</c>

00:02:11.150 --> 00:02:11.160 align:start position:0%
information from the selected cell and
 

00:02:11.160 --> 00:02:15.420 align:start position:0%
information from the selected cell and
moves<00:02:11.910><c> it</c><00:02:12.030><c> to</c><00:02:12.060><c> another</c><00:02:12.390><c> cell</c>

00:02:15.420 --> 00:02:15.430 align:start position:0%
 
 

00:02:15.430 --> 00:02:20.430 align:start position:0%
 
for<00:02:16.430><c> example</c><00:02:17.030><c> let's</c><00:02:17.659><c> move</c><00:02:18.019><c> yes</c><00:02:18.560><c> from</c><00:02:19.159><c> cell</c><00:02:19.489><c> c9</c>

00:02:20.430 --> 00:02:20.440 align:start position:0%
for example let's move yes from cell c9
 

00:02:20.440 --> 00:02:27.670 align:start position:0%
for example let's move yes from cell c9
to<00:02:21.440><c> c15</c><00:02:23.230><c> select</c><00:02:24.230><c> cell</c><00:02:24.739><c> c9</c><00:02:25.280><c> and</c><00:02:26.140><c> click</c><00:02:27.140><c> the</c><00:02:27.409><c> cuts</c>

00:02:27.670 --> 00:02:27.680 align:start position:0%
to c15 select cell c9 and click the cuts
 

00:02:27.680 --> 00:02:32.550 align:start position:0%
to c15 select cell c9 and click the cuts
command<00:02:28.959><c> now</c><00:02:29.959><c> select</c><00:02:30.500><c> the</c><00:02:30.769><c> blank</c><00:02:31.099><c> cell</c><00:02:31.579><c> and</c>

00:02:32.550 --> 00:02:32.560 align:start position:0%
command now select the blank cell and
 

00:02:32.560 --> 00:02:37.360 align:start position:0%
command now select the blank cell and
click<00:02:33.560><c> paste</c><00:02:34.390><c> the</c><00:02:35.390><c> word</c><00:02:35.599><c> yes</c><00:02:36.140><c> now</c><00:02:36.680><c> appears</c><00:02:37.280><c> in</c>

00:02:37.360 --> 00:02:37.370 align:start position:0%
click paste the word yes now appears in
 

00:02:37.370 --> 00:02:42.009 align:start position:0%
click paste the word yes now appears in
C<00:02:37.819><c> 15</c><00:02:38.390><c> and</c><00:02:38.720><c> c9</c><00:02:39.500><c> is</c><00:02:39.739><c> empty</c><00:02:40.360><c> so</c><00:02:41.360><c> now</c><00:02:41.569><c> you</c><00:02:41.629><c> see</c><00:02:41.900><c> how</c>

00:02:42.009 --> 00:02:42.019 align:start position:0%
C 15 and c9 is empty so now you see how
 

00:02:42.019 --> 00:02:44.740 align:start position:0%
C 15 and c9 is empty so now you see how
the<00:02:42.049><c> cut</c><00:02:42.379><c> command</c><00:02:42.530><c> works</c><00:02:43.040><c> I</c><00:02:43.400><c> actually</c><00:02:44.060><c> do</c><00:02:44.540><c> want</c>

00:02:44.740 --> 00:02:44.750 align:start position:0%
the cut command works I actually do want
 

00:02:44.750 --> 00:02:48.160 align:start position:0%
the cut command works I actually do want
to<00:02:44.870><c> leave</c><00:02:45.170><c> the</c><00:02:45.349><c> word</c><00:02:45.530><c> yes</c><00:02:45.950><c> in</c><00:02:46.220><c> c9</c><00:02:46.819><c> let</c><00:02:47.750><c> me</c><00:02:47.900><c> paste</c>

00:02:48.160 --> 00:02:48.170 align:start position:0%
to leave the word yes in c9 let me paste
 

00:02:48.170 --> 00:02:51.729 align:start position:0%
to leave the word yes in c9 let me paste
that<00:02:48.379><c> into</c><00:02:48.530><c> the</c><00:02:48.709><c> cell</c><00:02:48.980><c> I</c><00:02:49.840><c> can</c><00:02:50.840><c> use</c><00:02:51.290><c> the</c><00:02:51.440><c> paste</c>

00:02:51.729 --> 00:02:51.739 align:start position:0%
that into the cell I can use the paste
 

00:02:51.739 --> 00:02:54.160 align:start position:0%
that into the cell I can use the paste
command<00:02:52.190><c> or</c><00:02:52.790><c> press</c><00:02:53.480><c> the</c><00:02:53.750><c> keyboard</c><00:02:53.959><c> shortcut</c>

00:02:54.160 --> 00:02:54.170 align:start position:0%
command or press the keyboard shortcut
 

00:02:54.170 --> 00:02:57.309 align:start position:0%
command or press the keyboard shortcut
for<00:02:54.950><c> paste</c><00:02:54.980><c> which</c><00:02:55.940><c> is</c><00:02:56.120><c> the</c><00:02:56.239><c> ctrl</c><00:02:56.629><c> key</c><00:02:56.959><c> and</c><00:02:57.260><c> the</c>

00:02:57.309 --> 00:02:57.319 align:start position:0%
for paste which is the ctrl key and the
 

00:02:57.319 --> 00:03:03.039 align:start position:0%
for paste which is the ctrl key and the
V<00:02:57.739><c> key</c><00:03:00.700><c> another</c><00:03:01.700><c> way</c><00:03:01.940><c> to</c><00:03:02.000><c> move</c><00:03:02.329><c> information</c>

00:03:03.039 --> 00:03:03.049 align:start position:0%
V key another way to move information
 

00:03:03.049 --> 00:03:05.470 align:start position:0%
V key another way to move information
from<00:03:03.200><c> one</c><00:03:03.470><c> cell</c><00:03:03.500><c> to</c><00:03:03.980><c> another</c><00:03:04.040><c> is</c><00:03:04.670><c> to</c><00:03:05.120><c> use</c><00:03:05.150><c> the</c>

00:03:05.470 --> 00:03:05.480 align:start position:0%
from one cell to another is to use the
 

00:03:05.480 --> 00:03:07.380 align:start position:0%
from one cell to another is to use the
drag<00:03:05.840><c> and</c><00:03:05.900><c> drop</c><00:03:06.230><c> method</c>

00:03:07.380 --> 00:03:07.390 align:start position:0%
drag and drop method
 

00:03:07.390 --> 00:03:10.420 align:start position:0%
drag and drop method
drag<00:03:08.390><c> and</c><00:03:08.569><c> drop</c><00:03:08.599><c> moves</c><00:03:09.140><c> the</c><00:03:09.319><c> text</c><00:03:09.530><c> and</c><00:03:09.829><c> numbers</c>

00:03:10.420 --> 00:03:10.430 align:start position:0%
drag and drop moves the text and numbers
 

00:03:10.430 --> 00:03:13.479 align:start position:0%
drag and drop moves the text and numbers
in<00:03:10.670><c> the</c><00:03:10.790><c> cells</c><00:03:11.090><c> and</c><00:03:11.450><c> any</c><00:03:11.989><c> formulas</c><00:03:12.739><c> associated</c>

00:03:13.479 --> 00:03:13.489 align:start position:0%
in the cells and any formulas associated
 

00:03:13.489 --> 00:03:16.869 align:start position:0%
in the cells and any formulas associated
with<00:03:13.760><c> those</c><00:03:14.090><c> cells</c><00:03:14.950><c> let's</c><00:03:15.950><c> take</c><00:03:16.250><c> a</c><00:03:16.280><c> look</c><00:03:16.609><c> at</c><00:03:16.760><c> my</c>

00:03:16.869 --> 00:03:16.879 align:start position:0%
with those cells let's take a look at my
 

00:03:16.879 --> 00:03:20.920 align:start position:0%
with those cells let's take a look at my
net<00:03:17.239><c> income</c><00:03:17.900><c> for</c><00:03:18.109><c> January</c><00:03:19.329><c> you</c><00:03:20.329><c> can</c><00:03:20.540><c> see</c><00:03:20.780><c> in</c>

00:03:20.920 --> 00:03:20.930 align:start position:0%
net income for January you can see in
 

00:03:20.930 --> 00:03:22.720 align:start position:0%
net income for January you can see in
the<00:03:21.049><c> formula</c><00:03:21.500><c> bar</c><00:03:21.919><c> that</c><00:03:22.370><c> there</c><00:03:22.549><c> is</c><00:03:22.609><c> an</c>

00:03:22.720 --> 00:03:22.730 align:start position:0%
the formula bar that there is an
 

00:03:22.730 --> 00:03:24.970 align:start position:0%
the formula bar that there is an
addition<00:03:23.239><c> formula</c><00:03:23.780><c> associated</c><00:03:24.620><c> with</c><00:03:24.769><c> this</c>

00:03:24.970 --> 00:03:24.980 align:start position:0%
addition formula associated with this
 

00:03:24.980 --> 00:03:30.129 align:start position:0%
addition formula associated with this
cell<00:03:27.489><c> when</c><00:03:28.489><c> I</c><00:03:28.519><c> drag</c><00:03:29.000><c> all</c><00:03:29.329><c> of</c><00:03:29.480><c> my</c><00:03:29.629><c> income</c>

00:03:30.129 --> 00:03:30.139 align:start position:0%
cell when I drag all of my income
 

00:03:30.139 --> 00:03:32.710 align:start position:0%
cell when I drag all of my income
information<00:03:30.950><c> to</c><00:03:31.549><c> a</c><00:03:31.579><c> new</c><00:03:31.910><c> location</c><00:03:32.299><c> in</c><00:03:32.599><c> the</c>

00:03:32.710 --> 00:03:32.720 align:start position:0%
information to a new location in the
 

00:03:32.720 --> 00:03:35.400 align:start position:0%
information to a new location in the
worksheet<00:03:33.200><c> this</c><00:03:33.859><c> formula</c><00:03:34.519><c> will</c><00:03:34.700><c> come</c><00:03:34.730><c> along</c>

00:03:35.400 --> 00:03:35.410 align:start position:0%
worksheet this formula will come along
 

00:03:35.410 --> 00:03:37.869 align:start position:0%
worksheet this formula will come along
let's<00:03:36.410><c> take</c><00:03:36.680><c> a</c><00:03:36.709><c> look</c><00:03:36.980><c> at</c><00:03:37.099><c> how</c><00:03:37.310><c> drag-and-drop</c>

00:03:37.869 --> 00:03:37.879 align:start position:0%
let's take a look at how drag-and-drop
 

00:03:37.879 --> 00:03:42.339 align:start position:0%
let's take a look at how drag-and-drop
works<00:03:39.310><c> let's</c><00:03:40.310><c> select</c><00:03:40.910><c> all</c><00:03:41.180><c> the</c><00:03:41.660><c> cells</c><00:03:41.959><c> at</c><00:03:42.260><c> the</c>

00:03:42.339 --> 00:03:42.349 align:start position:0%
works let's select all the cells at the
 

00:03:42.349 --> 00:03:46.020 align:start position:0%
works let's select all the cells at the
top<00:03:42.620><c> with</c><00:03:42.919><c> my</c><00:03:42.949><c> income</c><00:03:43.459><c> information</c><00:03:44.859><c> now</c>

00:03:46.020 --> 00:03:46.030 align:start position:0%
top with my income information now
 

00:03:46.030 --> 00:03:49.479 align:start position:0%
top with my income information now
position<00:03:47.030><c> your</c><00:03:47.209><c> mouse</c><00:03:47.239><c> pointer</c><00:03:47.870><c> near</c><00:03:48.650><c> one</c><00:03:49.340><c> of</c>

00:03:49.479 --> 00:03:49.489 align:start position:0%
position your mouse pointer near one of
 

00:03:49.489 --> 00:03:53.369 align:start position:0%
position your mouse pointer near one of
the<00:03:49.579><c> outside</c><00:03:50.120><c> edges</c><00:03:50.480><c> of</c><00:03:50.959><c> the</c><00:03:51.620><c> selected</c><00:03:52.190><c> cells</c>

00:03:53.369 --> 00:03:53.379 align:start position:0%
the outside edges of the selected cells
 

00:03:53.379 --> 00:03:56.259 align:start position:0%
the outside edges of the selected cells
the<00:03:54.379><c> mouse</c><00:03:54.680><c> pointer</c><00:03:55.129><c> changes</c><00:03:55.160><c> from</c><00:03:55.760><c> a</c><00:03:55.910><c> large</c>

00:03:56.259 --> 00:03:56.269 align:start position:0%
the mouse pointer changes from a large
 

00:03:56.269 --> 00:04:00.250 align:start position:0%
the mouse pointer changes from a large
white<00:03:56.840><c> cross</c><00:03:57.319><c> to</c><00:03:58.160><c> a</c><00:03:58.190><c> black</c><00:03:58.549><c> cross</c><00:03:59.060><c> with</c><00:03:59.720><c> four</c>

00:04:00.250 --> 00:04:00.260 align:start position:0%
white cross to a black cross with four
 

00:04:00.260 --> 00:04:04.689 align:start position:0%
white cross to a black cross with four
arrows<00:04:02.560><c> keep</c><00:04:03.560><c> the</c><00:04:03.769><c> mouse</c><00:04:04.010><c> pointer</c><00:04:04.549><c> on</c><00:04:04.579><c> the</c>

00:04:04.689 --> 00:04:04.699 align:start position:0%
arrows keep the mouse pointer on the
 

00:04:04.699 --> 00:04:08.080 align:start position:0%
arrows keep the mouse pointer on the
edge<00:04:05.030><c> of</c><00:04:05.359><c> the</c><00:04:05.480><c> selected</c><00:04:06.079><c> cells</c><00:04:07.090><c> now</c>

00:04:08.080 --> 00:04:08.090 align:start position:0%
edge of the selected cells now
 

00:04:08.090 --> 00:04:11.170 align:start position:0%
edge of the selected cells now
left-click<00:04:09.049><c> and</c><00:04:09.530><c> hold</c><00:04:09.620><c> the</c><00:04:10.129><c> mouse</c><00:04:10.370><c> button</c><00:04:10.430><c> and</c>

00:04:11.170 --> 00:04:11.180 align:start position:0%
left-click and hold the mouse button and
 

00:04:11.180 --> 00:04:14.580 align:start position:0%
left-click and hold the mouse button and
drag<00:04:11.810><c> the</c><00:04:11.840><c> cells</c><00:04:12.349><c> to</c><00:04:12.620><c> the</c><00:04:12.650><c> new</c><00:04:12.949><c> location</c>

00:04:14.580 --> 00:04:14.590 align:start position:0%
drag the cells to the new location
 

00:04:14.590 --> 00:04:16.599 align:start position:0%
drag the cells to the new location
release<00:04:15.590><c> the</c><00:04:15.769><c> mouse</c><00:04:15.949><c> button</c><00:04:16.370><c> and</c><00:04:16.489><c> the</c>

00:04:16.599 --> 00:04:16.609 align:start position:0%
release the mouse button and the
 

00:04:16.609 --> 00:04:18.900 align:start position:0%
release the mouse button and the
information<00:04:17.000><c> appears</c><00:04:17.599><c> in</c><00:04:17.780><c> the</c><00:04:17.870><c> new</c><00:04:18.049><c> location</c>

00:04:18.900 --> 00:04:18.910 align:start position:0%
information appears in the new location
 

00:04:18.910 --> 00:04:21.969 align:start position:0%
information appears in the new location
see<00:04:19.910><c> how</c><00:04:20.090><c> easy</c><00:04:20.389><c> it</c><00:04:20.539><c> was</c><00:04:20.780><c> to</c><00:04:20.810><c> drag</c><00:04:21.380><c> all</c><00:04:21.650><c> this</c>

00:04:21.969 --> 00:04:21.979 align:start position:0%
see how easy it was to drag all this
 

00:04:21.979 --> 00:04:23.980 align:start position:0%
see how easy it was to drag all this
information<00:04:22.669><c> and</c><00:04:22.909><c> drop</c><00:04:23.539><c> it</c><00:04:23.719><c> into</c><00:04:23.840><c> a</c><00:04:23.930><c> new</c>

00:04:23.980 --> 00:04:23.990 align:start position:0%
information and drop it into a new
 

00:04:23.990 --> 00:04:27.100 align:start position:0%
information and drop it into a new
location<00:04:24.669><c> now</c><00:04:25.669><c> the</c><00:04:26.090><c> really</c><00:04:26.419><c> great</c><00:04:26.719><c> thing</c>

00:04:27.100 --> 00:04:27.110 align:start position:0%
location now the really great thing
 

00:04:27.110 --> 00:04:29.080 align:start position:0%
location now the really great thing
is<00:04:27.349><c> that</c><00:04:27.530><c> not</c><00:04:27.740><c> only</c><00:04:28.039><c> did</c><00:04:28.370><c> it</c><00:04:28.460><c> bring</c><00:04:28.759><c> all</c><00:04:29.030><c> my</c>

00:04:29.080 --> 00:04:29.090 align:start position:0%
is that not only did it bring all my
 

00:04:29.090 --> 00:04:32.860 align:start position:0%
is that not only did it bring all my
text<00:04:29.930><c> and</c><00:04:30.080><c> numbers</c><00:04:30.710><c> it</c><00:04:31.150><c> also</c><00:04:32.150><c> transferred</c><00:04:32.719><c> the</c>

00:04:32.860 --> 00:04:32.870 align:start position:0%
text and numbers it also transferred the
 

00:04:32.870 --> 00:04:35.110 align:start position:0%
text and numbers it also transferred the
formulas<00:04:33.500><c> and</c><00:04:33.710><c> changed</c><00:04:34.610><c> them</c><00:04:34.789><c> to</c><00:04:34.819><c> represent</c>

00:04:35.110 --> 00:04:35.120 align:start position:0%
formulas and changed them to represent
 

00:04:35.120 --> 00:04:39.429 align:start position:0%
formulas and changed them to represent
their<00:04:35.539><c> new</c><00:04:35.780><c> location</c><00:04:37.000><c> now</c><00:04:38.229><c> instead</c><00:04:39.229><c> of</c><00:04:39.289><c> a</c>

00:04:39.429 --> 00:04:39.439 align:start position:0%
their new location now instead of a
 

00:04:39.439 --> 00:04:44.499 align:start position:0%
their new location now instead of a
formula<00:04:39.979><c> saying</c><00:04:40.310><c> cell</c><00:04:40.879><c> c3</c><00:04:41.889><c> plus</c><00:04:42.889><c> cell</c><00:04:43.430><c> c4</c><00:04:44.210><c> it</c>

00:04:44.499 --> 00:04:44.509 align:start position:0%
formula saying cell c3 plus cell c4 it
 

00:04:44.509 --> 00:04:46.869 align:start position:0%
formula saying cell c3 plus cell c4 it
shows<00:04:45.199><c> the</c><00:04:45.409><c> new</c><00:04:45.710><c> cell</c><00:04:46.069><c> addresses</c><00:04:46.580><c> in</c><00:04:46.789><c> the</c>

00:04:46.869 --> 00:04:46.879 align:start position:0%
shows the new cell addresses in the
 

00:04:46.879 --> 00:04:51.580 align:start position:0%
shows the new cell addresses in the
formula<00:04:49.330><c> one</c><00:04:50.330><c> last</c><00:04:50.629><c> thing</c><00:04:50.960><c> that</c><00:04:50.990><c> is</c><00:04:51.199><c> worth</c>

00:04:51.580 --> 00:04:51.590 align:start position:0%
formula one last thing that is worth
 

00:04:51.590 --> 00:04:54.429 align:start position:0%
formula one last thing that is worth
showing<00:04:52.069><c> you</c><00:04:52.460><c> in</c><00:04:52.669><c> addition</c><00:04:53.300><c> to</c><00:04:53.509><c> the</c><00:04:53.689><c> copy</c><00:04:53.960><c> cuts</c>

00:04:54.429 --> 00:04:54.439 align:start position:0%
showing you in addition to the copy cuts
 

00:04:54.439 --> 00:04:56.679 align:start position:0%
showing you in addition to the copy cuts
and<00:04:54.710><c> paste</c><00:04:55.069><c> commands</c><00:04:55.550><c> and</c><00:04:55.909><c> the</c><00:04:56.449><c> drag-and-drop</c>

00:04:56.679 --> 00:04:56.689 align:start position:0%
and paste commands and the drag-and-drop
 

00:04:56.689 --> 00:04:59.499 align:start position:0%
and paste commands and the drag-and-drop
feature<00:04:57.259><c> the</c><00:04:57.949><c> fill</c><00:04:58.250><c> handle</c><00:04:58.580><c> is</c><00:04:58.819><c> another</c><00:04:59.270><c> way</c>

00:04:59.499 --> 00:04:59.509 align:start position:0%
feature the fill handle is another way
 

00:04:59.509 --> 00:05:02.159 align:start position:0%
feature the fill handle is another way
you<00:04:59.569><c> can</c><00:04:59.870><c> quickly</c><00:05:00.169><c> enter</c><00:05:00.469><c> data</c><00:05:00.919><c> into</c><00:05:01.279><c> cells</c>

00:05:02.159 --> 00:05:02.169 align:start position:0%
you can quickly enter data into cells
 

00:05:02.169 --> 00:05:05.499 align:start position:0%
you can quickly enter data into cells
for<00:05:03.169><c> example</c><00:05:03.710><c> let's</c><00:05:04.310><c> say</c><00:05:04.550><c> I</c><00:05:04.580><c> wanted</c><00:05:04.969><c> to</c><00:05:05.150><c> mark</c>

00:05:05.499 --> 00:05:05.509 align:start position:0%
for example let's say I wanted to mark
 

00:05:05.509 --> 00:05:08.110 align:start position:0%
for example let's say I wanted to mark
this<00:05:05.840><c> group</c><00:05:06.229><c> of</c><00:05:06.409><c> bills</c><00:05:06.710><c> as</c><00:05:07.039><c> not</c><00:05:07.490><c> paid</c>

00:05:08.110 --> 00:05:08.120 align:start position:0%
this group of bills as not paid
 

00:05:08.120 --> 00:05:14.649 align:start position:0%
this group of bills as not paid
I<00:05:10.000><c> can</c><00:05:11.000><c> type</c><00:05:11.270><c> know</c><00:05:11.779><c> into</c><00:05:12.349><c> cell</c><00:05:12.620><c> c16</c><00:05:13.430><c> and</c><00:05:13.969><c> then</c>

00:05:14.649 --> 00:05:14.659 align:start position:0%
I can type know into cell c16 and then
 

00:05:14.659 --> 00:05:16.719 align:start position:0%
I can type know into cell c16 and then
use<00:05:14.960><c> the</c><00:05:15.139><c> fill</c><00:05:15.439><c> handle</c><00:05:15.740><c> to</c><00:05:16.009><c> fill</c><00:05:16.219><c> the</c><00:05:16.580><c> other</c>

00:05:16.719 --> 00:05:16.729 align:start position:0%
use the fill handle to fill the other
 

00:05:16.729 --> 00:05:20.140 align:start position:0%
use the fill handle to fill the other
cells<00:05:17.120><c> with</c><00:05:17.449><c> the</c><00:05:17.569><c> word</c><00:05:17.779><c> know</c><00:05:18.550><c> the</c><00:05:19.550><c> fill</c><00:05:19.849><c> handle</c>

00:05:20.140 --> 00:05:20.150 align:start position:0%
cells with the word know the fill handle
 

00:05:20.150 --> 00:05:22.749 align:start position:0%
cells with the word know the fill handle
is<00:05:20.539><c> this</c><00:05:20.840><c> little</c><00:05:21.169><c> square</c><00:05:21.560><c> that</c><00:05:22.039><c> appears</c><00:05:22.520><c> in</c>

00:05:22.749 --> 00:05:22.759 align:start position:0%
is this little square that appears in
 

00:05:22.759 --> 00:05:24.809 align:start position:0%
is this little square that appears in
the<00:05:22.879><c> bottom</c><00:05:23.120><c> or</c><00:05:23.449><c> right</c><00:05:23.479><c> corner</c><00:05:24.110><c> of</c><00:05:24.259><c> the</c><00:05:24.379><c> cell</c>

00:05:24.809 --> 00:05:24.819 align:start position:0%
the bottom or right corner of the cell
 

00:05:24.819 --> 00:05:28.240 align:start position:0%
the bottom or right corner of the cell
to<00:05:25.819><c> use</c><00:05:26.120><c> it</c><00:05:26.360><c> just</c><00:05:26.810><c> position</c><00:05:27.409><c> your</c><00:05:27.500><c> cursor</c><00:05:27.770><c> over</c>

00:05:28.240 --> 00:05:28.250 align:start position:0%
to use it just position your cursor over
 

00:05:28.250 --> 00:05:30.760 align:start position:0%
to use it just position your cursor over
it<00:05:28.580><c> until</c><00:05:29.240><c> the</c><00:05:29.360><c> large</c><00:05:29.629><c> white</c><00:05:29.960><c> cross</c><00:05:30.259><c> becomes</c><00:05:30.650><c> a</c>

00:05:30.760 --> 00:05:30.770 align:start position:0%
it until the large white cross becomes a
 

00:05:30.770 --> 00:05:34.269 align:start position:0%
it until the large white cross becomes a
thin<00:05:31.099><c> black</c><00:05:31.400><c> cross</c><00:05:32.319><c> now</c><00:05:33.319><c> left-click</c><00:05:34.250><c> your</c>

00:05:34.269 --> 00:05:34.279 align:start position:0%
thin black cross now left-click your
 

00:05:34.279 --> 00:05:37.059 align:start position:0%
thin black cross now left-click your
mouse<00:05:34.490><c> and</c><00:05:35.150><c> drag</c><00:05:35.210><c> it</c><00:05:36.110><c> until</c><00:05:36.379><c> all</c><00:05:36.529><c> the</c><00:05:36.800><c> cells</c>

00:05:37.059 --> 00:05:37.069 align:start position:0%
mouse and drag it until all the cells
 

00:05:37.069 --> 00:05:39.339 align:start position:0%
mouse and drag it until all the cells
you<00:05:37.250><c> want</c><00:05:37.279><c> to</c><00:05:37.580><c> fill</c><00:05:37.909><c> are</c><00:05:38.240><c> highlighted</c><00:05:39.080><c> release</c>

00:05:39.339 --> 00:05:39.349 align:start position:0%
you want to fill are highlighted release
 

00:05:39.349 --> 00:05:42.820 align:start position:0%
you want to fill are highlighted release
the<00:05:39.589><c> mouse</c><00:05:40.039><c> and</c><00:05:40.539><c> all</c><00:05:41.539><c> the</c><00:05:41.779><c> selected</c><00:05:42.169><c> cells</c><00:05:42.379><c> are</c>

00:05:42.820 --> 00:05:42.830 align:start position:0%
the mouse and all the selected cells are
 

00:05:42.830 --> 00:05:45.730 align:start position:0%
the mouse and all the selected cells are
filled<00:05:43.099><c> with</c><00:05:43.400><c> the</c><00:05:43.490><c> word</c><00:05:43.669><c> no</c><00:05:44.089><c> you</c><00:05:44.409><c> can</c><00:05:45.409><c> use</c><00:05:45.589><c> the</c>

00:05:45.730 --> 00:05:45.740 align:start position:0%
filled with the word no you can use the
 

00:05:45.740 --> 00:05:47.860 align:start position:0%
filled with the word no you can use the
fill<00:05:45.979><c> handle</c><00:05:46.009><c> to</c><00:05:46.460><c> fill</c><00:05:46.610><c> sales</c><00:05:47.089><c> horizontally</c>

00:05:47.860 --> 00:05:47.870 align:start position:0%
fill handle to fill sales horizontally
 

00:05:47.870 --> 00:05:51.040 align:start position:0%
fill handle to fill sales horizontally
as<00:05:48.020><c> well</c><00:05:48.289><c> I</c><00:05:48.639><c> can</c><00:05:49.639><c> do</c><00:05:49.789><c> that</c><00:05:49.819><c> here</c><00:05:50.270><c> for</c><00:05:50.509><c> my</c><00:05:50.599><c> fixed</c>

00:05:51.040 --> 00:05:51.050 align:start position:0%
as well I can do that here for my fixed
 

00:05:51.050 --> 00:06:00.579 align:start position:0%
as well I can do that here for my fixed
expenses<00:05:57.639><c> you</c><00:05:58.639><c> can</c><00:05:58.669><c> imagine</c><00:05:59.539><c> how</c><00:05:59.750><c> this</c><00:06:00.110><c> can</c><00:06:00.469><c> be</c>

00:06:00.579 --> 00:06:00.589 align:start position:0%
expenses you can imagine how this can be
 

00:06:00.589 --> 00:06:04.390 align:start position:0%
expenses you can imagine how this can be
a<00:06:00.620><c> really</c><00:06:01.039><c> useful</c><00:06:01.189><c> tool</c><00:06:02.949><c> now</c><00:06:03.949><c> that</c><00:06:04.159><c> you</c><00:06:04.279><c> know</c>

00:06:04.390 --> 00:06:04.400 align:start position:0%
a really useful tool now that you know
 

00:06:04.400 --> 00:06:06.820 align:start position:0%
a really useful tool now that you know
some<00:06:04.669><c> of</c><00:06:04.699><c> the</c><00:06:04.879><c> ways</c><00:06:05.029><c> you</c><00:06:05.300><c> can</c><00:06:05.509><c> copy</c><00:06:05.839><c> cuts</c><00:06:06.560><c> and</c>

00:06:06.820 --> 00:06:06.830 align:start position:0%
some of the ways you can copy cuts and
 

00:06:06.830 --> 00:06:08.619 align:start position:0%
some of the ways you can copy cuts and
paste<00:06:07.250><c> and</c><00:06:07.550><c> move</c><00:06:07.759><c> data</c><00:06:08.060><c> around</c><00:06:08.240><c> in</c><00:06:08.509><c> a</c>

00:06:08.619 --> 00:06:08.629 align:start position:0%
paste and move data around in a
 

00:06:08.629 --> 00:06:14.850 align:start position:0%
paste and move data around in a
spreadsheet<00:06:08.960><c> why</c><00:06:09.860><c> don't</c><00:06:10.039><c> you</c><00:06:10.129><c> give</c><00:06:10.279><c> it</c><00:06:10.310><c> a</c><00:06:10.460><c> try</c>

00:06:14.850 --> 00:06:14.860 align:start position:0%
 
 

00:06:14.860 --> 00:06:16.919 align:start position:0%
 
you