Join Dennis Taylor for an in-depth discussion in this video Applying borders and color backgrounds, part of Excel Essential Training (Office 365).
- [Instructor] In addition to the many different ways to display fonts in Excel, you also have a variety of border options and color background choices to accentuate your data. And both of these features are found on the Home tab and adjacent buttons. There's a Borders button right here, and just to the right of it, the Fill Color bucket. I want a border around these cells. They're the only cells within this worksheet that are pure numbers. I want the data to stand out, just with a border around it. Clicking the drop arrow on the right side of the Borders button reveals all kinds of choices.
How 'bout Thick Outside Borders? Now, many times when you apply a border's features, you're not quite sure if it worked until you click outside of the highlighted area. Well, we've got a border there. But we just can't see it as clearly while it's highlighted. I'll come back here, maybe try a few others. We could put a border on every single cell. How about All Borders? It has that look. And there's one other approach to this, too. Cells are highlighted and we'll come back again with a border, and consider, the very bottom, More Borders, and maybe we want to use color here, as well.
So how about Color for starters, here, use a dark red, and maybe a certain line type. How about a dashed line? And then, as we apply it to the grid to the right, we could choose Outline first, you see the red dashed outline, how about the inside of the cells as well, too? So we're getting a preview ahead of time. And there's some unusual choices here like diagonal lines which I think you wouldn't need to use very often. Let's click OK, and now we've got that effect. Another approach to borders is, with these cells highlighted, let's say you wanted those to stand out in a certain way.
Use that drop arrow. This time, we could Draw Border. We could draw a border around the perimeter or, we saw the other choice there, draw a border grid. And we could've chose the color before this, I didn't, but we could draw the grid that way, too. So multiple ways of putting in borders in the example here. Now, color background's an easy choice, and sometimes people go overboard with this. We might want these cells to stand out in addition to the border or without the border, either way. Here's the Fill Color bucket. If the color that's there, that's visible, isn't the one you used, just click the bucket.
There it is, it's yellow. If you use another color, you wanna be sure that it's fairly light so that the text shows through. That's not so good there, and this is pretty bad. I think you can quickly see what's going on here. And if you just can't find that color you want, well, come back again and go into More Colors, and probably spend way too much time looking at this, 127 different choices, but if it's gotta be a certain color, you can make that choice. And again, we tend to use these to make certain parts of a worksheet stand out, give it more emphasis, more pizazz.
Sometimes we say it that way. So a variety of different techniques here. Use either border features and/or color background, both located on the Home tab, to provide greater emphasis to our worksheets.
- Working with the Excel interface
- Entering data
- Creating formulas and functions
- Formatting your data
- Adjusting rows and columns
- Finding and replacing data
- Inserting and deleting sheets
- Sorting and filtering data
- Creating charts and PivotTables
- Printing and sharing worksheets
- Protecting worksheets and workbooks
Skill Level Beginner
Q: This course was updated on 1/7/2019. What changed?
A: A new video was added that covers working with Excel Ideas.