Microsoft Office Tutorials and References
In Depth Information
Borders and Fills
There’s one idiosyncrasy that you should be aware of if you choose to insert symbols
from another font. For example, if you insert a symbol from the Wingdings font into
a cell that already has text, then you actually end up with a cell that has two fonts—
one for the symbol character and one that’s used for the rest of your text. This system
works perfectly well, but it can cause some confusion. For example, if you apply a
new font to the cell after inserting a special character, Excel adjusts the entire
contents of the cell to use the new font, and your symbol changes into the corresponding
character in the new font (which usually isn’t what you want). These problems can
crop up any time you deal with a cell that has more than one font.
On the other hand, if you kept the font selection on “(normal text)” when you picked
your symbol, then you won’t see this behavior. That’s because you picked a more
commonplace symbol that’s included in the font you’re already using for the cell. In
this case, Excel doesn’t need to use two fonts at once.
Note: When you look at the cell contents in the formula bar, you always see the cell data in the standard
Calibri font. This consistency means, for example, that a Wingdings symbol doesn’t appear as the icon that
shows up in your worksheet. Instead, you see an ordinary letter or some type of extended non-English
character, like æ.
Borders and Fills
The best way to call attention to important information isn’t to change fonts or
alignment. Instead, place borders around key cells or groups of cells and use shading to
highlight important columns and rows. Excel provides dozens of different ways to
outline and highlight any selection of cells.
Once again, the trusty Format Cells dialog box is your control center. Just follow
Your selected cells appear highlighted.
2. SelectHome ➝ Cells ➝ Format ➝ FormatCells,orjustright-clicktheselection,
The Format Cells dialog box appears.
Applying a border is a multistep process (see Figure 16-14). Begin by choosing
the line style you want (dotted, dashed, thick, double, and so on), followed by
the color. (Automatic picks black.) Both these options are on the left side of the
tab. Next, choose where your border lines are going to appear. The Border box
(the square that contains the word “Text”) functions as a nifty interactive test
canvas that shows you where your lines will appear. Make your selection either