can't change default fonts

  • Thread starter Thread starter LeeCC
  • Start date Start date
L

LeeCC

Hello!

I am having EXCEL2003.

I tried to change the default font by TOOLS/OPTIONS/GENERAL/... And the new
font is supposed to take effect in the next opening of EXCEL. Unfortunately
it doesn't work, depsite the new font name being shown under GENERAL.

Appreciate any advice.


LeeCC
 
That setting works only for all new workbooks.

If you start Excel then File>New you should get the new font as default.

Existing saved workbooks retain the font that was default when they were
saved.

To change existing workbooks go to Format>Style>Modify and make changes
there.


Gord Dibben MS Excel MVP
 
Thanks for the reply.

Unfortunately, I am indeed referring to new workbooks that cant take this
new font effect.


LeeCC
---------------------------------------------------
 
One more note.

When you do change the default font under Tools>Options>Genral this also
affects the font of the row and column headers for new workbooks.


Gord
 
That is what my problem exactly is: My row and column heading doesnt change.


Lee CC
-----------------------------------
 
I've run out of suggestions except for..............

This default font setting is stored in the Windows Registry at

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options..rightside
window>Font

Perhaps you do not have permissions to write to the Registry?

Can you open the Registry at Start>Run regedit OK?

If so, what is the setting for Font?

Close Registry, make a change in Excel default font and have another look in
the Registry to see if it took.


Gord
 
Hello!

Thanks again for your effort in helping.

I manage to change the fonts by using Book.xlt. But still, the row and
column headings don't change, only the cell contents changed.


Lee CC
------------------------------------------------
 
I have checked the RegEdit, the Font there is the desired font, but the row
and column headings are not.


LeeCC
--------------------------------------------------
 
Back
Top