WEBVTT Kind: captions Language: en 00:00:11.309 --> 00:00:16.180 Every worksheet contains thousands of cells where different columns and rows intersect. 00:00:16.180 --> 00:00:21.180 You'll need to know how to work with these cells in order to enter and edit data. 00:00:21.180 --> 00:00:26.189 Every cell has it own name based on its location, sometimes called a cell address. 00:00:26.189 --> 00:00:31.160 In this example, the cell I've selected is where column D and row 6 intersect, making 00:00:31.160 --> 00:00:33.510 the cell address D6. 00:00:33.510 --> 00:00:37.400 The address also appears in the name box above the worksheet. 00:00:37.400 --> 00:00:40.949 To select a cell, just click. 00:00:40.949 --> 00:00:45.160 You can even use the arrow keys on your keyboard to navigate between cells, instead of clicking 00:00:45.160 --> 00:00:47.199 with your mouse. 00:00:47.199 --> 00:00:51.540 To select more than one cell at a time (known as a cell range), click and drag, and the 00:00:51.540 --> 00:00:54.600 entire range will be highlighted. 00:00:54.600 --> 00:00:59.489 You can enter lots of things into a cell; for example, all of mine contain text. 00:00:59.489 --> 00:01:03.600 But they can contain advanced properties, too, like formulas, functions, and formatting 00:01:03.600 --> 00:01:04.739 elements. 00:01:04.739 --> 00:01:07.350 For now, I'd just like to show you the basics. 00:01:07.350 --> 00:01:11.060 We'll start with inserting content into a cell. 00:01:11.060 --> 00:01:14.840 This person has just confirmed that she completed Part 2 of the training. 00:01:14.840 --> 00:01:19.539 So I'm going to select cell F9… then type an "x." 00:01:19.539 --> 00:01:23.570 It appears in the cell and in the formula bar, where you can also enter or edit the 00:01:23.570 --> 00:01:25.030 contents of your cell. 00:01:25.030 --> 00:01:29.869 In fact, I'm going to take this opportunity to change the "x" to a capital "X," so it's 00:01:29.869 --> 00:01:32.929 consistent with the rest of the list. 00:01:32.929 --> 00:01:35.590 Now for the next person—Walter. 00:01:35.590 --> 00:01:41.439 Although it looks like I've made a mistake—he's on the list twice, both here… and here. 00:01:41.439 --> 00:01:47.610 I'm just going to clear the contents of the extra row by selecting the cells… then clicking 00:01:47.610 --> 00:01:52.530 the Clear command on the ribbon… and choosing Clear Contents. 00:01:52.530 --> 00:01:55.630 You can also use Backspace or Delete on your keyboard. 00:01:55.630 --> 00:01:58.499 So let's take a look at what that did. 00:01:58.499 --> 00:02:01.689 It cleared the contents of the cells, but the row is still there. 00:02:01.689 --> 00:02:03.070 That's okay. 00:02:03.070 --> 00:02:07.179 If you want to delete the cells all together, all you have to do is click the Delete command 00:02:07.179 --> 00:02:08.600 instead. 00:02:08.600 --> 00:02:12.960 That actually removes the cells from the worksheet, causing the cells underneath to shift up and 00:02:12.960 --> 00:02:14.650 fill in the gap. 00:02:14.650 --> 00:02:18.300 Just remember that there's a difference between clearing and deleting cells, so you don't 00:02:18.300 --> 00:02:21.799 accidentally delete any cells that you want to keep. 00:02:21.799 --> 00:02:25.799 Now I'd like to show you a way to save time by copying and pasting content. 00:02:25.799 --> 00:02:30.850 For example, I need to mark the rest of the people who completed Part 2 of the training. 00:02:30.850 --> 00:02:35.409 Start by clicking the cell you want… then click Copy on the ribbon. 00:02:35.409 --> 00:02:39.239 (Note the dashed box that appears around the copied cell.) 00:02:39.239 --> 00:02:47.099 Next, select the cells where you want the content to go… then click Paste. 00:02:47.099 --> 00:02:51.320 To access more paste options, open the drop-down menu here. 00:02:51.320 --> 00:02:55.010 These commands will come in handy if you're copying and pasting cells that contain formulas 00:02:55.010 --> 00:02:58.030 or advanced formatting. 00:02:58.030 --> 00:03:01.269 You can also get to these commands by right-clicking in the worksheet. 00:03:01.269 --> 00:03:09.120 For example, to cut and paste, select your cells… then right-click… and choose Cut. 00:03:09.120 --> 00:03:15.060 The original content will disappear as soon as you paste it in a new location. 00:03:15.060 --> 00:03:19.420 There's also the drag and drop technique for moving cells from one place to another. 00:03:19.420 --> 00:03:24.640 To drag and drop, start by selecting your cells… then place your cursor on an outside 00:03:24.640 --> 00:03:25.640 edge. 00:03:25.640 --> 00:03:29.830 As you can see, it turns into a symbol with four arrows and a pointer. 00:03:29.830 --> 00:03:34.819 Now click, hold, and drag the cells wherever you want them to go, then release your mouse. 00:03:34.819 --> 00:03:36.349 There, that's much better. 00:03:36.349 --> 00:03:42.090 To mark the rest of the people who've completed Part 3, I'm going use one of my favorite techniques—filling 00:03:42.090 --> 00:03:44.239 in cells with the fill handle. 00:03:44.239 --> 00:03:49.160 You can fill vertically or horizontally by selecting the cell you want to use… then 00:03:49.160 --> 00:03:53.549 clicking and dragging the square in the bottom right corner. 00:03:53.549 --> 00:03:58.340 The fill handle can also be used to continue a series; for example, numbers, dates, and 00:03:58.340 --> 00:04:01.709 other information that's listed in sequential order. 00:04:01.709 --> 00:04:04.849 See what happens when I use the technique on my header row? 00:04:04.849 --> 00:04:08.239 It continues the series up to Part 6. 00:04:08.239 --> 00:04:12.489 Excel is actually pretty good at filling in certain types of data automatically. 00:04:12.489 --> 00:04:14.980 Take the new flash fill feature. 00:04:14.980 --> 00:04:18.940 Flash fill can enter data for you by picking up on simple patterns, and guessing what you 00:04:18.940 --> 00:04:20.560 plan to type. 00:04:20.560 --> 00:04:24.440 In this example, we'll use the feature to enter each person's first initial and last 00:04:24.440 --> 00:04:28.960 name, which will serve as their username. 00:04:28.960 --> 00:04:32.930 Flash fill eventually figures out what I want, and uses the data in the first name and last 00:04:32.930 --> 00:04:35.220 name columns to complete the series. 00:04:35.220 --> 00:04:41.530 All you have to do is press Enter to confirm… and the data will be added to the worksheet. 00:04:41.530 --> 00:04:47.120 Finally, in workbooks with lots of data, I sometimes have trouble finding a specific 00:04:47.120 --> 00:04:50.160 word or phrase that I know is in there somewhere. 00:04:50.160 --> 00:04:54.030 The Find feature can help by searching the workbook for you. 00:04:54.030 --> 00:04:56.560 Just click Find & Select on the ribbon. 00:04:56.560 --> 00:05:02.080 Then choose Find… and type the word or phrase you're looking for. 00:05:02.080 --> 00:05:05.490 When you're done, click Find Next in the dialog box. 00:05:05.490 --> 00:05:10.430 If the word or phrase is found, the cell containing it will be selected. 00:05:10.430 --> 00:05:13.530 At times, you may find that you've made a mistake throughout your workbook, or you need 00:05:13.530 --> 00:05:16.530 to swap a certain word or phrase for another. 00:05:16.530 --> 00:05:19.370 For that, you can use the Replace feature instead. 00:05:19.370 --> 00:05:24.560 I actually need to change the name of this department from Accounting to… 00:05:24.560 --> 00:05:26.060 Finance. 00:05:26.060 --> 00:05:32.090 To continue, go ahead and click Replace… and it will jump to the next instance automatically. 00:05:32.090 --> 00:05:37.450 If you want to skip the current instance without replacing it, click Find Next instead. 00:05:37.450 --> 00:05:43.970 Alternatively, to replace every instance without having to review each one, click Replace All… 00:05:43.970 --> 00:05:48.360 and the entire workbook will be updated. 00:05:48.360 --> 00:05:53.070 Now you know the basics, including insert and delete; cut, copy, and paste; and other 00:05:53.070 --> 00:05:57.990 time-saving techniques… everything you need to work with cells in Excel 2013.