WEBVTT Kind: captions Language: en 00:00:08.660 --> 00:00:13.830 Every worksheet contains thousands of cells where different columns and rows intersect. 00:00:13.830 --> 00:00:19.110 You'll need to know how to work with these cells in order to enter and edit data. 00:00:19.110 --> 00:00:23.990 Every cell has it own name based on its location, sometimes called a cell address. 00:00:23.990 --> 00:00:29.289 In this example, the cell I've selected is where column D and row 6 intersect, making 00:00:29.289 --> 00:00:31.730 the cell address D6. 00:00:31.730 --> 00:00:36.390 The address also appears in the name box above the worksheet. 00:00:36.390 --> 00:00:38.850 To select a cell, just click it. 00:00:38.850 --> 00:00:43.160 You can even use the arrow keys on your keyboard to navigate between, instead of clicking with 00:00:43.160 --> 00:00:44.990 your mouse. 00:00:44.990 --> 00:00:49.510 To select more than one cell at a time (known as a cell range), click and drag, and the 00:00:49.510 --> 00:00:52.620 entire range will be highlighted. 00:00:52.620 --> 00:00:57.370 You can enter lots of things into a cell; for example, all of mine contain text. 00:00:57.370 --> 00:01:02.039 But they can contain advanced properties, too, like formulas, functions, and formatting 00:01:02.039 --> 00:01:03.239 elements. 00:01:03.239 --> 00:01:05.820 For now, I'd just like to show you the basics. 00:01:05.820 --> 00:01:09.270 We'll start with inserting content into a cell. 00:01:09.270 --> 00:01:12.970 This person has just confirmed that she completed Part 2 of the training. 00:01:12.970 --> 00:01:18.470 So I'm going to select cell F9… then type an "x." 00:01:18.470 --> 00:01:22.520 It appears in the cell and in the formula bar, where you can also enter or edit the 00:01:22.520 --> 00:01:24.220 contents of your cell. 00:01:24.220 --> 00:01:28.720 In fact, I'm going to take this opportunity to change the "x" to a capital "X," so it's 00:01:28.720 --> 00:01:31.940 consistent with the rest of the list. 00:01:31.940 --> 00:01:34.450 Now for the next person: Walter. 00:01:34.450 --> 00:01:40.200 Although it looks like I've made a mistake—he's on the list twice, both here… and here. 00:01:40.200 --> 00:01:46.179 I'm just going to clear the contents of the extra row by selecting the cells… then clicking 00:01:46.179 --> 00:01:51.670 the Clear command on the ribbon… and choosing Clear Contents. 00:01:51.670 --> 00:01:55.720 You can also use Backspace or Delete on your keyboard. 00:01:55.720 --> 00:01:57.660 So let's take a look at what that did. 00:01:57.660 --> 00:02:01.130 It cleared the contents of the cells, but the row is still there. 00:02:01.130 --> 00:02:02.190 That's okay. 00:02:02.190 --> 00:02:06.450 If you want to delete the cells all together, all you have to do is click the Delete command 00:02:06.450 --> 00:02:08.179 instead. 00:02:08.179 --> 00:02:12.780 That actually removes the cells from the worksheet, causing the cells underneath to shift up and 00:02:12.780 --> 00:02:14.460 fill in the gap. 00:02:14.460 --> 00:02:18.180 Just remember that there's a difference between clearing and deleting cells, so you don't 00:02:18.180 --> 00:02:22.220 accidentally delete any cells that you want to keep. 00:02:22.220 --> 00:02:26.500 Now I'd like to show you a way to save time by copying and pasting content. 00:02:26.500 --> 00:02:31.360 For example, I need to mark the rest of the people who completed Part 2 of the training. 00:02:31.360 --> 00:02:35.800 Start by clicking the cell you want… then click Copy on the ribbon. 00:02:35.800 --> 00:02:40.180 You’ll see a dashed box that appears around the copied cell. 00:02:40.180 --> 00:02:47.000 Next, select the cells where you want the content to go then click Paste. 00:02:47.000 --> 00:02:51.140 To access more paste options, open the drop-down menu here. 00:02:51.140 --> 00:02:55.090 These commands will come in handy if you're copying and pasting cells that contain formulas 00:02:55.090 --> 00:02:57.400 or advanced formatting. 00:02:57.400 --> 00:03:01.110 You can also get to these commands by right-clicking in the worksheet. 00:03:01.110 --> 00:03:08.220 For example, to cut and paste, select your cells… then right-click… and choose Cut. 00:03:08.220 --> 00:03:13.900 The original content will disappear as soon as you paste it in a new location. 00:03:13.900 --> 00:03:18.100 There's also the drag and drop technique for moving cells from one place to another. 00:03:18.100 --> 00:03:23.390 To drag and drop, start by selecting your cells… then place your cursor on an outside 00:03:23.390 --> 00:03:24.400 edge. 00:03:24.400 --> 00:03:28.430 As you can see, it turns into a symbol with four arrows and a pointer. 00:03:28.430 --> 00:03:34.290 Now click, hold, and drag the cells wherever you want them to go, then release your mouse… 00:03:34.290 --> 00:03:36.540 and the cells have moved to their new location. 00:03:36.540 --> 00:03:43.150 To mark the rest of the people who've completed Part 3, I'm going use one of my favorite techniques—filling 00:03:43.150 --> 00:03:45.200 in cells with the fill handle. 00:03:45.200 --> 00:03:50.320 You can fill vertically or horizontally by selecting the cell you want to use … then 00:03:50.320 --> 00:03:55.070 clicking and dragging the square in the bottom right corner. 00:03:55.070 --> 00:04:00.400 The fill handle can also be used to continue a series; for example, numbers, dates, and 00:04:00.400 --> 00:04:03.490 other information that's listed in sequential order. 00:04:03.490 --> 00:04:06.560 See what happens when I use the technique on my header row? 00:04:06.560 --> 00:04:09.980 It continues the series up to Part 6. 00:04:09.980 --> 00:04:15.210 Now you know the basics, including insert and delete; cut, copy, and paste; and other 00:04:15.210 --> 00:04:19.320 time-saving techniques… everything you need to work with cells in Excel.