ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   can't change default fonts (https://www.excelbanter.com/excel-discussion-misc-queries/197312-cant-change-default-fonts.html)

LeeCC

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

Gord Dibben

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



LeeCC

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




Gord Dibben

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



LeeCC

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




Gord Dibben

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





LeeCC

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





LeeCC

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






All times are GMT +1. The time now is 09:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com