The Borders button and the Fill Color button, both on the Home tab, provide numerous options for accentuating cells of interest in a worksheet.
- [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 in the font group on the Home tab. You've got a Borders button with a drop arrow and lots of choices and just to the right of it, so-called Fill Color bucket, also with a drop arrow and lots of choices. We're looking at the Border sheet in our 04 Formatting workbook. In this worksheet here, maybe we'd like to have this data stand out, got it highlighted.
Here's the Border button, click the drop arrow, and we see some choices. I might just want a thick outside border. Just a simple border, lots of choices here. Outside border. Many times when you apply border features, you can't tell if a feature actually has worked until you click elsewhere. Click to the left of this, yes it has worked. That's a thin, standard border. Let's highlight this again. Come back, choose Thick Outside Borders. Let's see that choice. Slightly different. Also maybe the row is slightly taller but you see how the data stands out in a certain kind of way.
There's another way to use this feature. I'm gonna highlight the cells down here this time. Clicking the drop arrow for Borders and observing some of the other choices. We also have an option at the very bottom called More Borders. And this leads us into a dialog box and here we could use different line styles. Here's one here, that's a different one, and then off to the right, I might choose Outline, so it will have that effect. If I want the inner lines to have that same feature, we see it that way too. There's even an option for diagonals, hard pressed to give you a good reason for using that one but it's there as well too.
So we get a preview right here and sure enough as we click OK, you see the result. So no big surprise there. At a later time, maybe we don't want these at all. Highlight them. Coming back to Borders, let's choose No Border. And so they're all gone that way regardless of the border type. There's another option might have caught your eye here. So we click the drop arrow. We can draw either a border or border grid, so I'm going to draw a border on these cells. That's a perimeter border as you can see.
On second thought, I'm gonna undo that, Control + Z, and come back again. This time I'm going to choose a line color first. I'll use a dark red. Then come back and draw a border. And now it's a red line, although it's faintly visible. Probably use a thicker option if I wanted to try that again. I'm gonna undo that again with Control + Z. Another option here, Draw Border Grid right here. Now, I haven't changed the color, so that line color's gonna be the same.
I'll pick a black this time. Come back again. Draw Border Grid, and I'll do it on the lower cells this time. So there, we see the option. So lots of choices. We've seen only a few but there are tons of options there for putting in borders of different types. Now, sometimes color background is all we need. Maybe I'll put a color background on these cells. If the color that's visible on the bucket, now, right now on my screen, that happens to be blue. On your screen, maybe it's yellow. Depends on what you last used. The last time I was using this feature, I was using a light blue, so if I simply want that color here, I'll click it again, but at certain points, you wanna pick the color.
Clicking the drop arrow, be sure to pick a light color if you wanna be able to read the numbers through it. That's not a great choice, pretty obvious, isn't it? Some of these are, some of these aren't. You pick a color, there it is. Background color. Notice that the grid lines have disappeared there. That may or may not be an issue, but some people don't like that idea. When you apply color, the grid lines within it disappear. But for different reasons at different times, we want to apply color. And let's face it. Sometimes it does, if done sensibly, you know, makes the worksheet look a little livelier, a little more interesting, or it offsets the data that you are more interested in.
So both of these features, applying borders or applying a fill color background with these two buttons within the Font group on the Home tab are really valuable is adding color and emphasis to our worksheets.
- Navigating Excel tabs and menus
- Entering data
- Creating formulas and functions
- Formatting rows, columns, cells, and data
- Working with alignment and text wrap
- Adjusting rows and columns
- Finding and replacing data
- Printing and sharing worksheets
- Creating charts and PivotTables
- Inserting and deleting sheets
- Using power functions such as IF and VLOOKUP
- Password-protecting worksheets and workbooks
- Sorting data
- Analyzing data with Goal Seek and Solver
- Creating and running macros