Let’s take a look. Here we have a simple coffee menu. Let’s improve the formatting by applying some custom fonts. To apply a font to one or more cells, first select the cells you’d like to format. In this case, let’s start by applying a new font to the entire worksheet. The easiest way to apply a font is to use the menu in the Font group on the home tab of the ribbon. The font menu on the ribbon displays each font in its own typeface. To apply a font, just click a font in the menu. Let’s also apply the currency format to all prices. Use the Control key to add non-adjacent cells to a selection, then apply the format. Now, let’s apply a different font to the headings. First, we need to select all the headings using the Control key as before. The font controls on the ribbon have a nice feature called “live preview.” When you hover your mouse over a font, Excel will display a preview of that font applied to the worksheet. When you move your mouse away, the preview disappears. This makes it easy to quickly experiment with fonts without actually having to apply them. To leave the font menu without applying a font, just press Escape. If you know the name of font you’d like to apply, you can speed things up by typing the first few letters of the name in the font menu. Excel will scroll the list as needed and stop on the best match. To find a different font, just backspace and start typing again. Press Enter to accept the font that has been highlighted in the font menu. To adjust font size, you have several options. You can select from a list of common sizes from the font size menu, or you can just type a size directly into the list. Excel also provides buttons to increase and decrease font size. The first button increases font size, and the second button decreases font size. 

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.