1 00:00:00,05 --> 00:00:02,02 - [Instructor] To delete data from a cell, 2 00:00:02,02 --> 00:00:05,04 all you need to do is place the cursor inside that cell 3 00:00:05,04 --> 00:00:06,09 and hit the Delete key. 4 00:00:06,09 --> 00:00:08,06 It's going a blank it out. 5 00:00:08,06 --> 00:00:09,04 In fact, 6 00:00:09,04 --> 00:00:12,09 you can click and drag with your mouse to select more data. 7 00:00:12,09 --> 00:00:16,02 You can select and delete entire columns and rows 8 00:00:16,02 --> 00:00:19,05 and drag the mouse and change anywhere 9 00:00:19,05 --> 00:00:21,05 that you can see this highlighted text. 10 00:00:21,05 --> 00:00:22,08 You can hit the Delete key 11 00:00:22,08 --> 00:00:25,08 and it's going to delete everything. 12 00:00:25,08 --> 00:00:28,07 Now, this is not to be confused with swapping cells 13 00:00:28,07 --> 00:00:31,00 and deleting entire columns and rows 14 00:00:31,00 --> 00:00:33,03 and worrying about those gaps in the middle. 15 00:00:33,03 --> 00:00:35,04 We're going to learn how to take care of all of that 16 00:00:35,04 --> 00:00:37,06 when we talk about columns and rows. 17 00:00:37,06 --> 00:00:40,04 Right now, I'm just making sure that you understand 18 00:00:40,04 --> 00:00:42,09 how to delete data from cells. 19 00:00:42,09 --> 00:00:45,07 Now, you can also copy data from cells. 20 00:00:45,07 --> 00:00:50,01 The easiest way to do this is to use keyboard shortcuts. 21 00:00:50,01 --> 00:00:53,02 I'm going to start by copying everything. 22 00:00:53,02 --> 00:00:55,09 Maybe you just want another copy to work with. 23 00:00:55,09 --> 00:00:58,06 So I'll click and drag to select all my text, 24 00:00:58,06 --> 00:01:02,03 and I'm going to hit Control or Command if you're on a Mac, 25 00:01:02,03 --> 00:01:05,01 C to copy. 26 00:01:05,01 --> 00:01:06,07 And then I'll place my cursor below 27 00:01:06,07 --> 00:01:12,00 where I want to paste the data and hit Control or Command + V. 28 00:01:12,00 --> 00:01:16,05 Now I have an entirely new copy of all that data. 29 00:01:16,05 --> 00:01:18,01 You'll notice in this column 30 00:01:18,01 --> 00:01:21,01 if I come up here to the formula bar, this is a formula. 31 00:01:21,01 --> 00:01:24,00 Now, we haven't done that yet, so don't worry. 32 00:01:24,00 --> 00:01:28,02 But what it does is it takes the contents of the column A, 33 00:01:28,02 --> 00:01:29,04 that is the first name, 34 00:01:29,04 --> 00:01:31,09 and the contents of column B, the last name, 35 00:01:31,09 --> 00:01:34,08 and combines them to form one name. 36 00:01:34,08 --> 00:01:37,01 But it copied everything. 37 00:01:37,01 --> 00:01:41,01 I'm going to undo this. 38 00:01:41,01 --> 00:01:44,01 Something else that you can do is drag data. 39 00:01:44,01 --> 00:01:47,06 Sometimes it's just easier and faster. 40 00:01:47,06 --> 00:01:50,00 I'll select all my text, 41 00:01:50,00 --> 00:01:52,00 and if I slowly move my cursor 42 00:01:52,00 --> 00:01:54,07 to the right edge of the selected text, 43 00:01:54,07 --> 00:01:57,06 you'll see the moment it changes to a crosshair. 44 00:01:57,06 --> 00:02:01,03 Now all I need to do is slide the data around. 45 00:02:01,03 --> 00:02:03,09 I can put it wherever I want it. 46 00:02:03,09 --> 00:02:06,03 Maybe I just want to move it down a few rows, 47 00:02:06,03 --> 00:02:10,03 I can let go and it's going to move everything. 48 00:02:10,03 --> 00:02:12,06 I'll do that one more time. 49 00:02:12,06 --> 00:02:15,07 I can move it back to where it was. 50 00:02:15,07 --> 00:02:19,09 There is one situation I need to tell you about. 51 00:02:19,09 --> 00:02:21,05 Remember this formula, 52 00:02:21,05 --> 00:02:24,08 when we copied everything, it kept everything intact. 53 00:02:24,08 --> 00:02:27,04 So if I copy this first and last name field 54 00:02:27,04 --> 00:02:30,04 along with my formula column and paste it somewhere else, 55 00:02:30,04 --> 00:02:32,03 it's going to keep everything intact. 56 00:02:32,03 --> 00:02:33,09 We've seen that. 57 00:02:33,09 --> 00:02:36,05 But if I copy only this name column, 58 00:02:36,05 --> 00:02:38,00 the one with a formula, 59 00:02:38,00 --> 00:02:43,08 and paste it somewhere else, watch what happens. 60 00:02:43,08 --> 00:02:45,06 Everything's blank. 61 00:02:45,06 --> 00:02:48,02 That is because sometimes your data 62 00:02:48,02 --> 00:02:50,05 is going to be considered absolute, 63 00:02:50,05 --> 00:02:53,05 and sometimes the formulas are going to be relative. 64 00:02:53,05 --> 00:02:56,04 That is sometimes they're going to be locked in 65 00:02:56,04 --> 00:02:58,03 to where they are in that sheet, 66 00:02:58,03 --> 00:03:00,08 and sometimes they're going to move around. 67 00:03:00,08 --> 00:03:02,03 In cases like these, 68 00:03:02,03 --> 00:03:06,00 we can paste the values of the end results of the formula. 69 00:03:06,00 --> 00:03:08,06 That is, I don't care about the formula, 70 00:03:08,06 --> 00:03:12,02 I just need Cally Reynolds' name to be in this cell. 71 00:03:12,02 --> 00:03:14,05 Maybe I just need to print something off quickly 72 00:03:14,05 --> 00:03:17,04 to show a manager or a quick report. 73 00:03:17,04 --> 00:03:21,06 In that case, I can paste these as values. 74 00:03:21,06 --> 00:03:24,09 I'll select my data again by clicking and dragging. 75 00:03:24,09 --> 00:03:28,02 I'll copy it by hitting Command + C. 76 00:03:28,02 --> 00:03:30,01 And I'll come over to the column. 77 00:03:30,01 --> 00:03:33,08 But this time, instead of using keyboard shortcuts to paste, 78 00:03:33,08 --> 00:03:37,08 I'll use the Home ribbon tab to do my copying and pasting. 79 00:03:37,08 --> 00:03:40,02 In fact, here's the icons right here. 80 00:03:40,02 --> 00:03:44,00 And if I hover my mouse over them, I can see where they are. 81 00:03:44,00 --> 00:03:47,03 I'm going to click the down arrow next to paste. 82 00:03:47,03 --> 00:03:51,00 Here I can see this paste values area. 83 00:03:51,00 --> 00:03:53,07 And in fact, if I hover my mouse over it, 84 00:03:53,07 --> 00:03:57,01 I can see a preview as to what's going to happen. 85 00:03:57,01 --> 00:03:59,01 As you can see in column G, 86 00:03:59,01 --> 00:04:01,09 if I hover my mouse over that paste values button, 87 00:04:01,09 --> 00:04:05,05 I can see the names are going to be correctly populated. 88 00:04:05,05 --> 00:04:08,00 If I hover my mouse over the regular paste button, 89 00:04:08,00 --> 00:04:09,02 everything gets blank. 90 00:04:09,02 --> 00:04:11,08 So that's how I know that's going to happen already. 91 00:04:11,08 --> 00:04:14,04 I want to stick with paste values. 92 00:04:14,04 --> 00:04:18,06 This is the results I want so I'll select it. 93 00:04:18,06 --> 00:04:19,06 And here I can see, 94 00:04:19,06 --> 00:04:23,02 especially in the formula bar, it's not a formula anymore, 95 00:04:23,02 --> 00:04:24,08 it's just a value. 96 00:04:24,08 --> 00:04:29,01 It pasted the values that were the result of the formula. 97 00:04:29,01 --> 00:04:30,00 So remember, 98 00:04:30,00 --> 00:04:32,01 this isn't going to be good for every situation, 99 00:04:32,01 --> 00:04:35,01 especially if it's a number crunching situation 100 00:04:35,01 --> 00:04:37,07 in which you need to know what that formula was 101 00:04:37,07 --> 00:04:40,05 to know how you arrived at that figure. 102 00:04:40,05 --> 00:04:43,06 But in this case, I just needed a list of names. 103 00:04:43,06 --> 00:04:45,03 Remember, I was just going to print it out 104 00:04:45,03 --> 00:04:46,08 or email it to my manager 105 00:04:46,08 --> 00:04:49,02 and it fit my needs just fine. 106 00:04:49,02 --> 00:04:52,07 So that's when pasting values is a great solution. 107 00:04:52,07 --> 00:04:55,09 It won't be good all the time, but in this case it was. 108 00:04:55,09 --> 00:04:59,01 So that is how you can delete cells and move them around 109 00:04:59,01 --> 00:05:01,00 and copy and paste them.