Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Format cells to make them stand out using fonts, font size, color, and borders.

Cell styles
  1. Select a cell or cell range in the worksheet.

  2. Select Home > Cell Style Cell Style .

  3. Select the cell style that you want to apply.

Select a font, font size, font color, and border
  1. Select a cell or cell range.

  2. On the Home tab, select a Font and Font Size from the drop-down.

  3. To change the font color, select Font Color Font Color and select a color from the drop-down. to change the text color.

    Note: If you want to see more colors, select More Colors from the drop-down, and select a color from the Standard or Custom tab.

  4. To change the font style, select Bold, Italic, or Underline.

  5. To change the Border, select a border Border from the drop-down.

Want more?

Discover more courses like this at LinkedIn Learning

Change the format of a cell

Copy formatting using the Format Painter

And maybe we just want these numbers here, January through December, not the total.

Ignore the totals on the right side and on the bottom.

We want these cells to stand out a little bit differently.

On the Home tab in the ribbon, we've got a choice called CellStyles and lots of choices.

As we slide over these we see different color backgrounds, and by the way notice you always see the words bad, and good, and neutral.

Of course the data is standing on its own for whatever it might mean.

You can ignore the real meaning of the words good and bad as you choose some of these colors.

As you look at these colors one thing you'll probably recognize is that we're not seeing, for example, a canary yellow or a bright red or a chartreuse here. This is a limited palette.

I don't see any purples in here. The general idea is if you're using different colors in a worksheet, if the colors come from the same general color palette, they're likely to be more complimentary.

You may or may not know about color design.

I sure don't know much about it.

But I do see in the example here, that these colors do compliment one another somewhat nicely.

Maybe I'll go with this darker accent here. I'll use that.

On the Home tab in the ribbon we've got a group called Font.

Not all of the buttons here are related to fonts, most of them are.

We've got a title in this worksheet right here and I click this cell A1, recognize it says Broadway.

There are lots of different fonts we can see here.

If you are exploring these or trying to change them, and your data happens to be over in column A the way mine is right here, you might either temporarily put in some new columns.

This will allow you to see the choices a bit better.

So I've just slid across cells A, B, and C, right click on Insert to move those over.

And we could if we wanted to explore some of the different font types that available here.

You can see, not necessarily all of what's happening in the background, probably enough to get some idea as to whether you want to make some changes here.

Depending on the operating system that you're using, or possibly the version of Excel, you might see different choices out there.

Some people probably spend a bit more time on this than they need to.

The standard font in Excel is called Calibri since 2007.

The previous font was called Ariel. You'll still see both of those used a lot.

There is a difference and on this worksheet, as I scroll to the right, notice right here as we highlight the data here, recognize this idea too.

When you're highlighting cells you will see on the Home tab, for example, Calibri 11 or Ariel 10, whatever it might be.

But that really only refers to the first cell.

It doesn't necessarily mean the others are the same or not the same.

And as you happen to look over this list, maybe this looks a little bit small. Is that size 11? Yes, it is.

But this is size 10. So be alert to that. Sometimes you care about the sizes, sometimes not.

Here's just a comparison, by the way, of Ariel and Calibri and how they look. So the old standard, Ariel 10, prior to Excel 2007.

I think most people are probably using the newer version now, Calibri size 11.

But of course you always have the option to change the font, that's those various fonts that we saw, as well as the size of the font.

I don't need those empty columns anymore.

I'll simply drag across these, right click, and delete them.

Also, in this particular worksheet, notice we're seeing blue text, orange text.

We can change the font color at anytime.

More widely used in titles than with numbers.

For example, right here we could, if we don't care for that color, possibly go to the font group on the Home tab.

There's that button right there called Font.

If we click it now, we'll get red font.

We've got a drop arrow and lots of choices here.

In Excel, so-called live preview effect is working right now and so as I'm sliding over these we see the color changing on the font.

Most of the time, background on the Excel worksheet is white, or at least light color, so you're likely to use darker colors for the font so that the text shows up clearly.

If for whatever reason you're not finding the Colors you want out here, you certainly can go to the option called More Colors and explore some of the 127 colors that are here, some of which are already available anyway.

In addition to changing the color of the font, sometimes you of course want to add bold or italic.

I think these bits of information here are readable in bold, but if they're not, they look like that.

So from time to time that's certainly available. Italics.

These are buttons all easy to work with.

Learning doesn't stop here. Discover more expert led tutorials at LinkedIn Learning. Start your free trial today, at

Enjoy one month of free access to LinkedIn Learning

Learn from recognized industry experts, and get the business, tech, and creative skills that are most in demand.

  • Get unlimited access to over 4,000 video courses.

  • Receive personal recommendations based on your LinkedIn profile.

  • Stream courses from your computer or mobile device.

  • Take courses for every level – beginner to advanced.

  • Practice while you learn with quizzes, exercise files, and coding windows.

  • Choose a plan for yourself or your entire team.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!