1 00:00:00,05 --> 00:00:01,08 - [Instructor] Let's work with borders 2 00:00:01,08 --> 00:00:03,08 and background colors for this sheet. 3 00:00:03,08 --> 00:00:05,00 If you're following along, 4 00:00:05,00 --> 00:00:09,00 it's in the Exercise File titled Borders in Chapter 2. 5 00:00:09,00 --> 00:00:11,00 Now, we already have some background colors 6 00:00:11,00 --> 00:00:12,02 here for these cells, 7 00:00:12,02 --> 00:00:14,06 but I want to make the actual units sold 8 00:00:14,06 --> 00:00:16,06 stand out a little bit more. 9 00:00:16,06 --> 00:00:17,08 So I'm going to click and drag 10 00:00:17,08 --> 00:00:19,07 to highlight all of this data. 11 00:00:19,07 --> 00:00:22,00 And now from the Home ribbon tab, 12 00:00:22,00 --> 00:00:25,00 I'm going to click the down arrow next to the paint can. 13 00:00:25,00 --> 00:00:28,05 This is going to change the fill color. 14 00:00:28,05 --> 00:00:31,01 I can hover my mouse over all of the choices 15 00:00:31,01 --> 00:00:33,04 and it's going to change to give me a preview 16 00:00:33,04 --> 00:00:35,04 of what it's going to look like. 17 00:00:35,04 --> 00:00:38,06 I can also choose more colors down here. 18 00:00:38,06 --> 00:00:41,00 I can choose from any color in this palette, 19 00:00:41,00 --> 00:00:42,04 or I can click Custom 20 00:00:42,04 --> 00:00:44,07 and put in the RGB or hex value 21 00:00:44,07 --> 00:00:46,07 if I need to match something specific 22 00:00:46,07 --> 00:00:49,02 like my company's logo. 23 00:00:49,02 --> 00:00:52,09 I'll click Cancel. 24 00:00:52,09 --> 00:00:54,09 I'll choose a color 25 00:00:54,09 --> 00:00:55,08 and then to see it, 26 00:00:55,08 --> 00:00:57,00 I do need to click away 27 00:00:57,00 --> 00:00:58,07 because right now the cells are highlighted, 28 00:00:58,07 --> 00:01:01,02 so they're a completely different color. 29 00:01:01,02 --> 00:01:02,07 Here it is. 30 00:01:02,07 --> 00:01:04,05 Something else that I might want to do 31 00:01:04,05 --> 00:01:06,04 is underline certain text 32 00:01:06,04 --> 00:01:09,06 or cells to make them stand out a little bit more. 33 00:01:09,06 --> 00:01:12,09 Let's take this Units Sold cell. 34 00:01:12,09 --> 00:01:16,04 I'm going to click the down arrow next to the border icon, 35 00:01:16,04 --> 00:01:17,07 and here's where I can choose 36 00:01:17,07 --> 00:01:19,08 what kind of cell border I want. 37 00:01:19,08 --> 00:01:23,08 For example, just a bottom border or all borders. 38 00:01:23,08 --> 00:01:26,00 And if I have multiple cells selected, 39 00:01:26,00 --> 00:01:29,01 it's going to apply to all of those cells. 40 00:01:29,01 --> 00:01:30,08 I can even draw a border 41 00:01:30,08 --> 00:01:32,06 and change the color if I wanted to 42 00:01:32,06 --> 00:01:34,02 to make it stand out. 43 00:01:34,02 --> 00:01:40,05 In this case, I'm going to choose a thick bottom border. 44 00:01:40,05 --> 00:01:43,01 And like before, I can't see the border, 45 00:01:43,01 --> 00:01:44,01 but it's there. 46 00:01:44,01 --> 00:01:46,07 As soon as I click away, I'll be able to see it. 47 00:01:46,07 --> 00:01:48,07 In fact, I can click and drag 48 00:01:48,07 --> 00:01:50,09 across all of these header cells 49 00:01:50,09 --> 00:01:52,04 and click this button again 50 00:01:52,04 --> 00:01:57,03 to apply that thick bottom border to those cells also. 51 00:01:57,03 --> 00:01:58,09 Something else that we can do, 52 00:01:58,09 --> 00:02:00,04 maybe once this is all done 53 00:02:00,04 --> 00:02:02,07 and we want to make it look a little bit cleaner 54 00:02:02,07 --> 00:02:04,04 to email it out to somebody, 55 00:02:04,04 --> 00:02:08,00 we can get rid of all of these gridlines that you can see. 56 00:02:08,00 --> 00:02:11,07 I'm going to change to the Page Layout ribbon tab. 57 00:02:11,07 --> 00:02:13,05 All the way in the middle of the screen, 58 00:02:13,05 --> 00:02:16,00 I can find where it says Gridlines, 59 00:02:16,00 --> 00:02:18,04 and if I uncheck View, 60 00:02:18,04 --> 00:02:20,01 all of those lines go away 61 00:02:20,01 --> 00:02:22,05 and I'm left with a white background. 62 00:02:22,05 --> 00:02:25,03 Now I could change that background if I wanted to. 63 00:02:25,03 --> 00:02:29,06 In fact, I can also change the theme of all of these cells. 64 00:02:29,06 --> 00:02:31,09 While we're still in this Page Layout tab, 65 00:02:31,09 --> 00:02:33,07 all the way on the left-hand side, 66 00:02:33,07 --> 00:02:36,08 here's where I can change the theme of the sheet. 67 00:02:36,08 --> 00:02:39,03 If I click the down arrow next to Themes, 68 00:02:39,03 --> 00:02:43,00 I can hover my mouse over all of these themes 69 00:02:43,00 --> 00:02:44,02 and you can see the font 70 00:02:44,02 --> 00:02:45,06 and the colors changing 71 00:02:45,06 --> 00:02:48,09 as I'm hovering my mouse over all of these themes. 72 00:02:48,09 --> 00:02:50,06 These changes aren't being applied, 73 00:02:50,06 --> 00:02:52,04 they're just being previewed. 74 00:02:52,04 --> 00:02:54,00 The last thing I might want to do 75 00:02:54,00 --> 00:02:55,05 if I'm sending this out 76 00:02:55,05 --> 00:02:59,04 is maybe brand or watermark this with my company's logo. 77 00:02:59,04 --> 00:03:02,07 This time I'm going to change to the Insert ribbon tab. 78 00:03:02,07 --> 00:03:04,07 There's a lot of things that we can insert here, 79 00:03:04,07 --> 00:03:07,09 such as charts and maps and pivot tables, 80 00:03:07,09 --> 00:03:10,00 and we'll be talking about all of those, 81 00:03:10,00 --> 00:03:13,08 but right now I'm interested in pictures. 82 00:03:13,08 --> 00:03:16,02 I'll click Pictures 83 00:03:16,02 --> 00:03:19,03 and I'll place it over the cells. 84 00:03:19,03 --> 00:03:22,09 I don't want it to fit inside of a cell, 85 00:03:22,09 --> 00:03:26,00 and I'm going to choose to insert a picture from this device 86 00:03:26,00 --> 00:03:31,01 because the picture is a logo file that's on my computer. 87 00:03:31,01 --> 00:03:33,07 It's going to bring me to the Browse screen. 88 00:03:33,07 --> 00:03:35,07 I'll browse to the Exercise Files 89 00:03:35,07 --> 00:03:38,09 and find our logo and click Insert. 90 00:03:38,09 --> 00:03:41,07 It's going to dump it in just as it is. 91 00:03:41,07 --> 00:03:44,06 And like across all Office products, 92 00:03:44,06 --> 00:03:47,08 to resize it, I can click and drag with my mouse 93 00:03:47,08 --> 00:03:50,07 and move it around anywhere in the file. 94 00:03:50,07 --> 00:03:54,03 So the first thing I might want to do is make it smaller, 95 00:03:54,03 --> 00:03:58,00 and you'll see here how I can place it right over the cells. 96 00:03:58,00 --> 00:04:02,06 That's because we told it to place it over the cells. 97 00:04:02,06 --> 00:04:06,09 I'll put it in a spot that I think makes it look nice. 98 00:04:06,09 --> 00:04:09,03 And here's our finished sheet. 99 00:04:09,03 --> 00:04:11,06 If I want to put those grid lines back, 100 00:04:11,06 --> 00:04:13,01 don't forget that we got there 101 00:04:13,01 --> 00:04:17,05 by changing to the Page Layout tab, 102 00:04:17,05 --> 00:04:19,02 going to the Gridlines area, 103 00:04:19,02 --> 00:04:20,06 and this time to put them back, 104 00:04:20,06 --> 00:04:23,02 I'm going to place a check mark next to View. 105 00:04:23,02 --> 00:04:25,03 It has no bearing on my image. 106 00:04:25,03 --> 00:04:28,04 As you can see, the gridlines aren't over the image, 107 00:04:28,04 --> 00:04:29,05 they're under the image, 108 00:04:29,05 --> 00:04:31,06 so they're not going to get in the way there. 109 00:04:31,06 --> 00:04:34,02 But now it looks a lot more polished 110 00:04:34,02 --> 00:04:36,00 with those borders and shading.