Hi,

I just went to my File -> Options and changed the default font to 20. I had to close Excel and Open a new workbook for this to stick. I then changed the font in a single cell to 10 and typed in some text. I then selected a range that included this 10 font and did a RIBBON Clear ALL. The font size went back to 20. It sounds like this is the behavior you want.

It sounds like my changing my default font stuck and yours didn't. Where did you change your default??