Microsoft Office Tutorials and References
In Depth Information
Fonts and Color
Formatting Cell
Appearance
Tip: Thanks to Excel’s handy Redo feature, you can repeatedly apply a series of formatting changes to
different cells. After you make your changes in the Format Cells dialog box, simply select the new cell you
want to format in the same way, and then hit Ctrl+Y to repeat the last action.
Rather than heading to the Format Cells dialog box every time you want to tweak
a font, you can use the ribbon’s handy shortcuts. The Home Font section displays
buttons for changing the font and font size. You also get a load of tiny buttons for
applying basics like bold, italic, and underline, applying borders, and changing the
text and background colors. (Truth be told, the formatting toolbar is way more
convenient for setting fonts because its drop-down menu shows a long list of font
names, whereas the font list in the Format Cells dialog box is limited to showing an
impossibly restrictive six fonts at a time. Scrolling through that cramped space is
like reading the phone book on index cards.)
Without a doubt, the ribbon’s most useful formatting feature is live preview , a frill
that shows you the result of a change before you’ve even applied it. Figure 16-12
shows live preview in action.
Figure 16-12:
Right now, this
spreadsheet’s creator
is just thinking about
using the stylish
Baskerville Old Face
font for this table.
However, the moment
she hovers over Arial
(higher up in the font
list), Excel switches
the currently selected
cells on the worksheet
to that font, providing
a preview of the
change. The best
part: When she
moves the mouse
pointer away, the
formatting disappears
instantaneously. To
make the changes
stick, all she needs to
do is click the font.
This live preview
feature works with font
names, font sizes,
and colors.
 
Search JabSto ::




Custom Search