WEBVTT Kind: captions Language: en 00:00:07.910 --> 00:00:12.420 The look and feel of your workbook has a lot to do with the formatting choices 00:00:12.420 --> 00:00:16.640 you make. For example, let's add some formatting to this fitness chart. 00:00:16.640 --> 00:00:21.790 That will make it easier to read and more visually appealing. We'll start by 00:00:21.790 --> 00:00:26.519 selecting the cell that contains "Fitness progress chart" and making the text bigger. 00:00:27.610 --> 00:00:34.340 In the Font group on the Home tab, locate the font size box. You can type 00:00:34.340 --> 00:00:39.900 in the exact point size you want or click the drop-down arrow to select a size. 00:00:40.040 --> 00:00:44.300 You'll see a preview of the results as you go down the list. 00:00:44.300 --> 00:00:46.710 I think 24 looks good. 00:00:46.710 --> 00:00:52.090 Maybe we could go a little bigger though. Increase and Decrease are two other 00:00:52.090 --> 00:00:56.620 options for quickly changing the size of your text. All you have to do is click the 00:00:56.620 --> 00:01:02.980 command and...there we go! To change the actual font, click the drop-down arrow 00:01:02.980 --> 00:01:10.240 here then make your way down the list—you'll get that live preview again. 00:01:10.240 --> 00:01:15.009 I think I'll go with this one is. It's different but still very easy to read, 00:01:15.009 --> 00:01:19.869 which makes it a good choice for a title. So, how about some color? To view your 00:01:19.869 --> 00:01:24.530 options, click the arrow next to the font color command you can choose one of the 00:01:24.530 --> 00:01:28.330 theme colors here, or, if you don't see anything you like, 00:01:28.330 --> 00:01:32.110 go ahead and select More Colors... 00:01:32.110 --> 00:01:37.290 This bright pink should look pretty good with the color scheme I have in mind. 00:01:37.290 --> 00:01:41.510 Another way to make your text 00:01:41.510 --> 00:01:46.650 stand out is to use bold, italic, and underlining. Bold should be a good choice in 00:01:46.650 --> 00:01:52.830 this example. Now the text really stands out and it's much easier to read. 00:01:52.830 --> 00:01:57.840 I think I'm ready to add some formatting for the rest of the worksheet. 00:01:57.840 --> 00:02:01.760 At a glace, it's kind of hard to tell the header row from the rest the chart because it just 00:02:01.760 --> 00:02:07.380 isn't very distinct. We can easily fix that by giving the header a unique fill color. 00:02:07.440 --> 00:02:11.260 All you have to do is open the menu next the Fill Color command and 00:02:11.260 --> 00:02:12.340 make your choice. 00:02:12.340 --> 00:02:16.060 Dark gray should be a nice contrast to the pink we used earlier. 00:02:16.380 --> 00:02:21.160 Now I just need to change the color of this text to something lighter 00:02:22.120 --> 00:02:27.100 You can also use Cell Styles to quickly apply different formatting in your workbook. 00:02:27.740 --> 00:02:32.440 Let's give it a try on the rest of our data here. When you're ready select the 00:02:32.890 --> 00:02:40.000 Cell styles command and mouse over the styles for a preview, and click the one you want. 00:02:40.000 --> 00:02:45.380 At this point you probably noticed adding a fill color to a cell range 00:02:45.380 --> 00:02:50.350 causes the line in-between the cells to disappear; I'd like to change that by 00:02:50.350 --> 00:02:55.090 adding in some cell borders. Click the drop-down arrow next to the Border 00:02:55.090 --> 00:02:59.790 commands, and you'll find a lot of different options. For example you can add a top and 00:02:59.790 --> 00:03:04.450 bottom border, a thick outside border, and even different line colors and styles. 00:03:06.340 --> 00:03:11.370 For a border that goes all the way outside and in between the cells choose 00:03:11.370 --> 00:03:13.240 All borders. 00:03:13.240 --> 00:03:19.170 OK, one last thing I'd like to show you is how to change the placement, or alignment, 00:03:19.170 --> 00:03:24.290 of your texts using the options in the Alignment group. An addition to left, 00:03:24.290 --> 00:03:30.960 center, and right, text can also be aligned to the bottom, middle, or top of the cell. 00:03:30.960 --> 00:03:35.630 Aligning the text to the middle center should make this data look really nice 00:03:35.630 --> 00:03:37.270 and easy to read. 00:03:37.270 --> 00:03:42.670 See a big difference formatting can make? Not only does my 00:03:42.670 --> 00:03:46.720 spreadsheet look better than it did before, it's also easier to review the data.