Exploring font choices not found on the Home tab

- [Instructor] Excel has a lot of formatting options under the heading of Font. And on the Home tab, you've got a font group with lots of choices, but there are additional ones as well. First of all, you might not have recognized and right now as we see the letter D here, you might be saying well, don't you usually see a U there? Well, there is an option for double-underlining and if you click the arrow to the right here, you will see those options. So if for example, I click cell A1 and I want to choose double-underlining, if that's active I can choose it or click the drop-arrow, Double Underline.

Or go back to Underline. Or simply remove it by pressing the U. But, if we click this button in the lower right-hand corner of the font group or press Control-Shift-F, either one, it takes us to this dialog box. The Format Cells dialog box and the Font tab is active. Now in addition to those two kinds of underlining, we also see Single Accounting and Double Accounting. Let me close this dialog box momentarily, because off to the side, we see depictions of these.

Single underlining, we see it there. Double underlining, probably no surprise once you see that and you'll remember it. But notice what we have here. Single Accounting, what's the difference between these two, Single and Single Accounting underlining? The line here is farther away from the text. And in the process by the way, the row will become taller. And here's how it looks with numbers. Compare these two for example. We also have the option of Double Accounting. Contrast that with Double, same general idea. When you apply these, it makes the row taller.

So as I point to the boundary between row seven and eight, and hold down the left mouse button momentarily, that's 23 pixels high. The row above it, 20 pixels. And so are most of the rows here. But wherever we are using either Double Accounting or Single Accounting, the row is taller. But we can't get to these features except by way of that dialog box. So at different times if you want to use those features, you do want to press Control-Shift-F to get there quickly. Now there's some other options too.

You've probably seen this before, that's Einstein's famous equation, but this is how we typically see it, so how do we type this in Excel? Well we will type it this way, E equals MC2, then highlight the two and press Control-Shift-F, and then here we apply the feature here called Superscript. Let me move this over a little bit. So I've highlighted only the two. Then click OK and we see how the two is looking that way.

H2O, same general idea. We'll double-click in here, highlight just the two. Once again, jump in the Format Cells dialog box, Control-Shift-F, and this time it's Subscript, off to the left here we see this option. And complete the entry. Now, you'll notice that there's Strikethrough here and that's available also but it does have a keystroke shortcut. If I want to apply this or turn it off, I'll press Control-five, turns it off. Or, we apply it. It doesn't necessarily have to be across all those cells either.

It does nothing to the content whatsoever. And you can't check for it in an IF function or anything like that. And it doesn't change the content in any way. But it is a good visual at times to perhaps represent the fact that this person has left the organization, yet we still want to keep the information there. So that too is available by way of Control-Shift-F in that same dialog box, but typically once you know that keystroke shortcut, you won't need to be using Strikethrough. Most of the other features that we see here are available on the Home tab, so we really don't have to come here that often.

But from time to time, you will want to be aware of those different kinds of underlining capabilities, the occasional need to use Superscript or Subscript, and also the ability to use Strikethrough. Remember, it's Control-five if you want to use the keystroke shortcut.