Excel AutoFormats give any worksheet a professional look, but you may need to modify an AutoFormat to better suit the needs of a particular project. For example, the AutoFormat you applied might be perfect except that the font used should be different ”to match the font in the rest of your report. You can control individual elements in an AutoFormat so that not all are applied to the current worksheet. These changes are temporary; you can't permanently alter an AutoFormat.
Modify an AutoFormat