1 00:00:06,799 --> 00:00:08,148 Hi there! 2 00:00:08,148 --> 00:00:12,970 In this video we’re going to format the table we created in the last lesson, so let’s get started. 3 00:00:13,970 --> 00:00:18,220 We’re going to start with the header, so let’s select it, and change the font to 4 00:00:18,220 --> 00:00:20,290 ‘Raleway Bold.’ 5 00:00:20,290 --> 00:00:26,859 Let’s now select the entire cell by clicking, holding, and moving the cursor down. 6 00:00:26,859 --> 00:00:31,740 Once the cell is selected, change its color to blue. 7 00:00:31,740 --> 00:00:35,960 Since the background is dark, and so is the text color, let’s change the text color 8 00:00:35,960 --> 00:00:39,890 to white, for it to be visible. 9 00:00:39,890 --> 00:00:43,989 I think the blue background needs a little bit of updating, so let’s select the cell, 10 00:00:43,989 --> 00:00:48,890 and go to fill, and reduce the opacity to about 84 percent. 11 00:00:48,890 --> 00:00:54,219 Let’s select the cell once again, and change the vertical alignment to center, from the toolbar above. 12 00:00:56,420 --> 00:00:58,100 Perfect! 13 00:00:58,100 --> 00:01:04,989 Now that I have styled my text, let’s go to window, and then styles, and select paragraph styles. 14 00:01:06,460 --> 00:01:10,180 Click the small plus button at the bottom of the paragraph styles panel to create a 15 00:01:10,180 --> 00:01:15,150 new paragraph style, and rename it ‘header.’ 16 00:01:15,150 --> 00:01:23,220 Next, we need to create a cell style, and for that, let’s go to window, and then styles, 17 00:01:23,220 --> 00:01:25,960 and select ‘cell styles.’ 18 00:01:25,960 --> 00:01:28,830 Let’s set the panel aside. 19 00:01:28,830 --> 00:01:32,860 With the cell still selected, let’s click the small plus button at the bottom of the 20 00:01:32,860 --> 00:01:41,280 cell styles panel to create a new cell style, and rename it ‘header cell.’ 21 00:01:41,280 --> 00:01:46,500 Now double-click the new cell style, and in the general tab, update the paragraph styles 22 00:01:46,500 --> 00:01:52,140 to ‘header’, so what this does is, along with the cell styles, it will also incorporate 23 00:01:52,140 --> 00:01:55,400 the paragraph styles, we made a minute ago. 24 00:01:55,400 --> 00:02:01,960 Let’s move to ‘strokes and fills’ tab, and change the stroke color to the same blue 25 00:02:01,960 --> 00:02:08,440 we chose to fill the cell, and set the ‘tint’ to 10 percent, and then hit okay. 26 00:02:08,440 --> 00:02:13,459 So now our cell has the paragraph styles, as well as the cell styles applied to it, 27 00:02:13,459 --> 00:02:17,811 so let’s select the rest of the header, and then click the ‘header cell’ style 28 00:02:17,811 --> 00:02:23,480 to apply the styles to the rest of the header, and the entire header should now be styled. 29 00:02:23,480 --> 00:02:27,970 I think I need to reduce the font size of the header, so let’s select the entire header, 30 00:02:27,970 --> 00:02:32,250 and then double-click the ‘header’ paragraph style. 31 00:02:32,250 --> 00:02:38,100 Move to the ‘basic character formats’ tab, and update the font size to 8 points, 32 00:02:38,100 --> 00:02:39,680 and hit okay. 33 00:02:39,680 --> 00:02:44,180 Similarly, we need to style the body text as well, so let’s select the first cell 34 00:02:44,180 --> 00:02:45,450 of the body text. 35 00:02:45,450 --> 00:02:51,210 Let’s update the font to ‘Raleway Medium’, and then center align it vertically. 36 00:02:51,210 --> 00:02:55,600 Also, reduce the font size to 8 points. 37 00:02:55,600 --> 00:03:00,200 Now with the cell still selected, click the small plus button at the bottom of the paragraph 38 00:03:00,200 --> 00:03:06,270 styles panel to create a new paragraph style, and rename it ‘body text.’ 39 00:03:06,270 --> 00:03:11,370 We will also need to create a cell style, much like we did with the header, so with 40 00:03:11,370 --> 00:03:16,090 the cell still selected, click the small plus button at the bottom of the cell styles panel 41 00:03:16,090 --> 00:03:19,790 to create a new cell style. 42 00:03:19,790 --> 00:03:25,100 Double-click the new style, and rename it ‘body cell.’ 43 00:03:25,100 --> 00:03:28,920 From the ‘paragraph styles’ dropdown, select ‘body text’ paragraph style that 44 00:03:28,920 --> 00:03:32,170 you’ve just created. 45 00:03:32,170 --> 00:03:37,040 Move to the ’strokes and fills’ tab, and change the stroke color to the same blue we’ve 46 00:03:37,040 --> 00:03:43,850 been using in this lesson so far, and update the tint to 10 percent, and hit okay. 47 00:03:43,850 --> 00:03:47,550 Now when you click aside, you’ll find how the cell looks after styling. 48 00:03:47,550 --> 00:03:52,500 So let’s select a few rows, and then click the ‘body cell’ cell style, and you shall 49 00:03:52,500 --> 00:03:57,090 find it inheriting the style immediately. 50 00:03:57,090 --> 00:04:02,141 At this point only those body cells are styled that we manually selected, so to style the 51 00:04:02,141 --> 00:04:05,970 entire table, let’s create a table style. 52 00:04:05,970 --> 00:04:10,360 Click the small plus button at the bottom of the table styles panel to create a new style. 53 00:04:12,770 --> 00:04:17,750 Double-click the new style, and rename it ‘income and expenses.’ 54 00:04:17,750 --> 00:04:22,069 In the cell styles option, from the ‘header rows’ dropdown, select ‘header cell’ 55 00:04:22,069 --> 00:04:27,300 that we created for the header, and from the ‘body rows’ dropdown, select ‘body cell’, 56 00:04:27,300 --> 00:04:31,350 that we created for the body text, and hit okay. 57 00:04:31,350 --> 00:04:35,990 Now select the type tool, and take your cursor to the top left corner of the table, until 58 00:04:35,990 --> 00:04:40,110 it turns to a black bold diagonal arrow. 59 00:04:40,110 --> 00:04:44,629 Click once to select the entire table, and then click the ‘income and expenses’ table 60 00:04:44,629 --> 00:04:49,469 style that you just created, and the entire table should now be formatted as per the styles we created. 61 00:04:51,460 --> 00:04:55,960 One last thing to talk about is the shading, so let’s double-click the ‘income and 62 00:04:55,960 --> 00:04:59,379 expenses’ table style, and move to the ‘fills’ tab. 63 00:04:59,379 --> 00:05:03,860 From the ‘alternating pattern’ dropdown, select ‘every other row’, and you shall 64 00:05:03,860 --> 00:05:07,370 find every alternate row to have shading. 65 00:05:07,370 --> 00:05:12,150 If you don’t want the first row of the body text to have the shading, in the ‘skip first’ 66 00:05:12,150 --> 00:05:17,039 option, update the rows to 1, and it shall skip the first row. 67 00:05:17,039 --> 00:05:21,259 If you want a shade of a different color, change the color from the color dropdown, 68 00:05:21,259 --> 00:05:23,580 and the color will be updated. 69 00:05:23,580 --> 00:05:29,729 You can even update the opacity of the color, so let’s change it to 10 percent. 70 00:05:29,729 --> 00:05:34,530 At this point, the next row is set to none, which is why it is white, so let’s change 71 00:05:34,530 --> 00:05:43,000 it to black, and then update the opacity to 10 percent, and this is how it looks, so you 72 00:05:43,000 --> 00:05:47,089 can change it to any other color of your choice, or just let it remain white, so I’m going 73 00:05:47,089 --> 00:05:52,710 to change it back to none, and then you can always change the pattern from here, should 74 00:05:52,710 --> 00:05:53,800 you want to. 75 00:05:53,800 --> 00:05:57,069 ‘Every second row’, will give you this look. 76 00:05:57,069 --> 00:06:01,719 ‘Every other column’ will look something like this, which can further be customized 77 00:06:01,719 --> 00:06:06,199 as per the color scheme of your choice, so play with the settings, and format the table 78 00:06:06,199 --> 00:06:11,259 as per your needs, and you shall be amazed at the awesomeness of the styles. 79 00:06:11,259 --> 00:06:12,960 Alight guys! 80 00:06:12,960 --> 00:06:17,409 That concludes our session, and this unit as well, so I’m going to see you in the 81 00:06:17,409 --> 00:06:19,490 next one in just a bit. 82 00:06:19,490 --> 00:06:20,209 Good bye!