Here's our Microsoft Office Tip for.. February 4, 2002
Click Here to see a complete list of all of our previously released Tips!
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.