Join Dennis Taylor for an in-depth discussion in this video Applying underline, strikethrough, subscript, and superscript formatting, part of Excel 2010: Advanced Formatting Techniques.
- View Offline
In addition to changing the color of a font or the actual font design, there're other buttons in the Font group on the Home tab that we might explore also. Certainly, every Excel user knows how to use Bold and Italic, easy on/off toggle buttons. recognize it for underlining, which we might want to do for these three cells, there's certainly is the U. A lot of people have used that. You may not have tried the other variation available in the drop-down called Double Underline. If you look to the right, you'll notice another reference here, and you wouldn't necessarily know until you see it. There is a third and even a fourth kind of underlining available in the Format Cells dialog box.
You can see these two side-by-side. See the difference. The word Single and then Single Accounting. Notice how the line appears with the data. We also see it in Column G. And if you are interested in these variations, let's suppose we want to experiment with this a little bit. We could certainly right-click and jump right into Format Cells. You can also get here by way of Ctrl+ Shift+F. And in the Underline section, in the middle on the left-hand side here, we do see the differences. The previews here pretty much tell the story as well too.
Single, as the preview shows, puts the line pretty close to the data, compared with Single Accounting, which moves the line farther away from the information. So use that as necessary, but they're easy to get to. And here we see the two examples of Double and Double Accounting in these two sets of cells here. Another possible use for the Format Cells dialog box is if you need to use a superscript, for example the number 2 here to make it display the way we see this in Column H, or 2 as a subscript, as in H2O, the way we see it here.
And simply in these cases, highlight the data in question. Perhaps this time we can just press Ctrl +Shift+F, another way to get in there, into that same dialog box. In this case for the example here, we want to use Superscript, click OK, and the 2 looks like that of course here. Similarly we want this to be a subscript. Hit Ctrl+Shift+F. We can do it that way and use Subscript. And a different feature that's also here is something called Strikethrough. You see how it's being used here. And once again, different ways to get there, but Format Cells. Here's the Strikethrough option.
It's a toggle on/off. We are taking it off. We can just as easily put it on. I'm going to highlight these cells because I want to apply Strikethrough. Ctrl+5 is the keystroke shortcut and that is a toggle shortcut, so Ctrl+5 will remove this. I suppose if you think that 5 sort of looks like an S, maybe that will help you remember this. I use this more than I thought I would have when I discovered it a few years ago, but it too is one of those choices available when we enter the Format Cells dialog box. We've talked about Subscript, Superscript, Strikethrough and the various underlining choices are available here as well.
- Saving time with keyboard shortcuts
- Adjusting fonts, cell borders, and fills
- Setting themes
- Formatting numeric data with cell formats
- Using conditional formatting
- Hiding repeating column information
- Printing double-spaced data
- Elbow formatting