Join Dennis Taylor for an in-depth discussion in this video Adjusting fonts, font sizes, and font colors, part of Excel for Mac 2016: Advanced Formatting Techniques.
- [Instructor] We're looking at the workbook chapter one fonts borders. Its very first sheet is called Font Size Color. On this worksheet, you see various font colors, various font sizes, you might also see or not see in the ribbon menu system. If the home tab is active, you'll see font, alignment, number. These are called groups. You might not see them. If you want to see them, and it does help clarify how we talk about the various features in Excel, go to the Excel command in the ribbon, then Preferences, and choose View.
The very last choice is called Group Titles. If that is off, and it might be in your case, you will not see those terms. I'm gonna leave it on throughout this course. As we look at the screen now, going back to the ribbon, the font group, most of the features that we'll be talking about in subsequent movies, will then be covered as we talk about alignment features, number features, and so on. Now, the fonts that we're seeing except for cell A1 in this worksheet, are the standard fonts that most people see when they use Excel. Anytime you click on a single cell, you'll see the font type listed right here.
Calibri is the default font for Excel. The prior version was called Arial. This is Calibri 11, the other one was Arial 10. Off to the right in columns G, H, and to the right here, you'll see those two fonts side-by-side and you'll see how they're displayed. They're very similar. Calibri 11, in some cases, looks a little bit smaller than Arial 10, but nevertheless, that's the standard font. At different times, of course, you could change these if you wish. Now, one thing to point out to, when you've got multiple cells highlighted, for example, if I highlight these cells here, if you look on the home tab, you'll see that it says Arial, but they're not all Arial.
It just means that the active cell, the one that's part of the group, but the one is not highlighted, is the font in question there, but at different times, if you're clicking on different worksheet cells, sometimes you'll notice a little difference in appearance. If you're curious about the font, you'll see it right there. Click on cell A1 for example, that's Century Gothic size 16. Of course, at different times, particularly with titles, you might wanna increase the font, so maybe I'll make this be 20, and we see the difference, and usually font changes do change the row height.
If you want to explore some of the different font types that are available, it might be easier, for example, in this case, to actually move this over. When you explore these, and I'm about to click the arrow here to the right of Century Gothic, you see lots of choices, but it's dropping down and hiding the very text that we want to change, so what I'm going to do here, just for this one example, is move this into cell B1 and make column A lot wider, at least for the moment, and then possibly focus on some changes. Now, there's just a ton of choices out here. You do get a preview by seeing the actual font as it will look as we scroll up and down here, and one might catch your eye at one point or another.
Some of these are certainly not very appropriate for business environments, but here's Britannic Bold, you might or might not like that. I'll try that, keep your eye on cell B1, and we see the difference. If we want keep that, that's just fine. I'm gonna double-click the boundary between columns A and B, and then move this back over into column A. Just drag its bottom edge left where I put it back there, and eventually we'd do other things with that, perhaps center it using features that are discussed in later movies. The changes that we’re talking about, the font, occur in this group here called font group.
From time to time, you might want make the font bigger, so just to the right here, we've got the increase font size, decrease font size If, for whatever reason, I want the look of these to be a little bit different, maybe just this section, I can certainly experiment with this a little bit, make these a little bit bigger. Notice again, how the row heights are changing automatically or smaller as needed. Notice that the changes here are not necessarily in consecutive order, because we go from 12 to 14, and so on. You can also do this from the keyboard. It's Command + Shift + Right Arrow, and Command + Shift + Left Arrow.
Make these smaller. At different times, we might wanna make these bold. These are bold, and you'll notice by the indicator here, looks bold. Bold, italic, and underline are very similar in that they are what we call toggle switches. I want it on, I want it off, we can try that at different times. Maybe the text down here, this is not bold, we might wanna make it bold, but we can certainly highlight the cells, use that feature easily. Most people are very familiar with this, and there's a keystroke shortcut for each one of these: Command + B, Command + I, Command + U.
Then off to the right, we see some border features, discussed in a subsequent movie, as well as color backgrounds, but we also have font color. This, of course, is blue font, we've got green font here, and again, often these are used just to offset the data a bit, make it stand out a little bit differently. If you are working with numbers, I would strongly suggest keep them in the current black color. If you choose red, sometimes I see that that could be misleading, because in accounting circles and certainly with a lot of spreadsheets, red means negative, so don't use red.
If you are experimenting with other colors, recognize that most of the time, you'll probably want to choose a darker color, because unless you've changed the backgrounds, likely to be white. I've got lots of choices available out here for making different font choices. Sometimes it's just for appearance sake, as we suggested, sometimes you want the data to stand out more prominently, more easily. All available within the font group on the home tab in the ribbon.
- Adjusting fonts, borders, and cell colors
- Aligning text
- Controlling numeric formatting
- Building custom numeric and date formats
- Creating value-based conditional formatting
- Working with tables
- Using styles and themes
- Adjusting row, column, and sheet sizes
- Outlining data
- Adding and formatting images
- Using specialized power formatting techniques