Under FormatFont there is an option button "Normal Font"

Enable that button.


Gord Dibben MS Excel MVP

On Wed, 9 Sep 2009 07:29:01 -0700, Mitch Powell
wrote:

All that does is replace any existing explicit formatting with new explicit
formatting. The cells will still not change with the default style.

"Pete_UK" wrote:

Click on the box intersecting the row and column identifiers in order
to select all cells in the sheet. Then you can set the font and size
from the format toolbar, or by right-clicking and selecting Format |
Cells.

Hope this helps.

Pete

On Sep 8, 12:58 pm, Mitch Powell
wrote:
Most cell in my worksheet have been explicitly formatting with a specific
font. I want to remove the specific formatting of the font only such that
the font for those cells will default to (and change with) the "Normal"
style. I realize that removing all formatting will do this but I want to
remove the font style and size formatting only. I can't find a way to do
this.