Skip to main content
Search form
  • 00:01

    SPEAKER: Hello, and welcome to this section of MasteringExcel.We're going to now turn our attention awayfrom formulas, which is what we were doing recently,and begin to start talking about howdo we format this worksheet.You know, we've spent quite a bit of timemaking sure you understand how to useExcel to get the job done.But we have to admit, just look at this screen here.It's kind of black text, white background.

  • 00:23

    SPEAKER [continued]: It's not a very beautiful-looking thing.So we, in many cases, want to dress it up a little bit,make it presentable, and also just make it more professional.So we're going to be dealing a lot with the Ribbon menuup here, specifically the Font group.This behaves very similar to most word processors out there.So a lot of this stuff is going to be stuff

  • 00:44

    SPEAKER [continued]: that you might already know.But there'll be a couple of nuggets in hereI think you'll find.The first thing is if these are the column titles that I have,I may, in fact, want to change the font, right?So this is kind of a font that I mightwant to change to stand out.So I can do that a couple of ways.Right now, the font is Calibri.I can drop this down.And notice that, as I scroll over the new fonts,

  • 01:06

    SPEAKER [continued]: I get a real-time preview back in the spreadsheet for howit looks.And there are so many fonts to choose from.I mean, you could spend hours.Now, some of these fonts are boring.Like personally, I don't really like Courier New very much.Some of them were very slick, like I like this one a lot.That's pretty cool, I think.

  • 01:27

    SPEAKER [continued]: So in this case, I'm going to scroll downto Microsoft Sans Serif.Not exactly controversial font, but nice-lookingfont nonetheless.So that's how you change fonts.I may want to change the size of this font.So I can go over here again.And I can continue going up, up, up.And you can see Excel stretching the columns as I makethe font larger and larger.

  • 01:47

    SPEAKER [continued]: So we'll just go for just a little bit biggerthan it currently is.One thing I want to show you, as these cells are highlighted,if I right click, remember, it brings up this mini toolbar.This mini toolbar has a lot of the same things--the font selection, the size selection, and so on.The nice thing about that is, if I'm digging aroundin the formulas and I don't reallywant to go back to the Home tab there,

  • 02:08

    SPEAKER [continued]: I can just right click and use the mini toolbar,and maybe change the font or whatever I'm trying to do.All right.Next I want to go over things that I know that you'veseen in other programs before.Here's the bold.You can make it bold.You can make it italicized.You can underline.And some of these things are availablefrom the mini toolbar.

  • 02:29

    SPEAKER [continued]: The bold and the italic specificallyare available from there.All right, now there are a coupleof things that you might want to do to change fonts,to change font characteristics thatare not present on the ribbon.You know, for instance, what about the famous equationE is equal to mc squared.

  • 02:50

    SPEAKER [continued]: So I want to write mx with the two up above,but I don't really know how to do that.If you highlight the number two and then go overto the Font group and click this little flat button here,you get additional font settings.So you can select the font, you canselect the bold and the size, but you can also selectSuperscript, for instance.Go ahead and hit OK.And then that two becomes a superscript.

  • 03:13

    SPEAKER [continued]: Likewise, I want to write somethinglike H2O, our favorite little beverage we have hereon planet Earth.I can highlight the number two, I can go into the font categoryhere, and I can type Subscript, or click Subscript.Hit OK, and suddenly that looks really nice.And the last thing you might want to do-- occasionallyit might work-- let's say we're doingthis profit/loss calculation for our business,

  • 03:35

    SPEAKER [continued]: but for whatever reason, the December quarter wedon't want to look at it.Maybe it has crazy data or something.So let me go highlight December.Let me go open this guy up, and then go to Strike Through.And that's going to draw a line right through December.Those are things that you need to go into this little menuhere to take care of.And last but not least, you can do things

  • 03:57

    SPEAKER [continued]: like changing the font color.You can do it right in here.And notice how the font color is changedright before your very eyes, kind of like a live preview.You could also go to More Colors down hereand select even different colors.So, I like that color.You can also change the background.So this is the fill color.You've got the same kind of dialogue box there.

  • 04:19

    SPEAKER [continued]: So I can go to, like, a light gray or something like that.So that is a overview of how to deal with fonts in Excel.So you've got most of the abilityto change the font size, color, bold, things like thatfrom up here.You can change some of it from the mini toolbar.You can do superscripts, subscripts,and strikethrough from the internal menu down here.

  • 04:40

    SPEAKER [continued]: And just get familiar with it, because youwant to dress up your charts, and youwant to dress up your worksheets so that they're readable.And a lot of times, you'll be highlighting certain things.Like maybe I'd want to highlight this and draw attention.So I might put a fill color, a nice yellow fill color.Maybe a little softer, like that, just soit stands out so that the person that I'mgiving this worksheet to will know exactly what to focus on.

Video Info

Series Name: Mastering Microsoft Excel: Essential Skills


Publication Year: 2013

Video Type:Tutorial

Methods: Practical skills

Keywords: aesthetics; computer literacy; computer programs; Microsoft; Software; Spreadsheets ... Show More

Segment Info

Segment Num.: 1

Persons Discussed:

Events Discussed:



Jason Gibson explains how to make an Excel spreadsheet aesthetically pleasing by changing font and font colors.

Looks like you do not have access to this content.

Font Styles and Colors

Jason Gibson explains how to make an Excel spreadsheet aesthetically pleasing by changing font and font colors.