Use the buttons for bold, italic, and underline, as well as font size and font type for increased emphasis and readability for selected data.
- [Instructor] Whether it's for greater readability, increased emphasis, or sometimes simply a matter of personal taste, you might want to change the fonts that are used in Excel. The size of the font, the look of the font. Excel has lots of related features available on the Home tab in this group called Font. We're looking at a worksheet called Fonts in our workbook, 04 - Formatting. I want this data to stand out, I want it to be bold. Highlight it, there's the B. It's what we call a Toggle button. Click it again, we remove it. Do I want it italicized? No, I don't think so.
But maybe, of course. Sometimes you wanna underline data, maybe I want underlining just here. There's Underline. These are easy to use. Notice how it makes the row a little bit taller, we don't care, it looks good. We like the look of it different times. Easy to make changes here. This title is a merged cell, that's something you might not have worked with just yet, but it certainly is larger than everything. And what do we see at the top of the screen? It's size 20. There's a number there, we can slide over these choices to make them bigger, make them smaller. And how about the look of it? Maybe we're not wild about that particular font, it's called Candara in the example here.
But click this, we see lots of choices. And as we slide over these, you can see in the background what's happening. Tons of options here, good and bad, you're the judge, there it is. The standard font in Excel is called Calibri, and as we click on different cells here you see that in the worksheet. And in an Excel worksheet, unless you've made changes, it's size 11, Calibri. And typically we want to keep them the same size. But the way you use Bold, Italic, Underline, your choice. And sometimes, you will want to make other changes as well too. Not so well known, is a little button that we see in the Font group.
It's in the lower right hand corner. As you slide over that button you get a preview of what we're about to see. We see one of these little buttons on the Alignment group, and the Number group as well. They're called Dialogue Box Launchers, that's a bit much maybe. Click it, Font Settings, we click it. And we've got some choices here. Now many of the choices, we've already seen. Bold, Italic, Underline, and we have the sizes, and the different font names here. But also some different kinds of underlining if you're interested in some of these here. As well as features like Strikethrough, Superscript, Subscript.
So if, for example here in the lower part of this worksheet, we're on this worksheet called Fonts, if we want a name like this, that person is no longer an active customer, we want to apply Strikethrough, we've seen how it's being used below. How do we get there? We can go to this button, there's Strikethrough, and Okay. If at a later time that was wrong, we want to change it, it's too late to undo maybe, come back here, same button, same approach, same idea. So, other features are available here. So, for a variety of different reasons, at different times, we want to use Bold, Italic, Underline, different font sizes, and completely different fonts, as we try and make our worksheets look either a little bit more appealing, or more readable.
- 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