Chapter 6: Worksheet Formatting
121
FIGURE 6.4You can choose many different font-formatting options for your worksheets.
If you prefer to keep your hands on the keyboard, you can use the following shortcut keys to for-
mat a selected range quickly:l Ctrl+B: Boldl (^) Ctrl+I: Italic
l Ctrl+U: Underline
l (^) Ctrl+5: Strikethrough
These shortcut keys act as a toggle. For example, you can turn bold on and off by repeatedly press-
ing Ctrl+B.
Note
Beginning with Excel 2007, the Document Themes feature attempts to assist nondesigners in creating attractive
worksheets. I discuss document themes later in this chapter. See “Understanding Document Themes.” n
If a cell contains text (as opposed to a value or a formula), Excel also enables you to format individual
characters in the cell. To do so, switch to Edit mode (press F2, or double-click the cell) and then select
the characters that you want to format. You can select characters either by dragging the mouse over
them or by pressing the Shift key as you press the left- or right-arrow key.
After you select the characters for format, use any of the standard formatting techniques. The changes
apply only to the selected characters in the cell. This technique doesn’t work with cells that contain
values or formulas.
Using Multiple Formatting Styles in a Single Cell