1 00:00:00,05 --> 00:00:03,00 - [Instructor] Let's practice resizing rows and columns, 2 00:00:03,00 --> 00:00:06,02 and in no time it's going to feel like second nature to you. 3 00:00:06,02 --> 00:00:08,08 It's what you'll spend a lot of time doing, honestly, 4 00:00:08,08 --> 00:00:11,00 and it's something that we all tend to do 5 00:00:11,00 --> 00:00:13,02 right when we first open an Excel file, 6 00:00:13,02 --> 00:00:15,06 because you just need to sort of adjust it 7 00:00:15,06 --> 00:00:17,01 so that it makes sense to you. 8 00:00:17,01 --> 00:00:20,01 For example, let's take this column C here. 9 00:00:20,01 --> 00:00:23,04 I can see that a lot of these words are cut off, 10 00:00:23,04 --> 00:00:24,06 so it's common practice 11 00:00:24,06 --> 00:00:28,01 if you open up an Excel file to resize a column, 12 00:00:28,01 --> 00:00:31,00 and the quickest way to resize a single column 13 00:00:31,00 --> 00:00:34,08 is to hover your mouse right in the line between the column 14 00:00:34,08 --> 00:00:36,09 and click and drag with your mouse. 15 00:00:36,09 --> 00:00:39,08 You can make it wider or smaller. 16 00:00:39,08 --> 00:00:42,08 So what I could do here is just slide it around manually 17 00:00:42,08 --> 00:00:44,06 and feel it out and get it to a place 18 00:00:44,06 --> 00:00:46,07 where it looks comfortable to read. 19 00:00:46,07 --> 00:00:48,09 That's one way to resize a column. 20 00:00:48,09 --> 00:00:52,01 Another way to resize a column is to autofit it, 21 00:00:52,01 --> 00:00:55,02 that is, make it the smallest possible width 22 00:00:55,02 --> 00:00:58,02 so that you can still read all of the text in the column. 23 00:00:58,02 --> 00:01:00,06 The entire column is going to be as wide 24 00:01:00,06 --> 00:01:04,06 as the longest value in any of the cells in that column. 25 00:01:04,06 --> 00:01:08,09 To autofit a column, you can double click right in between 26 00:01:08,09 --> 00:01:11,07 instead of clicking and dragging. 27 00:01:11,07 --> 00:01:14,04 Instantly, the column becomes nice and snug, 28 00:01:14,04 --> 00:01:16,06 but you can still read everything. 29 00:01:16,06 --> 00:01:18,05 Sometimes you'll open up an Excel file 30 00:01:18,05 --> 00:01:21,08 and you'll notice a lot of pound symbols in one column. 31 00:01:21,08 --> 00:01:23,08 That's what happens when there's a number 32 00:01:23,08 --> 00:01:26,04 and it's too small to fit the column. 33 00:01:26,04 --> 00:01:31,01 What I can do now is autofit this column by double clicking, 34 00:01:31,01 --> 00:01:34,01 and now I can read all of the extensions. 35 00:01:34,01 --> 00:01:37,04 Now you might want to autofit all of the columns all at once. 36 00:01:37,04 --> 00:01:40,02 You can do that by clicking in the column header 37 00:01:40,02 --> 00:01:42,09 and dragging to select every column, 38 00:01:42,09 --> 00:01:45,00 and now you can choose any column 39 00:01:45,00 --> 00:01:47,01 and double click to autofit it. 40 00:01:47,01 --> 00:01:50,01 It's going to autofit all of them. 41 00:01:50,01 --> 00:01:52,07 You can also resize them all at once this way. 42 00:01:52,07 --> 00:01:59,04 Just pick any column, click and drag, 43 00:01:59,04 --> 00:02:07,05 and it's going to set every column to that exact same width. 44 00:02:07,05 --> 00:02:10,08 Working with rows is the exact same way. 45 00:02:10,08 --> 00:02:13,08 If I want this header to be a little bit wider, 46 00:02:13,08 --> 00:02:18,06 I can hover my mouse in between row 1 and row 2 47 00:02:18,06 --> 00:02:23,01 and click and drag to make it wider or more narrow. 48 00:02:23,01 --> 00:02:24,09 I'll make it a little bit wider. 49 00:02:24,09 --> 00:02:27,00 Now, something interesting about rows 50 00:02:27,00 --> 00:02:28,00 is that here you'll notice 51 00:02:28,00 --> 00:02:30,04 that the text is almost a little bit hard to read, 52 00:02:30,04 --> 00:02:33,02 because it's aligned to the bottom of the cell, 53 00:02:33,02 --> 00:02:35,06 so what I could do is click the row number 54 00:02:35,06 --> 00:02:37,06 to highlight the entire row 55 00:02:37,06 --> 00:02:39,03 and come up here and format it 56 00:02:39,03 --> 00:02:41,05 to make it a little bit easier to read. 57 00:02:41,05 --> 00:02:46,02 For example, I might middle align it to the cell. 58 00:02:46,02 --> 00:02:49,02 You can also resize multiple rows this way. 59 00:02:49,02 --> 00:02:52,00 I can select a row, hold the Shift key down, 60 00:02:52,00 --> 00:02:54,03 select multiple rows, 61 00:02:54,03 --> 00:02:59,09 click and drag with my mouse, and make them wider, 62 00:02:59,09 --> 00:03:02,09 and every row becomes that wide. 63 00:03:02,09 --> 00:03:04,07 Let's suppose you wanted to bring them back 64 00:03:04,07 --> 00:03:05,09 to their defaults, 65 00:03:05,09 --> 00:03:08,03 or at least a place where it's easier to read 66 00:03:08,03 --> 00:03:10,08 and looks more like a traditional spreadsheet. 67 00:03:10,08 --> 00:03:13,04 Up here in the Home ribbon tab, 68 00:03:13,04 --> 00:03:17,01 click the down arrow next to Format. 69 00:03:17,01 --> 00:03:19,09 Right at the very top, under Cell Size, 70 00:03:19,09 --> 00:03:23,03 choose Autofit Row Height. 71 00:03:23,03 --> 00:03:26,07 Now it's going to do that to the selected row. 72 00:03:26,07 --> 00:03:30,02 You'll notice that this one is back to being nice and small. 73 00:03:30,02 --> 00:03:32,02 If you want to do that to everything, 74 00:03:32,02 --> 00:03:33,05 you can click right here 75 00:03:33,05 --> 00:03:35,09 in the top corner of the spreadsheet. 76 00:03:35,09 --> 00:03:39,00 It's going to select everything, all of your rows, 77 00:03:39,00 --> 00:03:42,00 and if we do this again, 78 00:03:42,00 --> 00:03:44,02 this time it brings everything back, 79 00:03:44,02 --> 00:03:45,09 including that top header row 80 00:03:45,09 --> 00:03:48,03 that we manually adjusted earlier. 81 00:03:48,03 --> 00:03:51,07 Let's head over to the Comments sheet. 82 00:03:51,07 --> 00:03:54,09 This is a completely different sheet from a hotel industry, 83 00:03:54,09 --> 00:03:56,07 but here's some comments. 84 00:03:56,07 --> 00:03:58,05 This is something else that you might come across 85 00:03:58,05 --> 00:04:00,03 when you're looking at spreadsheets. 86 00:04:00,03 --> 00:04:03,03 The way the text wraps in the cell is something 87 00:04:03,03 --> 00:04:04,06 that you can control, 88 00:04:04,06 --> 00:04:07,08 and it's going to adjust the height of that cell. 89 00:04:07,08 --> 00:04:10,06 Here I can see that this text is being cut off 90 00:04:10,06 --> 00:04:12,06 by this cell here, 91 00:04:12,06 --> 00:04:14,02 but if I look in the Formula bar, 92 00:04:14,02 --> 00:04:16,02 I can read the whole thing, 93 00:04:16,02 --> 00:04:20,05 and in this cell, it's extending to the other column. 94 00:04:20,05 --> 00:04:21,06 I can read it all, 95 00:04:21,06 --> 00:04:24,03 but I wouldn't be able to read what's in this column. 96 00:04:24,03 --> 00:04:27,08 What we can do is highlight the entire column 97 00:04:27,08 --> 00:04:31,07 and choose Wrap Text from the Home ribbon tab. 98 00:04:31,07 --> 00:04:34,02 This is going to wrap the text into multiple lines 99 00:04:34,02 --> 00:04:37,06 so that we can read all of it all at once. 100 00:04:37,06 --> 00:04:42,00 I'll do the same thing to this column. 101 00:04:42,00 --> 00:04:44,05 Now I can read that text comfortably 102 00:04:44,05 --> 00:04:45,09 and if I wanted to, of course, 103 00:04:45,09 --> 00:04:48,02 I can still make any manual row 104 00:04:48,02 --> 00:04:50,02 or column adjustments that I want, 105 00:04:50,02 --> 00:04:52,03 but Excel will do it for me 106 00:04:52,03 --> 00:04:56,00 when the column is said to have the text wrapped.