WEBVTT Kind: captions Language: en 00:00:08.380 --> 00:00:15.380 In all the 2007 Microsoft applications you'll see a Clipboard group on the Home tab, which 00:00:15.799 --> 00:00:20.000 is where you'll find the Cut, Copy, and Paste commands. 00:00:20.000 --> 00:00:25.700 These commands make it very easy to copy or cut, and then paste information from cell 00:00:25.700 --> 00:00:30.660 to cell so that you don't have to type and retype information. 00:00:30.660 --> 00:00:36.480 Let's take a look at how this works. I'm happy with my spreadsheet that I've created, 00:00:36.480 --> 00:00:41.590 but I do think I'd like to add the column back here so I can mark whether I've paid 00:00:41.590 --> 00:00:48.310 my bills or not. Let's say I want to mark everything from cell 00:00:48.310 --> 00:00:55.310 C9 to C13 as paid. Instead of typing Yes in each cell, I can 00:00:55.440 --> 00:01:02.240 type Yes in C9 and copy and paste it in all the other cells. 00:01:02.240 --> 00:01:07.170 To do this, left-click the cell to select it. 00:01:07.170 --> 00:01:14.170 Then, click the Copy command. The border of the copied cell now looks like 00:01:14.679 --> 00:01:20.350 marching ants. Now, select the cell or cells where you want 00:01:20.350 --> 00:01:24.770 to paste the information. If you just want to paste the information 00:01:24.770 --> 00:01:31.770 into one cell, all you have to do is left-click the cell to select it. 00:01:33.560 --> 00:01:39.709 If you want to paste the copied information in more than one adjoining cell, just left-click 00:01:39.709 --> 00:01:46.369 one of the cells and drag your cursor until all the cells are selected. 00:01:46.369 --> 00:01:52.270 Now release the mouse button and click the Paste command. 00:01:52.270 --> 00:01:58.529 The copied cell will stay selected until you perform your next task, or you can always 00:01:58.529 --> 00:02:05.529 double- click it to deselect it. The Cut command is different from the Copy 00:02:06.389 --> 00:02:12.830 command because it actually removes information from the selected cell and moves it to another 00:02:12.830 --> 00:02:19.830 cell. For example, let's move Yes from cell C9 to 00:02:21.640 --> 00:02:28.640 C15. Select cell C9 and click the Cut command. 00:02:29.120 --> 00:02:39.980 Now, select the blank cell, and click Paste. The word Yes now appears in C15, and C9 is 00:02:39.980 --> 00:02:43.650 empty. So now you can see how the Cut command works. 00:02:43.650 --> 00:02:47.750 I actually do want to leave the word Yes in C9. 00:02:47.750 --> 00:02:53.730 Let me paste that into the cell. I can use the Paste command, or press the 00:02:53.730 --> 00:03:00.730 keyboard shortcut for Paste, which is the Control key, then the V key. 00:03:01.750 --> 00:03:08.090 Another way to move information from one cell to another is to use the drag and drop method. 00:03:08.090 --> 00:03:13.920 Drag and Drop moves the text and numbers in the cells and any formulas associated with 00:03:13.920 --> 00:03:17.930 those cells. Let's take a look at my net income 00:03:17.930 --> 00:03:22.530 for January. You can see in the formula bar that there 00:03:22.530 --> 00:03:28.450 is an addition formula associated with this cell. 00:03:28.450 --> 00:03:34.500 When I drag all of my income information to a new location in the worksheet, this formula 00:03:34.500 --> 00:03:40.400 will come along. Let's take a look at how drag and drop works. 00:03:40.400 --> 00:03:44.980 Let's select all the cells at the top with my income information. 00:03:44.980 --> 00:03:51.980 Now, position your mouse pointer near one of the outside edges of the selected cells. 00:03:54.400 --> 00:04:01.400 The mouse pointer changes from a large, white cross to a black cross with 4 arrows. 00:04:03.500 --> 00:04:07.550 Keep the mouse pointer on the edge of the selected cells. 00:04:07.550 --> 00:04:14.550 Now, left- click and hold the mouse button and drag the cells to the new location. 00:04:15.620 --> 00:04:19.840 Release the mouse button and the information appears in the new location. 00:04:19.840 --> 00:04:26.060 See how easy it was to drag all this information and drop it into a new location? Now, the 00:04:26.060 --> 00:04:32.720 really great thing is that not only did it bring all my text and numbers, it also transferred 00:04:32.720 --> 00:04:36.639 the formulas and changed them to represent their new location. 00:04:36.639 --> 00:04:46.780 Now, instead of the formula saying cell C3 plus C4, it shows the new cell addresses in 00:04:46.780 --> 00:04:52.760 the formula. One last thing that is worth showing you. 00:04:52.760 --> 00:04:58.710 In addition to the Copy, Cut, and Paste commands, and the drag and drop feature, the fill handle 00:04:58.710 --> 00:05:02.720 is another way you can quickly enter data into cells. 00:05:02.720 --> 00:05:09.720 For example, let's say I wanted to mark this group of bills as not paid. 00:05:10.680 --> 00:05:17.540 I can type No into cell C16 and then use the Fill handle to fill the other cells with the 00:05:17.540 --> 00:05:22.100 word No. The Fill handle is this little square that 00:05:22.100 --> 00:05:25.660 appears in the bottom, right corner of the cell. 00:05:25.660 --> 00:05:31.340 To use it, just position your cursor over it until the large white cross becomes a thin, 00:05:31.340 --> 00:05:36.360 black cross. Now, left-click your mouse and drag it until 00:05:36.360 --> 00:05:42.669 all the cells you want to fill are highlighted. Release the mouse button and all the selected 00:05:42.669 --> 00:05:47.270 cells are filled with the word No. You can use the Fill handle to fill cells 00:05:47.270 --> 00:05:54.270 horizontally, as well. I can do that here for all my fixed expenses. 00:05:58.650 --> 00:06:03.930 You can imagine how this can be a really useful tool. 00:06:03.930 --> 00:06:09.870 Now that you know some of the ways you can copy, cut, and paste, and move data in a spreadsheet, 00:06:09.870 --> 00:06:11.000 why don't you give it a try!