More on AutoFormat

We introduced you to the AutoFormat feature in our previous tip. You may have noticed that the AutoFormat dialog box has an Options button. Clicking this button will display the following formatting specifics:
- Number - Border - Font - Patterns - Alignment - Width/Height
By default, they will all be selected. If you'd like to omit one or more of the formatting specifics from a particular scheme, deselect that option before applying the format to your data. For instance, if you want to retain the worksheet's font, deselect the Font option before applying the AutoFormat.