Microsoft Office Tutorials and References
In Depth Information
Fonts and Color
Note: No matter what font you apply, Excel, thankfully, always displays the cell contents in the formula
bar in easy-to-read Calibri font. That makes things easier if you’re working with cells that’ve been
formatted using difficult-to-decipher script fonts, or really large or small text sizes.
poWer Users’ CliniC
Formatting Individual Characters
The ribbon lets you perform one task that you can’t with
the Format Cells dialog box: applying formatting to just a
part of a cell. For example, if a cell contains the text “New
low price”, you could apply a new color or bold format to
the word “low.”
3. Choose a
You can also change the size, the color, or the bold,
italic, or underline settings. And if you don’t want to
waste time choosing the Home tab if you’re currently
somewhere else in the ribbon, then you can simply
right-click the selected text to show a pop-up toolbar
with font options.
Applying multiple types of text formatting to the same
cell can get tricky. The formula bar doesn’t show the
difference, and, when you edit the cell, you may not
end up entering text in the font you want. Also, be
careful that you don’t apply new font formatting to
the cell later; if you do, you’ll wipe out all the font
information you’ve added to the cell.
To apply formatting to a portion of a cell, follow these steps:
1. Move to the appropriate cell, and then put it
into edit mode by pressing F2.
You can also put a cell into edit mode by
doubleclicking it, or by moving to it, and then clicking the
text inside the formula bar.
2. Select the text you want to format.
You can select the text by highlighting it with the
mouse, or by holding down Shift while using the
arrow keys to mark your selection.
Most fonts contain not only digits and the common letters of the alphabet, but also
some special symbols that you can type directly on your keyboard. One example is
the copyright symbol ©, which you can insert into a cell by entering the text (C) , and
letting AutoCorrect do its work. Other symbols, however, aren’t as readily available.
One example is the special arrow character . To use this symbol, you’ll need the
help of Excel’s symbols. Simply follow these steps:
1. ChooseInsert ➝ Symbols ➝ Symbol.
The Symbol dialog box opens, as shown in Figure 16-13. Now it’s time to hunt
for the symbol you need.
If you’re looking for a fairly common symbol (like a mathematical sign, an
arrow, an accented letter, or a fraction), you probably don’t need to change the
font. In the Font box, keep the automatic selection of “(normal text)”, and then,
from the Subset box at the right, choose the type of default. For example, choose
the Arrows subset to see arrow symbols that point in different directions.