excel Formatting

Excel provides two types of formatting: numeric formatting and stylistic formatting.
Numeric formatting refers to how a number appears in the cell. In addition to choosing from an
extensive list of predefined formats, you can create your own formats (see Figure 2-16). The procedure is thoroughly explained in the Help system.
Excel applies some numeric formatting automatically, based on the entry. For example, if you
precede a number with a currency symbol (a dollar sign in the United States), Excel applies
Currency number formatting. You can also use the conditional formatting feature to apply number formatting conditionally, based on the magnitude of the number.
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 can 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.