1 00:00:00,05 --> 00:00:01,06 - [Instructor] Remember this spreadsheet 2 00:00:01,06 --> 00:00:03,07 from way back in the beginning of the course? 3 00:00:03,07 --> 00:00:05,09 Let's rearrange some data. 4 00:00:05,09 --> 00:00:06,09 The first thing I'm going to do 5 00:00:06,09 --> 00:00:08,07 is make these columns a bit wider 6 00:00:08,07 --> 00:00:10,06 so that they're easier for you to see. 7 00:00:10,06 --> 00:00:11,09 And we know we can do that now 8 00:00:11,09 --> 00:00:14,02 by clicking and dragging to select them all, 9 00:00:14,02 --> 00:00:15,06 and sliding them. 10 00:00:15,06 --> 00:00:17,04 Remember, I can slide just one of them 11 00:00:17,04 --> 00:00:20,01 and it's going to resize all of them. 12 00:00:20,01 --> 00:00:21,02 Something very common 13 00:00:21,02 --> 00:00:22,06 that you might want to do in Excel 14 00:00:22,06 --> 00:00:24,06 is rearrange rows or columns. 15 00:00:24,06 --> 00:00:27,03 That is, maybe I want to group these wattage products 16 00:00:27,03 --> 00:00:29,00 right next to each other. 17 00:00:29,00 --> 00:00:31,01 The easiest way to do that 18 00:00:31,01 --> 00:00:33,03 is to either select the entire row 19 00:00:33,03 --> 00:00:35,00 by clicking on the row number, 20 00:00:35,00 --> 00:00:37,02 or if I had data to the right of this 21 00:00:37,02 --> 00:00:39,00 and I don't want to move that data, 22 00:00:39,00 --> 00:00:40,08 I can select the data that I want 23 00:00:40,08 --> 00:00:43,03 by clicking and dragging. 24 00:00:43,03 --> 00:00:46,02 Now, I'll slowly move my cursor 25 00:00:46,02 --> 00:00:47,09 to the very top of the cell, 26 00:00:47,09 --> 00:00:49,05 and the cursor is going to change 27 00:00:49,05 --> 00:00:51,07 to a crosshair icon. 28 00:00:51,07 --> 00:00:53,00 When that happens, 29 00:00:53,00 --> 00:00:55,03 I can hold the Shift key down on my keyboard 30 00:00:55,03 --> 00:00:58,00 and click and drag up with my mouse. 31 00:00:58,00 --> 00:00:59,00 I'll let go, 32 00:00:59,00 --> 00:01:02,09 and it's instantly swapped the contents of both cells. 33 00:01:02,09 --> 00:01:05,01 Now, a gotcha is if I do that 34 00:01:05,01 --> 00:01:07,05 and forget to hold down the Shift key. 35 00:01:07,05 --> 00:01:12,00 I'm going to do the same thing, 36 00:01:12,00 --> 00:01:15,07 but if I don't hold down the Shift key, 37 00:01:15,07 --> 00:01:18,07 this time, I'm prompted that there's already data in here. 38 00:01:18,07 --> 00:01:20,05 And if I click OK, 39 00:01:20,05 --> 00:01:22,05 it's going to completely override 40 00:01:22,05 --> 00:01:24,03 what was in that cell. 41 00:01:24,03 --> 00:01:28,00 I'll undo that by hitting Control Z. 42 00:01:28,00 --> 00:01:29,06 There is another way to do this, 43 00:01:29,06 --> 00:01:31,04 and this may be more comfortable for you. 44 00:01:31,04 --> 00:01:33,05 There's no right or wrong, 45 00:01:33,05 --> 00:01:35,01 but I can always insert a row, 46 00:01:35,01 --> 00:01:37,08 and copy and paste the data in. 47 00:01:37,08 --> 00:01:40,06 For example, I'll select this row here 48 00:01:40,06 --> 00:01:42,06 and I can either click the Insert button 49 00:01:42,06 --> 00:01:46,09 or right-click and choose Insert. 50 00:01:46,09 --> 00:01:48,02 Here's my row. 51 00:01:48,02 --> 00:01:50,08 And now I could cut this entire row 52 00:01:50,08 --> 00:01:52,08 either by using the scissors icon 53 00:01:52,08 --> 00:01:54,07 to hit Cut from the home ribbon tab, 54 00:01:54,07 --> 00:01:59,02 or Command X. 55 00:01:59,02 --> 00:02:01,09 And now I can hit Command or Control 56 00:02:01,09 --> 00:02:03,03 if you're on Windows or Mac 57 00:02:03,03 --> 00:02:05,03 to paste it in, 58 00:02:05,03 --> 00:02:08,02 and then delete this row. 59 00:02:08,02 --> 00:02:10,00 So this is a bit time consuming, 60 00:02:10,00 --> 00:02:11,09 but if you can't remember that Shift command, 61 00:02:11,09 --> 00:02:13,05 it's always an option. 62 00:02:13,05 --> 00:02:15,08 We can do the same thing with columns. 63 00:02:15,08 --> 00:02:18,00 Let's suppose, for whatever reason, 64 00:02:18,00 --> 00:02:21,06 I want to put 2020 before 2019, 65 00:02:21,06 --> 00:02:23,01 I'll select the entire column 66 00:02:23,01 --> 00:02:25,01 by clicking on the column letter. 67 00:02:25,01 --> 00:02:27,07 And now, again, I'll move the cursor 68 00:02:27,07 --> 00:02:29,07 all the way to the left-hand side 69 00:02:29,07 --> 00:02:32,02 until it changes to a crosshair. 70 00:02:32,02 --> 00:02:34,02 Now, it's important that you don't do that on the letter, 71 00:02:34,02 --> 00:02:37,09 because remember, that's only going to resize the column. 72 00:02:37,09 --> 00:02:40,04 So I'm doing it in this cell itself. 73 00:02:40,04 --> 00:02:42,03 I'll hold the Shift key down, 74 00:02:42,03 --> 00:02:44,01 drag, let go, 75 00:02:44,01 --> 00:02:47,07 and it swapped the contents of those two columns. 76 00:02:47,07 --> 00:02:49,00 So that's how you can move 77 00:02:49,00 --> 00:02:51,03 and rearrange rows and columns easily 78 00:02:51,03 --> 00:02:53,01 by either dragging with your mouse 79 00:02:53,01 --> 00:02:56,00 or using the Cut, Insert and Paste method.