Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
can't change default fonts
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
can't change default fonts
That setting works only for all new workbooks.
If you start Excel then FileNew 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 FormatStyleModify and make changes there. Gord Dibben MS Excel MVP On Fri, 1 Aug 2008 17:44:01 -0700, LeeCC wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
can't change default fonts
Thanks for the reply.
Unfortunately, I am indeed referring to new workbooks that cant take this new font effect. LeeCC --------------------------------------------------- "Gord Dibben" wrote: That setting works only for all new workbooks. If you start Excel then FileNew 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 FormatStyleModify and make changes there. Gord Dibben MS Excel MVP On Fri, 1 Aug 2008 17:44:01 -0700, LeeCC wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
can't change default fonts
One more note.
When you do change the default font under ToolsOptionsGenral this also affects the font of the row and column headers for new workbooks. Gord On Fri, 01 Aug 2008 20:20:28 -0700, Gord Dibben <gorddibbATshawDOTca wrote: That setting works only for all new workbooks. If you start Excel then FileNew 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 FormatStyleModify and make changes there. Gord Dibben MS Excel MVP On Fri, 1 Aug 2008 17:44:01 -0700, LeeCC wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
can't change default fonts
That is what my problem exactly is: My row and column heading doesnt change. Lee CC ----------------------------------- "Gord Dibben" wrote: One more note. When you do change the default font under ToolsOptionsGenral this also affects the font of the row and column headers for new workbooks. Gord On Fri, 01 Aug 2008 20:20:28 -0700, Gord Dibben <gorddibbATshawDOTca wrote: That setting works only for all new workbooks. If you start Excel then FileNew 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 FormatStyleModify and make changes there. Gord Dibben MS Excel MVP On Fri, 1 Aug 2008 17:44:01 -0700, LeeCC wrote: 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
can't change default fonts
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\E xcel\Options..rightside windowFont Perhaps you do not have permissions to write to the Registry? Can you open the Registry at StartRun 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 On Fri, 1 Aug 2008 21:03:00 -0700, LeeCC wrote: That is what my problem exactly is: My row and column heading doesnt change. Lee CC ----------------------------------- "Gord Dibben" wrote: One more note. When you do change the default font under ToolsOptionsGenral this also affects the font of the row and column headers for new workbooks. Gord On Fri, 01 Aug 2008 20:20:28 -0700, Gord Dibben <gorddibbATshawDOTca wrote: That setting works only for all new workbooks. If you start Excel then FileNew 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 FormatStyleModify and make changes there. Gord Dibben MS Excel MVP On Fri, 1 Aug 2008 17:44:01 -0700, LeeCC wrote: 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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
can't change default fonts
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 ------------------------------------------------ "Gord Dibben" wrote: 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\E xcel\Options..rightside windowFont Perhaps you do not have permissions to write to the Registry? Can you open the Registry at StartRun 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 On Fri, 1 Aug 2008 21:03:00 -0700, LeeCC wrote: That is what my problem exactly is: My row and column heading doesnt change. Lee CC ----------------------------------- "Gord Dibben" wrote: One more note. When you do change the default font under ToolsOptionsGenral this also affects the font of the row and column headers for new workbooks. Gord On Fri, 01 Aug 2008 20:20:28 -0700, Gord Dibben <gorddibbATshawDOTca wrote: That setting works only for all new workbooks. If you start Excel then FileNew 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 FormatStyleModify and make changes there. Gord Dibben MS Excel MVP On Fri, 1 Aug 2008 17:44:01 -0700, LeeCC wrote: 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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
can't change default fonts
I have checked the RegEdit, the Font there is the desired font, but the row and column headings are not. LeeCC -------------------------------------------------- "Gord Dibben" wrote: 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\E xcel\Options..rightside windowFont Perhaps you do not have permissions to write to the Registry? Can you open the Registry at StartRun 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 On Fri, 1 Aug 2008 21:03:00 -0700, LeeCC wrote: That is what my problem exactly is: My row and column heading doesnt change. Lee CC ----------------------------------- "Gord Dibben" wrote: One more note. When you do change the default font under ToolsOptionsGenral this also affects the font of the row and column headers for new workbooks. Gord On Fri, 01 Aug 2008 20:20:28 -0700, Gord Dibben <gorddibbATshawDOTca wrote: That setting works only for all new workbooks. If you start Excel then FileNew 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 FormatStyleModify and make changes there. Gord Dibben MS Excel MVP On Fri, 1 Aug 2008 17:44:01 -0700, LeeCC wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Defining default fonts for charts | Charts and Charting in Excel | |||
How do I Change default Fonts for Excel comments. | Excel Discussion (Misc queries) | |||
cann't change default fonts in excel | Excel Discussion (Misc queries) | |||
change the default automatic color for gridlines and fonts | Setting up and Configuration of Excel | |||
Changing default worksheet tab fonts | Excel Discussion (Misc queries) |