1 00:00:00,05 --> 00:00:02,05 - [Instructor] You can delete a column or row 2 00:00:02,05 --> 00:00:04,03 by clicking the number or letter 3 00:00:04,03 --> 00:00:06,03 to select the entire row, 4 00:00:06,03 --> 00:00:07,05 and then either hitting 5 00:00:07,05 --> 00:00:09,06 the Delete key on the Home ribbon tab 6 00:00:09,06 --> 00:00:12,09 or right-clicking and choosing Delete. 7 00:00:12,09 --> 00:00:14,07 The row disappears. 8 00:00:14,07 --> 00:00:17,02 I'll hit Ctrl Z to undo that. 9 00:00:17,02 --> 00:00:19,02 You can also select multiple rows 10 00:00:19,02 --> 00:00:21,02 by clicking and dragging with your mouse, 11 00:00:21,02 --> 00:00:23,01 and doing it the same way. 12 00:00:23,01 --> 00:00:26,01 By the way, I don't want to hit the delete key on my keyboard 13 00:00:26,01 --> 00:00:27,06 because all that's going to do 14 00:00:27,06 --> 00:00:29,07 is delete the contents of the cell. 15 00:00:29,07 --> 00:00:32,07 It's still going to leave these big gaps. 16 00:00:32,07 --> 00:00:34,07 If I want to delete the actual rows 17 00:00:34,07 --> 00:00:36,00 and have no gaps, 18 00:00:36,00 --> 00:00:38,01 I need to right-click and choose Delete, 19 00:00:38,01 --> 00:00:41,04 or use that Delete button on the Home ribbon tab. 20 00:00:41,04 --> 00:00:43,09 So again, I selected multiple rows, 21 00:00:43,09 --> 00:00:45,03 right-clicked and deleted, 22 00:00:45,03 --> 00:00:47,02 and they're both gone. 23 00:00:47,02 --> 00:00:49,07 There is a gotcha, however, 24 00:00:49,07 --> 00:00:51,07 if I select this entire row, 25 00:00:51,07 --> 00:00:54,01 and right-click and hit Delete, 26 00:00:54,01 --> 00:00:55,05 look what happened, 27 00:00:55,05 --> 00:00:58,08 it also deleted this data over here. 28 00:00:58,08 --> 00:01:00,08 Sometimes there's more data here, 29 00:01:00,08 --> 00:01:01,09 and we got lucky this time 30 00:01:01,09 --> 00:01:03,07 because I could see it. 31 00:01:03,07 --> 00:01:05,03 You just never know. 32 00:01:05,03 --> 00:01:07,01 I could have to scroll all the way to the right 33 00:01:07,01 --> 00:01:08,03 to see some excess data 34 00:01:08,03 --> 00:01:13,06 that's not connected to my original data source. 35 00:01:13,06 --> 00:01:15,00 You can get around this 36 00:01:15,00 --> 00:01:17,07 by only selecting the amount of contents 37 00:01:17,07 --> 00:01:20,00 that you actually want to delete, 38 00:01:20,00 --> 00:01:23,05 and you can even do that with multiple rows. 39 00:01:23,05 --> 00:01:26,06 Now, when I right-click and select Delete, 40 00:01:26,06 --> 00:01:28,03 I get a new menu option. 41 00:01:28,03 --> 00:01:31,04 It's asking me what do I want to do? 42 00:01:31,04 --> 00:01:34,02 Before, we were deleting the entire row, 43 00:01:34,02 --> 00:01:37,04 but this time, we want to ship the cells up. 44 00:01:37,04 --> 00:01:39,09 If I say OK, 45 00:01:39,09 --> 00:01:41,08 it only shifted these cells up, 46 00:01:41,08 --> 00:01:44,05 it left this entire table here on the right-hand side 47 00:01:44,05 --> 00:01:46,08 completely intact. 48 00:01:46,08 --> 00:01:49,01 You can do the same thing with a column. 49 00:01:49,01 --> 00:01:50,09 To delete a column, 50 00:01:50,09 --> 00:01:52,05 click the column letter, 51 00:01:52,05 --> 00:01:55,00 right-click and choose Delete. 52 00:01:55,00 --> 00:01:57,07 And again, if I hit the delete key on my keyboard, 53 00:01:57,07 --> 00:01:59,06 it's just going to leave me with a blank column, 54 00:01:59,06 --> 00:02:03,00 and that's not what we want. 55 00:02:03,00 --> 00:02:04,04 So as you can see, 56 00:02:04,04 --> 00:02:06,06 sometimes you need to be careful. 57 00:02:06,06 --> 00:02:08,06 I chose that column on purpose 58 00:02:08,06 --> 00:02:10,03 because this column 59 00:02:10,03 --> 00:02:13,00 relied on that other column for a formula, 60 00:02:13,00 --> 00:02:14,04 and now I messed it up 61 00:02:14,04 --> 00:02:16,01 and the formula doesn't work. 62 00:02:16,01 --> 00:02:19,00 so I'll undo that. 63 00:02:19,00 --> 00:02:23,06 If I delete this one, 64 00:02:23,06 --> 00:02:26,05 no problem. 65 00:02:26,05 --> 00:02:28,09 Now, maybe I don't want to see this phone number, 66 00:02:28,09 --> 00:02:30,04 or I don't want somebody else 67 00:02:30,04 --> 00:02:32,08 to be able to see everybody else's phone numbers, 68 00:02:32,08 --> 00:02:35,07 I can hide this column. 69 00:02:35,07 --> 00:02:38,04 I'll right-click and choose Hide, 70 00:02:38,04 --> 00:02:41,03 just like we could with worksheet tabs. 71 00:02:41,03 --> 00:02:42,03 It's not gone, 72 00:02:42,03 --> 00:02:43,04 it's not deleted, 73 00:02:43,04 --> 00:02:48,03 it's just hidden. 74 00:02:48,03 --> 00:02:50,05 Now, it's very hard to see, 75 00:02:50,05 --> 00:02:52,03 but I do have a visual cue 76 00:02:52,03 --> 00:02:54,00 that there's a hidden column in here, 77 00:02:54,00 --> 00:02:55,08 because there's now two lines 78 00:02:55,08 --> 00:02:59,03 in between columns B and column D. 79 00:02:59,03 --> 00:03:01,03 If I want to get that column back, 80 00:03:01,03 --> 00:03:02,04 I can put my mouse 81 00:03:02,04 --> 00:03:04,03 right in between those two columns 82 00:03:04,03 --> 00:03:06,04 and double-click. 83 00:03:06,04 --> 00:03:09,00 It's going to bring that column back. 84 00:03:09,00 --> 00:03:13,09 If I have multiple hidden columns, 85 00:03:13,09 --> 00:03:17,05 I'll right-click this one, 86 00:03:17,05 --> 00:03:20,03 and choose Hide. 87 00:03:20,03 --> 00:03:24,07 And maybe I want to hide their address also. 88 00:03:24,07 --> 00:03:29,01 I'll also right-click this one and choose Hide. 89 00:03:29,01 --> 00:03:32,03 They certainly don't have to be next to each other. 90 00:03:32,03 --> 00:03:34,05 If I want to bring back all of them, 91 00:03:34,05 --> 00:03:36,03 I can select everything 92 00:03:36,03 --> 00:03:38,08 by clicking right in the top-leftmost column 93 00:03:38,08 --> 00:03:40,00 of the spreadsheet. 94 00:03:40,00 --> 00:03:42,00 From here, all I have to do 95 00:03:42,00 --> 00:03:44,06 is double-click between any column 96 00:03:44,06 --> 00:03:47,00 and it's going to bring them all back.