Microsoft Office Tutorials and References
In Depth Information
Figure 9-2 The formatted worksheet is easier to read.
You’ll find the Table Formats.xlsx workbook with the other examples on the companion
Worksheet editing involves creating and modifying the content, layout, and organization
of data, while worksheet formatting deals with the appearance and readability of that data.
With formatting, you can take mind-numbing detail and turn it into information by
highlighting the important stuff, adding visual cues and clues, and enhancing overall readability
and organization. Be careful, though—over formatting can be as distracting as using none
at all. Usually, the goal of a good worksheet is to call attention to the right information, not
to showcase Excel’s formatting features (or your mastery of them).
Formatting in Excel is easy: select the cell or range, and use the appropriate buttons and
commands on the ribbon to apply formatting. Many of the most often used formatting
features appear on the Home tab on the ribbon for quick access, as shown in Figure 9-3. In
fact, formatting commands dominate the Home tab; all seven of its ribbon groups include
formatting commands (even the Editing group). Figure 9-3 also shows the Format Cells
dialog box, which you can access by clicking the dialog box launcher in the Font, Alignment,
or Number group on the Home tab on the ribbon. (The dialog box launcher is the small
arrow icon to the right of the title in many ribbon groups.)