1 00:00:01,130 --> 00:00:07,490 If you're designing a workbook that has many tabs and you want these tabs to be similar in their setup, 2 00:00:07,880 --> 00:00:12,450 you need to work with cell styles. Because it's going to make your life so much simpler. 3 00:00:12,470 --> 00:00:19,160 Cell styles are available here and this is a similar concept to what you have in word where you can 4 00:00:19,160 --> 00:00:25,050 select the type of font and format you want for the headers and sub headers. 5 00:00:25,070 --> 00:00:28,540 In Excel, you can define the format you want for different purposes. 6 00:00:28,550 --> 00:00:34,580 For example for your input cells, calculated cells. If you click here, you see more options, for your headings 7 00:00:34,580 --> 00:00:36,500 titles and so on. 8 00:00:36,620 --> 00:00:43,040 Having a preset cell style is going to save you from going to the font section here and defining it 9 00:00:43,370 --> 00:00:49,500 for each cell. And then using the Format Painter to apply it to different sheets. 10 00:00:49,520 --> 00:00:54,030 Once you have a style, all you have to do is select it from here. 11 00:00:54,050 --> 00:00:57,910 So for example, let's say we want to apply bold to this title. 12 00:00:57,980 --> 00:01:02,740 We want it to be a different font size. Instead of selecting it from here, 13 00:01:02,750 --> 00:01:07,070 I'm just going to go here and select the title style. 14 00:01:07,300 --> 00:01:08,630 It makes it bold. 15 00:01:08,630 --> 00:01:10,200 It increases the font. 16 00:01:10,220 --> 00:01:13,330 Now these are the defaults we have available in Excel. 17 00:01:13,340 --> 00:01:17,230 We can change them to fit our own company style. 18 00:01:17,240 --> 00:01:22,330 All we have to do is right mouse click that style and select modify. 19 00:01:22,340 --> 00:01:27,980 Here you see a tick mark of these styles that are included for this specific style. 20 00:01:27,980 --> 00:01:31,570 We can go to format and adjust these as we like. 21 00:01:31,640 --> 00:01:34,150 So let's say for title, I want to make it bigger, 22 00:01:34,370 --> 00:01:38,360 Dark gray and I want to use a different font. 23 00:01:38,720 --> 00:01:42,700 Let's go with Arial and click on OK and OK. 24 00:01:42,890 --> 00:01:45,350 Now our title style has changed. 25 00:01:45,350 --> 00:01:46,770 Let's try it here. 26 00:01:47,090 --> 00:01:49,460 Click on the dropdown, select title. 27 00:01:49,460 --> 00:01:52,410 That's the new style that we applied. 28 00:01:52,470 --> 00:01:58,630 I'm going to press Control+z to go back. So you can modify any of the styles that you see here. 29 00:01:58,640 --> 00:02:03,130 And you're not going to need all of these. You're just going to need a handful of styles. 30 00:02:03,230 --> 00:02:09,650 Let's say you have a main title and you have headings and subheadings in your Excel sheet. 31 00:02:09,650 --> 00:02:16,550 You can modify these and use their updated versions. For hyperlink, the default style is this. 32 00:02:16,610 --> 00:02:23,930 If you don't like that, right mouse click and modify. Go to format and change the color then click on OK 33 00:02:24,350 --> 00:02:31,370 and okay. So the hyperlink default changed, every time I add a new hyperlink here and press enter 34 00:02:31,550 --> 00:02:34,670 it takes the new hyperlink cell style. 35 00:02:34,910 --> 00:02:41,180 If you're creating a template that you want other people to input into, you can define a certain style 36 00:02:41,270 --> 00:02:43,180 for input cells. 37 00:02:43,190 --> 00:02:44,860 Excels default style is this one. 38 00:02:44,930 --> 00:02:46,280 I don't like this one. 39 00:02:46,280 --> 00:02:53,060 You just have to right mouse click, modify. Go to format and update it as you like. 40 00:02:53,060 --> 00:03:00,500 Now I usually go with a light yellow or off-white fill. I'm going to change the font color and let's 41 00:03:00,500 --> 00:03:05,100 go and adjust the fill color. Click 42 00:03:05,120 --> 00:03:05,870 on Ok 43 00:03:05,900 --> 00:03:09,440 and Ok. Let's use input on this. 44 00:03:10,010 --> 00:03:11,920 That's how input cells look like. 45 00:03:11,960 --> 00:03:15,210 So if you're designing a template, you want people to input here. 46 00:03:15,320 --> 00:03:16,450 You can highlight this, 47 00:03:16,450 --> 00:03:20,930 click on input and you've already applied the style to it. 48 00:03:20,930 --> 00:03:23,330 You can do the same for calculated cells. 49 00:03:23,330 --> 00:03:24,410 That's the default. 50 00:03:24,410 --> 00:03:26,300 Change it as you like. 51 00:03:26,300 --> 00:03:28,480 Now how about defining your own cell style. 52 00:03:28,490 --> 00:03:34,910 So let's say I want to keep this input but I want to create another type of input format. 53 00:03:34,910 --> 00:03:40,780 What you can do is to duplicate it and then modify that duplicate. So right mouse click, 54 00:03:40,780 --> 00:03:42,210 select duplicate, 55 00:03:42,290 --> 00:03:46,580 give it a name and then adjust it as you like. 56 00:03:46,580 --> 00:03:51,360 For font color, let's just change this to this color. 57 00:03:51,380 --> 00:03:52,210 Click on Ok and Ok. 58 00:03:52,460 --> 00:03:58,880 Now every time we use our happy style, it's right there. 59 00:03:58,880 --> 00:04:04,450 Anything you create and duplicate is available under Custom up here. 60 00:04:04,480 --> 00:04:11,270 That's how easy it is to create your styles and then you can use them on all the separate tabs. If you 61 00:04:11,270 --> 00:04:14,690 want your style to be available to other workbooks as well. 62 00:04:14,750 --> 00:04:18,350 You need to save your Excel workbook as a template. 63 00:04:18,350 --> 00:04:21,670 And that's something that we're going to cover at the end of the section. 64 00:04:21,700 --> 00:04:27,740 Before we wrap up, let me show you quickly how you can set defaults for tables as well. 65 00:04:27,740 --> 00:04:34,100 By default, every time you create an Excel table. I'm just gonna go in the data set, press Control+t. 66 00:04:34,160 --> 00:04:36,330 Excel applies its own default style. 67 00:04:36,470 --> 00:04:39,210 I personally don't like this default style. 68 00:04:39,230 --> 00:04:45,550 I always like to go back to the style that I had before. Which means I need to take away this style. 69 00:04:45,580 --> 00:04:48,780 Now you might be happy with another type of style from here. 70 00:04:48,780 --> 00:04:50,270 So let's say with this one. 71 00:04:50,270 --> 00:04:53,630 And that's the one that you want to have as the default. 72 00:04:54,020 --> 00:05:00,910 All you have to do is right mouse click and set as default. If you're like me and you don't like to have 73 00:05:01,090 --> 00:05:04,900 any of these fancy table layouts, you can right mouse click 74 00:05:04,930 --> 00:05:08,880 on the first one and set that one as default. 75 00:05:08,900 --> 00:05:13,640 So now let's go and actually select the one we set as default. 76 00:05:13,810 --> 00:05:16,780 Now every time I create a new Excel table again. 77 00:05:16,800 --> 00:05:22,270 So that's another one, I'm going to press Control+t, it's going to apply this default. Which is going to 78 00:05:22,270 --> 00:05:27,330 save you some time from having to go and changing the default that you get. 79 00:05:27,330 --> 00:05:32,790 Okay so that's how you can use cell styles and setting defaults. In the next lecture let's 80 00:05:32,800 --> 00:05:36,130 look at how we can adjust the theme of Excel.