From the course: Excel Essential Training (Microsoft 365)

Exploring font styles and borders

From the course: Excel Essential Training (Microsoft 365)

Start my 1-month free trial Buy for my team

Exploring font styles and borders

“

- [Instructor] On this worksheet called fonts in our 04 formatting file, we see a different font size being used in row one and the home tab is currently active as it often is. And these various sections here are referred to as groups. And the group called Font right here includes lots of features related to the size of text, the style of it, the color of it, and so on. There are border options here and color backgrounds. We'll deal with those in the next movie. But if I simply want the title entry here to be larger, here's a number, 20. Click the drop arrow. As I slide over this, you can see what's happening in the background. We're using a larger font size and that's appropriate for certain kinds of titles here. I'll stop on this one and leave it that way. In Excel, the standard font size is 11 and we see that as we click on these various cells. You see it up on the home tab. And the standard font is Calibri. That earlier title that we had seen as called Candara. And when you're working with titles, sometimes to enliven a worksheet, make it a bit more prominent, we'll get to the color background in the next movie, but using a different font sometimes makes sense. And this can be a real time waster. They're just many, many different font types out here and as you slide over these, you get a brief preview. Some of these would be completely inappropriate for business purposes. Don't use the chiller font unless you're doing a Halloween greeting card or something like that. Off to the right is a reminder and not really that important anymore, but in older versions of Excel, prior to 2007, aerial was the standard font, size 10. Now it's Calibri, size 11. And much of the time we don't really care, but just a brief note there about the comparison of the two. And at different times you might want to make fonts larger to make the data stand out a little bit more differently, or for example, maybe we just want to take this data here and make that be more prominent than the other data. We could make that be 12 font or 14 font as needed. Sometimes it looks like you're just playing with the data, but use those judiciously. And if there are not enough choices here, or if you heard that there are more choices, well there are. Each of these groups has a little tiny arrow in the lower right hand corner, font settings. I'm going to click the arrow here and in addition to some of the features we've already seen, here are the different font types, bold, metallic underline we didn't really talk about, but they're up there as well too. But some additional features like superscript and subscript, so we can get to those features as well. And not only do we have standard underlining off of the U button, but also we've got double underlining, single accounting, double accounting, some features that are not widely used, but yet are available. That superscript by the way, is used down in cell B 17 where we simply highlight the number two there and that didn't happen automatically. We have to highlight the number two and then use that arrow button here, as we did here, and choose super scripting. see what was chosen here already. And subscript, if you're putting in for example, H20. So specialized uses for this capability as well too. There's a strike through feature, you can use that too by way of that same button here. And you can also get into this dialogue box here if you press control+1. So most users most of the time can get by with the buttons that we see here. Two others I didn't mention. Just quickly, you can make fonts larger with the increased font size or smaller with a decreased font size here too. And so at different times, changing the style of the font, the size of it, bold, metallic, underlining as necessary, all these can be used in either creative ways or simply to provide emphasis for certain parts of a worksheet.

Contents