WEBVTT Kind: captions Language: en 00:00:07.379 --> 00:00:14.379 I'm working on my household budget and I've entered all of my bills for the last two months. 00:00:15.340 --> 00:00:19.460 Now that I have my information entered, I can clean up my worksheet a little. 00:00:19.460 --> 00:00:24.980 For example, some of the text in column A goes beyond the column marker. 00:00:24.980 --> 00:00:30.869 I can easily make the column wider. Just position the cursor over the column line 00:00:30.869 --> 00:00:36.000 right in the column heading and a double arrow will appear. 00:00:36.000 --> 00:00:41.110 Left-click the mouse and drag the cursor to the right to increase the column size. 00:00:41.110 --> 00:00:45.820 Release the mouse button when the column is the desired size. 00:00:45.820 --> 00:00:49.110 It's bigger now, but I think it's a little too big. 00:00:49.110 --> 00:00:54.550 I can decrease the column size the same way, but this time, I'll just drag the cursor to 00:00:54.550 --> 00:00:59.079 the left. There, that looks a lot better. 00:00:59.079 --> 00:01:03.550 Some of the names of the months don't quite fit in the cell either and I can increase 00:01:03.550 --> 00:01:09.329 the column width on these, too. Now, I can manually adjust the column marker 00:01:09.329 --> 00:01:16.149 like I just did for column A, or I can use the Format command to adjust the column width. 00:01:16.149 --> 00:01:20.999 Just select the column you'd like to modify, and then click the Format command in the Cells 00:01:20.999 --> 00:01:27.639 group on the Home tab. A menu appears with a lot of options. 00:01:27.639 --> 00:01:33.119 From this menu, you can change your row height and your column width. 00:01:33.119 --> 00:01:39.039 If you click Column Width a dialog box appears that allows you to enter a specific size for 00:01:39.039 --> 00:01:43.420 the width. I'm not sure how wide I need it to be, so 00:01:43.420 --> 00:01:48.740 this won't work. However, the AutoFit Column Width adjusts 00:01:48.740 --> 00:01:53.229 the column just enough so all the text will fit. 00:01:53.229 --> 00:01:56.689 Just left-click the menu option to select it. 00:01:56.689 --> 00:02:00.189 And now you can see that the column adjusted in the worksheet. 00:02:00.189 --> 00:02:06.020 Right now, the height of the rows in the spreadsheet looks OK, but there may be times when you 00:02:06.020 --> 00:02:10.560 want to increase or decrease the height of your rows. 00:02:10.560 --> 00:02:15.830 This works the same way as the columns. For example, let's say I want to increase 00:02:15.830 --> 00:02:20.210 the height of row 1. Afterall, it is my title. 00:02:20.210 --> 00:02:26.010 I do want it to stand out! All you have to do is hover your cursor over the row line 00:02:26.010 --> 00:02:32.050 you want to move. Once the double-arrow appears, left-click 00:02:32.050 --> 00:02:36.720 and drag your mouse. I want to make this row taller, so I'll drag 00:02:36.720 --> 00:02:42.610 the row line down. You can drag the line up and down until you 00:02:42.610 --> 00:02:47.030 get the size you'd like. And just like the columns, you can format 00:02:47.030 --> 00:02:53.080 the rows by clicking the Format command in the Cells group on the Home tab. 00:02:53.080 --> 00:02:59.120 From the menu, you can select Row Height to enter a specific cell height or AutoFit Row 00:02:59.120 --> 00:03:05.280 Height to adjust the row height to the same size as the text. 00:03:05.280 --> 00:03:11.510 You may also find that you need to sometimes insert rows, columns, and cells. 00:03:11.510 --> 00:03:18.230 For example, I just realized that I forgot to include my car insurance in my budget. 00:03:18.230 --> 00:03:22.940 Instead of adding it to the bottom of the list, I'd like to put it above my car payment. 00:03:22.940 --> 00:03:29.080 All I need to do is select row 9 then click the Insert command. 00:03:29.080 --> 00:03:34.230 The new row always appears above the selected row. 00:03:34.230 --> 00:03:40.840 And now I can type in my text. One word of caution... 00:03:40.840 --> 00:03:47.150 make sure that you select the entire row below where you want the new row to appear and not 00:03:47.150 --> 00:03:52.470 just the cell. For example, if I want to insert a new row 00:03:52.470 --> 00:03:59.470 above Rent and I only select cell A8 instead of row 8, it won't work quite right. 00:04:01.120 --> 00:04:07.790 You see, now if I click the Insert command, only a cell will be inserted, instead of a 00:04:07.790 --> 00:04:12.870 row. So, I'll just click Undo, select the entire 00:04:12.870 --> 00:04:19.870 row, and click Insert. 00:04:22.000 --> 00:04:24.970 You can also insert columns easily. 00:04:24.970 --> 00:04:30.830 I want to change the Date column to Aug. Due Date, and then insert a column next to 00:04:30.830 --> 00:04:37.830 it where I can type "yes" or "no" if it was paid. Each month, I'll change this information. 00:04:39.120 --> 00:04:44.630 When you insert a new column into a worksheet, it will appear to the left of the column you 00:04:44.630 --> 00:04:49.220 select. Since I want my new column to appear here, 00:04:49.220 --> 00:04:55.460 to the right of the Due Date column, I need to select Column C and then click the Insert 00:04:55.460 --> 00:05:02.460 command. There you go! Deleting rows and columns is 00:05:03.250 --> 00:05:08.240 as easy as adding them. Just select the row or column you'd like to 00:05:08.240 --> 00:05:13.240 delete, and click the Delete command on the Home tab. 00:05:13.240 --> 00:05:17.620 I do want to keep this row, so I'll click Undo. 00:05:17.620 --> 00:05:22.720 Just be careful to select the entire row or column you want to delete. 00:05:22.720 --> 00:05:33.010 If you only select a cell and then click Delete, only the cell will disappear. 00:05:33.010 --> 00:05:38.150 Excel gives you several different ways to insert cells and rows and you'll learn more 00:05:38.150 --> 00:05:42.400 about these as you use Excel. I think I've shown you the simplest way to 00:05:42.400 --> 00:05:48.350 add and delete rows and columns, but feel free to explore some of the other option as 00:05:48.350 --> 00:05:52.419 well. If you click the down arrow next to the Insert 00:05:52.419 --> 00:05:58.419 and Delete commands, you'll see some other menu options. 00:05:58.419 --> 00:06:03.169 I'm going to really quickly add a few more rows that will help me organize the budget 00:06:03.169 --> 00:06:10.169 into categories. 00:06:12.000 --> 00:06:14.930 The best way to learn how to insert and delete 00:06:14.930 --> 00:06:19.210 rows, columns, and cells to practice using them. 00:06:19.210 --> 00:06:19.759 Have fun!