WEBVTT Kind: captions Language: en 00:00:08.580 --> 00:00:14.049 In Excel, every workbook is different. That means you may want to modify certain things—like 00:00:14.049 --> 00:00:19.130 the size and layout of your cells—to better fit the data you're working with. 00:00:19.130 --> 00:00:24.140 This column has been resized, for example, but not quite enough—most of the text is 00:00:24.140 --> 00:00:28.930 still getting cut off. I'm going to increase the width a little more by positioning my 00:00:28.930 --> 00:00:35.050 mouse over the line in the column heading, then clicking and dragging it to the right. 00:00:35.050 --> 00:00:39.309 Another option is to auto-size the column. This will automatically adjust the width, 00:00:39.309 --> 00:00:44.449 so it fits the contents of the cells exactly. Just double-click the line instead of dragging 00:00:44.449 --> 00:00:49.809 it. Now the column is perfectly sized to the text. 00:00:49.809 --> 00:00:55.619 Rows work the same way. You can adjust them manually, or auto-size them to fit the height 00:00:55.619 --> 00:00:57.540 of your text. 00:00:57.540 --> 00:01:02.390 Sometimes it's useful to be able to resize all of your cells at once. In this example, 00:01:02.390 --> 00:01:07.080 I'd like to make all of my rows the exact same height. To do this, click the Select 00:01:07.080 --> 00:01:13.920 All button in the top left corner. Then resize a row (it doesn't matter which one) … and 00:01:13.920 --> 00:01:17.760 the change will be applied to the entire worksheet. 00:01:17.760 --> 00:01:22.420 Next I need to add another row to this list. I'd like to put it in between row 4 and row 00:01:22.420 --> 00:01:28.170 5. To add a new row, all you have to do is select the row heading below where you want 00:01:28.170 --> 00:01:34.650 the new one to appear. Then click the Insert command… 00:01:38.850 --> 00:01:43.450 The process is similar for inserting a new column. Just select the column heading to 00:01:43.450 --> 00:01:48.770 the right of where you want the new one to go. Click the Insert command… and a column 00:01:48.770 --> 00:01:53.250 will appear to the left. 00:01:53.250 --> 00:01:57.810 Deleting columns and rows is just as easy. First, select the column or row you want to 00:01:57.810 --> 00:02:04.890 delete … then click the Delete command. The column or row will be deleted, causing 00:02:04.890 --> 00:02:09.530 the other cells to move and fill in the gap automatically. Just remember that there's 00:02:09.530 --> 00:02:14.930 a difference between clearing and deleting: deleting cells removes them from your worksheet; 00:02:14.930 --> 00:02:18.150 clearing just removes the contents. 00:02:18.150 --> 00:02:23.730 You can also move a column or row to a different location. In this example, we'll move a column. 00:02:23.730 --> 00:02:29.060 All you have to do is select the one you want, then click the Cut command. 00:02:29.060 --> 00:02:34.630 Next, select the column to the right of where you want the column to be moved. Click the 00:02:34.630 --> 00:02:40.880 Insert drop-down menu on the ribbon… then choose Insert Cut Cells. 00:02:40.880 --> 00:02:46.400 Another useful technique for rearranging data is the ability to hide certain columns or 00:02:46.400 --> 00:02:51.150 rows. For example, I don't really need to see these three columns right now; I'd rather 00:02:51.150 --> 00:02:57.349 focus on the customers' email addresses. If we right-click… then choose Hide from the 00:02:57.349 --> 00:03:02.430 menu… the columns temporarily disappear. 00:03:02.430 --> 00:03:07.550 To unhide them, select the columns on either side of the ones that are hidden… then right-click 00:03:07.550 --> 00:03:13.569 again… and choose Unhide. 00:03:13.569 --> 00:03:17.110 Let's fast forward to the finished worksheet... 00:03:17.110 --> 00:03:21.030 Next I'd like to take a look at wrapping text, which is one way of addressing cells that 00:03:21.030 --> 00:03:26.630 contain more text than they can actually display. For example, I'd like to resize my column 00:03:26.630 --> 00:03:32.280 of addresses to about half its current size, but still be able to see the contents. 00:03:32.280 --> 00:03:37.620 We can do this using the Wrap Text command on the ribbon. As you can see, this displays 00:03:37.620 --> 00:03:40.489 the text on multiple lines. 00:03:40.489 --> 00:03:45.310 Now for the finishing touch—combining the cells in the top row, so the title of my worksheet 00:03:45.310 --> 00:03:52.099 can be centered in a single large cell. To do this, select the cells you want to merge… 00:03:52.099 --> 00:03:58.379 then click the Merge & Center command. There, that's perfect. 00:03:58.379 --> 00:04:04.239 To access more merge options, open the drop-down menu here. You can merge across, creating 00:04:04.239 --> 00:04:09.260 merged rows instead of a single large cell (if you have multiple cells selected). You 00:04:09.260 --> 00:04:14.830 can also merge without centering, or split your cells up again. 00:04:14.830 --> 00:04:19.329 There is a downside to using the Merge command though. If you want to Merge multiple cells 00:04:19.329 --> 00:04:24.229 each containing data, Merge will only keep the contents of the upper left cell, and discard 00:04:24.229 --> 00:04:27.879 everything else. So you should be careful when using this feature… 00:04:27.879 --> 00:04:32.439 The best way to learn about merging cells, wrapping text, and working with columns and 00:04:32.439 --> 00:04:37.309 rows is to practice. So the next time you're using Excel, look for ways that you can customize 00:04:37.309 --> 00:04:39.050 your worksheet to better fit your data.