WEBVTT Kind: captions Language: en 00:00:07.080 --> 00:00:11.840 Now that I have my basic bills listed in my worksheet, I think I'd like to clean it up 00:00:11.840 --> 00:00:15.410 and format it. Formatting your worksheet can make it look 00:00:15.410 --> 00:00:20.070 nice and make it easier to read. You will find some of the font formatting 00:00:20.070 --> 00:00:27.070 commands on the Home tab in the Font group. Let's start by making the title bold. 00:00:27.560 --> 00:00:31.840 To do this, you first need to select the text you want to make bold. 00:00:31.840 --> 00:00:38.660 Now, just click the Bold command. I think I'll do the same with all my bills 00:00:38.660 --> 00:00:43.089 here on the left. If I want to format more than one cell at 00:00:43.089 --> 00:00:49.460 a time, I can select entire columns and rows, or specific cells. 00:00:49.460 --> 00:00:55.960 To select the entire column, just left-click the column heading and the entire column will 00:00:55.960 --> 00:01:01.269 appear as selected. To select specific cells in the column, just 00:01:01.269 --> 00:01:06.810 left-click a cell and drag your mouse to select the other cells you wish to format. 00:01:06.810 --> 00:01:11.940 Then, release the mouse button. Now, you can left-click the Bold command, 00:01:11.940 --> 00:01:18.940 and all the selected cells will be formatted. Now I'll just do the same thing to this row. 00:01:19.480 --> 00:01:24.140 In addition to the bold command, you also have the Italic and Underline commands that 00:01:24.140 --> 00:01:28.440 work the same way. I think the title will look good in italics, 00:01:28.440 --> 00:01:31.690 so I'll just select it and click the Italics command. 00:01:31.690 --> 00:01:37.150 The Underline command works the same way, but it does have extra menu options. 00:01:37.150 --> 00:01:44.140 Let's add the word Total in cell A29. Eventually, I'll add up my monthly bills and 00:01:44.140 --> 00:01:49.870 list it in this row. I think it would be good to draw attention 00:01:49.870 --> 00:01:54.190 to this, so I'll make it bold and underline it. 00:01:54.190 --> 00:01:59.260 To format it with a simple line, just make sure the cell is selected and then click the 00:01:59.260 --> 00:02:04.580 Underline command. If you want a double line, click the down 00:02:04.580 --> 00:02:11.420 arrow and select the Double Underline option. You can also change the font style, size, 00:02:11.420 --> 00:02:15.270 and color. To change the font style, select the cells 00:02:15.270 --> 00:02:20.090 you want to modify. I'll just left-click the row 7 heading to 00:02:20.090 --> 00:02:25.690 select the entire row, and then left-click the font drop-down box on the Home tab to 00:02:25.690 --> 00:02:31.060 select a font style from the list. As you move over the font list, you'll see 00:02:31.060 --> 00:02:36.510 the fonts previewed in the spreadsheet. This is the Live Preview feature at work for 00:02:36.510 --> 00:02:41.060 you. I think Tahoma will look good. 00:02:41.060 --> 00:02:47.450 And I think I'll choose a different font style for the title. 00:02:47.450 --> 00:02:52.190 It looks good, but I think the font size needs to be bigger. 00:02:52.190 --> 00:02:57.250 Just select the drop- down arrow next to the Font Size box and choose a size option. 00:02:57.250 --> 00:03:03.000 Yeah, I think that looks good. While we're changing things, let me show you 00:03:03.000 --> 00:03:08.020 how to change the text color. Just select the text, and then click the down 00:03:08.020 --> 00:03:13.810 arrow next to the Text Color command. A color palette appears. 00:03:13.810 --> 00:03:20.450 I can select the color I'd like, or click More Colors to open a dialog box and access 00:03:20.450 --> 00:03:24.300 other colors. Click the color you'd like and then click 00:03:24.300 --> 00:03:27.959 OK. There, that looks good. 00:03:27.959 --> 00:03:32.780 Now I'm ready to make some additional formatting changes that will make the worksheet easier 00:03:32.780 --> 00:03:36.610 to read. You can do this by adding borders and fill 00:03:36.610 --> 00:03:43.170 color to your worksheet in select places. In the Font dialog box, you'll find the Fill 00:03:43.170 --> 00:03:49.840 Effects command and the Borders command side by side. 00:03:49.840 --> 00:03:53.459 Let's go ahead and select the cells we want to add a border to. 00:03:53.459 --> 00:03:58.230 So I'll just select the rows, and then click the arrow next to the Borders command on the 00:03:58.230 --> 00:04:03.900 Home tab. A menu appears with all sorts of choices. 00:04:03.900 --> 00:04:10.340 You can decide whether you only want a border on the top, a border on the bottom, or some 00:04:10.340 --> 00:04:13.750 combination. Just left- click an option from the list to 00:04:13.750 --> 00:04:20.750 select it, and it will appear in the worksheet. 00:04:24.469 --> 00:04:29.620 Adding fill color to cells can be a greatway to format a worksheet so that it is easy to read. 00:04:29.620 --> 00:04:35.120 You may have seen some long business reports that have alternating colored rows or columns 00:04:35.120 --> 00:04:39.650 to make it easier to read. You can also change the fill color to draw 00:04:39.650 --> 00:04:44.509 attention to a specific part or just make it look nicer overall. 00:04:44.509 --> 00:04:51.509 Let's change the fill color of the title cells. Just select the cells, then click the Fill 00:04:53.409 --> 00:04:57.339 command. A color palette appears. 00:04:57.339 --> 00:05:03.219 You can select the color you'd like, or choose More Colors to open a dialog box of colors. 00:05:03.219 --> 00:05:09.330 Here, I like this color. It looks good, but I think I need to change 00:05:09.330 --> 00:05:16.330 my text color to white if the fill color is dark like this. 00:05:17.659 --> 00:05:24.460 I can use the fill color in the same way to format my columns to make them easier to read. 00:05:24.460 --> 00:05:29.360 You may have noticed that I have my bill amounts listed each month, but there isn't a dollar 00:05:29.360 --> 00:05:34.159 sign in front of each amount. Excel gives you the ability to change the 00:05:34.159 --> 00:05:38.439 number format. By default, the numbers appear in the General 00:05:38.439 --> 00:05:42.779 category, which means there is no special formatting. 00:05:42.779 --> 00:05:48.300 If I want to change the number formatting, I just need to select the cells and then click 00:05:48.300 --> 00:05:53.550 the drop-down arrow in the Number Format box. From here, you can see that there are many 00:05:53.550 --> 00:05:58.779 ways you can format numbers in your worksheet. Since I'm dealing with monetary amounts, I 00:05:58.779 --> 00:06:05.339 think Currency or Accounting will work best. To select one, just left-click it. 00:06:05.339 --> 00:06:09.180 And there you go, now the amounts appear in the Currency format . 00:06:09.180 --> 00:06:14.649 In the Number group, you have some other options. For example, you can change the US dollar 00:06:14.649 --> 00:06:21.649 sign to another currency format. You can change the numbers to percents and 00:06:21.949 --> 00:06:26.029 add commas. You can even change how many places appear 00:06:26.029 --> 00:06:31.300 after the decimal by clicking the Increase or Decrease Decimal commands. 00:06:31.300 --> 00:06:38.300 Before we wrap up, I want to add my due dates in this second column. 00:06:41.300 --> 00:06:46.009 I really don't like the way this is formatted. To change the formatting all you have to do 00:06:46.009 --> 00:06:51.439 is go to the Number group and click on the drop down arrow. 00:06:51.439 --> 00:06:54.449 From here I can choose how I want my date to be displayed. 00:06:54.449 --> 00:07:00.300 Do I want it to be in the Short Date format or the Long Date format? I think I'm going 00:07:00.300 --> 00:07:05.520 to choose the Short Date Format. To avoid having to do this for each and every 00:07:05.520 --> 00:07:10.389 cell in this column, all I have to do is select the remaining cells where I would like enter 00:07:10.389 --> 00:07:14.710 my dates. Now, I have to go back to the Number group, 00:07:14.710 --> 00:07:19.300 click on the drop- down arrow and click on Short Date again. 00:07:19.300 --> 00:07:24.279 This means that no matter what format I try to enter my date, the only format that will 00:07:24.279 --> 00:07:31.279 be applied is the Short Date format. Here, I'll show you. 00:07:31.699 --> 00:07:35.689 Now I'll click outside of the cell for the changes to apply. 00:07:35.689 --> 00:07:41.899 See! This helps with consistency! Things are looking pretty good, but I'd like to center 00:07:41.899 --> 00:07:48.899 my title over my entire budget. To do this, I need to left-click cell A1 and 00:07:49.759 --> 00:07:56.759 drag it to my right to select all the cells over to and including O1. 00:07:56.869 --> 00:08:03.869 Now, on the Home tab, in the Alignment group, I just need to click the Merge & Center 00:08:04.409 --> 00:08:11.240 command and the title is now centered over the selected cells. 00:08:11.240 --> 00:08:16.629 You'll also notice that the separate column lines no longer appear - that's because the 00:08:16.629 --> 00:08:23.629 selected cells were merged into one cell. Formatting rows, columns, and text in Excel 00:08:24.469 --> 00:08:29.539 makes data look a little more interesting. Go ahead and start formatting your worksheet 00:08:29.539 --> 00:08:31.810 for a customized and appealing look!