SpeedFormats are collections of formatting attributes that you can instantly apply to your data in just a few easy steps. Use the SpeedFormat dialog box to choose from a number of predefined SpeedFormats or to create your own custom SpeedFormat.
Formats
Lists the SpeedFormats that you can use to format selected cells.
Sample
Shows how your data will look with the SpeedFormat you selected.
Add
Adds a custom SpeedFormat to the SpeedFormat list for reuse.
Delete
Removes a SpeedFormat from the SpeedFormat list.
Advanced
Accesses the formatting options that you can use to customize an existing SpeedFormat.
Alignment
Enable to prevent the selected SpeedFormat from applying its alignment settings to your data.
Font
Enable to prevent the selected SpeedFormat's font settings from being applied to your data.
Pattern
Enable to prevent the selected SpeedFormat's pattern settings from being applied to your data.
Font Color
Enable to prevent the selected SpeedFormat's font color settings from being applied to your data.
Border
Enable to prevent the selected SpeedFormat's border settings from being applied to your data.
Numeric Format
Enable to prevent the selected SpeedFormat's numeric format settings from from being applied to your data.
Note
SpeedFormat overrides any existing formats.
Tip
You can enable more than one of the Advanced formatting options at a time
(i.e., Alignment, Font, Pattern, Font Color, Border, and Numeric Format).