Stylistic formatting

Stylistic formatting refers to the formatting that you apply to make your work look good. Many Ribbon buttons offer direct access to common formatting options, but you'll want to access the object's Format dialog box for the full range of formatting options.

The easiest way to get to the correct dialog box and format an object is to select the object and press Ctrl+1. You could also right-click the object and choose Format xxx (where xxx is the selected object) from the shortcut menu. Either of these actions brings up a tabbed dialog box that holds all the formatting options for the selected object.

Excel's conditional formatting feature is particularly useful. This feature, accessed by choosing Home

Styles Conditional Formatting, allows you to specify formatting that will be applied only if certain conditions are met. For example, you can make cells that exceed a specified value appear in a different color.

NEW Excel 2007 has several new conditional formatting options, including data bars, color scales, and icon sets. Figure 2-17 shows the new data bars conditional formatting option that displays a histogram directly in the cells.

Figure 2-17: The data bars option is one of the new conditional formatting features in Excel 2007.


0 0

Post a comment