1 00:00:00,03 --> 00:00:02,02 - [Instructor] You can edit text or values 2 00:00:02,02 --> 00:00:03,08 in a cell directly. 3 00:00:03,08 --> 00:00:05,01 To start editing values, 4 00:00:05,01 --> 00:00:07,03 just put your cursor right in a cell. 5 00:00:07,03 --> 00:00:09,01 From here, you can start typing 6 00:00:09,01 --> 00:00:11,04 and it's going to overwrite what's already in there. 7 00:00:11,04 --> 00:00:14,05 Hit the Enter key and the value's been changed. 8 00:00:14,05 --> 00:00:16,04 While the cell is selected, 9 00:00:16,04 --> 00:00:20,00 you'll also notice up here in what's called the formula bar, 10 00:00:20,00 --> 00:00:22,04 you can see what's in that cell. 11 00:00:22,04 --> 00:00:24,07 I can click right from here. 12 00:00:24,07 --> 00:00:26,05 And when I see the blinking cursor, 13 00:00:26,05 --> 00:00:31,00 I can also edit that value right in the formula bar. 14 00:00:31,00 --> 00:00:33,03 The last way I might want to edit a cell 15 00:00:33,03 --> 00:00:35,07 is to double click inside the cell. 16 00:00:35,07 --> 00:00:39,01 For example, let's take a look at this word receiver, 17 00:00:39,01 --> 00:00:40,06 which I've spelled wrong. 18 00:00:40,06 --> 00:00:43,02 I can double click right inside the cell. 19 00:00:43,02 --> 00:00:44,05 There's the blinking cursor, 20 00:00:44,05 --> 00:00:47,09 and I can make my change and hit the Enter key. 21 00:00:47,09 --> 00:00:51,00 Let's move all of these years up by one. 22 00:00:51,00 --> 00:00:53,03 Even though there's already data in here, 23 00:00:53,03 --> 00:00:56,07 I can still come in and start typing 24 00:00:56,07 --> 00:00:58,00 and hit the Tab key 25 00:00:58,00 --> 00:01:08,08 and continue to type as if they were empty. 26 00:01:08,08 --> 00:01:10,04 So now that we've made some changes, 27 00:01:10,04 --> 00:01:12,04 that's how you edit a cell. 28 00:01:12,04 --> 00:01:13,08 But Excel also comes 29 00:01:13,08 --> 00:01:16,08 with something really neat called autofill. 30 00:01:16,08 --> 00:01:19,06 This is a quick way to do data entry. 31 00:01:19,06 --> 00:01:23,01 Autofill allows you to quickly populate the same value 32 00:01:23,01 --> 00:01:26,00 in multiple cells in a row or a column, 33 00:01:26,00 --> 00:01:27,08 and it can even do series 34 00:01:27,08 --> 00:01:30,00 such as counting every other number, 35 00:01:30,00 --> 00:01:33,06 counting by 5s, dates, et cetera. 36 00:01:33,06 --> 00:01:34,08 Let's take a look. 37 00:01:34,08 --> 00:01:37,00 I'll start by putting in some text. 38 00:01:37,00 --> 00:01:37,09 I'll just pick a word. 39 00:01:37,09 --> 00:01:39,00 How about apples? 40 00:01:39,00 --> 00:01:40,03 Maybe I'm hungry. 41 00:01:40,03 --> 00:01:41,08 If I hold my cursor 42 00:01:41,08 --> 00:01:46,02 at the very bottom right hand side of the cell, 43 00:01:46,02 --> 00:01:49,01 the icon changes to a plus sign. 44 00:01:49,01 --> 00:01:50,08 With that crosshair icon, 45 00:01:50,08 --> 00:01:52,05 I can click and drag 46 00:01:52,05 --> 00:01:56,07 and it's going to fill that word for as far as I drag. 47 00:01:56,07 --> 00:02:04,02 This works vertically and it also works horizontally. 48 00:02:04,02 --> 00:02:06,08 I can drag it out as far as I want to. 49 00:02:06,08 --> 00:02:08,03 So it works for text, 50 00:02:08,03 --> 00:02:11,07 but it also works for numbers. 51 00:02:11,07 --> 00:02:15,06 I'll put in a series 52 00:02:15,06 --> 00:02:17,02 and click and drag, 53 00:02:17,02 --> 00:02:19,01 and there it is. 54 00:02:19,01 --> 00:02:24,06 This time, I'm going to put in a 1 followed by a 2. 55 00:02:24,06 --> 00:02:26,01 To do a series, 56 00:02:26,01 --> 00:02:28,03 you need to highlight both cells. 57 00:02:28,03 --> 00:02:29,07 On the bottom cell, 58 00:02:29,07 --> 00:02:34,02 click the crosshair and repeat the process. 59 00:02:34,02 --> 00:02:35,09 It's going to start counting down, 60 00:02:35,09 --> 00:02:39,00 and you'll notice it even copied the formatting, 61 00:02:39,00 --> 00:02:41,09 every other cell is bold faced. 62 00:02:41,09 --> 00:02:49,04 You can do it by every other number or counting by 5s. 63 00:02:49,04 --> 00:02:51,08 As long as you've selected both cells, 64 00:02:51,08 --> 00:02:53,08 it's worth playing around to see if Excel 65 00:02:53,08 --> 00:02:59,09 can figure out what you're trying to do in that series. 66 00:02:59,09 --> 00:03:01,09 It can even do dates. 67 00:03:01,09 --> 00:03:04,00 I'm going to delete the values in these cells 68 00:03:04,00 --> 00:03:05,02 by clicking and dragging 69 00:03:05,02 --> 00:03:08,01 and hitting the Delete key on my keyboard. 70 00:03:08,01 --> 00:03:10,04 I'm going to type Jan. 71 00:03:10,04 --> 00:03:12,00 Now, if I spread these out, 72 00:03:12,00 --> 00:03:16,00 it's going to fill in these months. 73 00:03:16,00 --> 00:03:18,06 And I don't have to use the abbreviations either. 74 00:03:18,06 --> 00:03:22,04 I can type the whole word, such as January or February. 75 00:03:22,04 --> 00:03:23,07 Something really great 76 00:03:23,07 --> 00:03:28,05 is that I can even do a series combined with other words. 77 00:03:28,05 --> 00:03:30,06 I'm going to delete this 78 00:03:30,06 --> 00:03:35,01 and I'm also going to delete the title that says Units Sold. 79 00:03:35,01 --> 00:03:38,04 Let's say we want to go back to the same year that we had, 80 00:03:38,04 --> 00:03:39,06 except this time, 81 00:03:39,06 --> 00:03:43,08 I'm going to say the year and the word Units Sold after. 82 00:03:43,08 --> 00:03:51,09 For example, 2019 Units Sold. 83 00:03:51,09 --> 00:03:53,04 I'll make the text a little bit smaller 84 00:03:53,04 --> 00:03:55,01 so that we can see it, 85 00:03:55,01 --> 00:03:57,03 and I'll stretch this out 86 00:03:57,03 --> 00:04:01,02 and it's going to fill in the entire series. 87 00:04:01,02 --> 00:04:05,03 I'll come up here and angle this clockwise. 88 00:04:05,03 --> 00:04:07,04 Now we can see it a little more clearly, 89 00:04:07,04 --> 00:04:08,09 but it kept the pattern 90 00:04:08,09 --> 00:04:10,09 and the text that followed it. 91 00:04:10,09 --> 00:04:12,07 This is a really cool feature. 92 00:04:12,07 --> 00:04:14,01 So you can edit text 93 00:04:14,01 --> 00:04:16,04 and you can also have Excel use autofills 94 00:04:16,04 --> 00:04:18,00 to do your work for you.