Remove explicit formatting only

[Mitch Powell]

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.

 

[Pete_UK]

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

 

[Mitch Powell]

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

 

[Gord Dibben]

Under Format>Font there is an option button "Normal Font"

Enable that button.


Gord Dibben MS Excel MVP

 

[Mitch Powell]

Perfecto! Thank you.

Under Format>Font there is an option button "Normal Font"

Enable that button.


Gord Dibben MS Excel MVP

 

[Mitch Powell]

Follow up question. Now that you've shown how to remove explicit formatting
for fonts, I got curious about how to do the same thing for other formatting
elements (such as number formats) but do not see similar mechanisms for
those. Does this mean that once a cell is explicitly formatting with a
particular number format that it will always be so unless the Normal style is
applied?

 

[Gord Dibben]

A cell with a specific number format will retain that format until changed
through Format>Cells>Number or by changing style which would affect the
sheet.


Gord