My standard set up as it is now gives me a well proportioned font with
size = 10 both in the cells and in the column- and row headings at zoom
= 100%.

Now I have dusted off some old, formula filled workbooks where I have
to use font size 12 in the cells and zoom out to 85% to have the same
appearent size of both heading and cell contents.

I remember once to have seen a way of adjusting the heading font, but I
can't remember where. Can anybody help?

NSV


--
nsv
------------------------------------------------------------------------
nsv's Profile: http://www.excelforum.com/member.php...o&userid=26500
View this thread: http://www.excelforum.com/showthread...hreadid=535911

The column and row headings font can be changed at either of........

1. ToolsOptionsGeneralStandard Font.

2. FormatStyleNormalModify

Changes made affect only the current workbook and any new workbooks.


Gord Dibben MS Excel MVP

On Tue, 25 Apr 2006 07:25:08 -0500, nsv
wrote:


My standard set up as it is now gives me a well proportioned font with
size = 10 both in the cells and in the column- and row headings at zoom
= 100%.

Now I have dusted off some old, formula filled workbooks where I have
to use font size 12 in the cells and zoom out to 85% to have the same
appearent size of both heading and cell contents.

I remember once to have seen a way of adjusting the heading font, but I
can't remember where. Can anybody help?

NSV

I found it, thank you very much.

The spreadsheets also contain some command bottons whose font is not
affected by the change so they suddenly grow huge.
How can I reduce this font size?


--
nsv
------------------------------------------------------------------------
nsv's Profile: http://www.excelforum.com/member.php...o&userid=26500
View this thread: http://www.excelforum.com/showthread...hreadid=535911