Format of Column & Row Headings

[cganivet]

Hi gurus,

Would someone be able to tell me how to change the font format of the grey column headings (A,B,C,...) going across the top of the sheet and grey row headings (1,2,3,...) going down the left hand side of the sheet?

The format of these headings seems to affect (for example) the actual column width (as viewed on the screen) for a given specified column width (eg. 18). Very annoying sometimes.

Thanks in advance.

 

[pgc01]

Hi Chris

The headings font format is based on the Normal Style, so if you change it the font format ot the headings should automatically also change.

Since this is the default style for the cells editing, if you really want to do it, then maybe you may also want to create a second style, a copy of the Normal Style before you change it, and apply it to the worksheet so that the cells are not affected when you change the Normal style. This should be done at the beginning, or you may lose custom formats you may have defined on some cells.

 

[T. Valko]

Hi gurus,

Would someone be able to tell me how to change the font format of the grey column headings (A,B,C,...) going across the top of the sheet and grey row headings (1,2,3,...) going down the left hand side of the sheet?

The format of these headings seems to affect (for example) the actual column width (as viewed on the screen) for a given specified column width (eg. 18). Very annoying sometimes.

Thanks in advance.

You can change the font of the row/column headers. It may make a minimal difference in column width.

Excel 2003 and earlier:

Tools>Options>General tab>Standard Font

Excel 2007:

Office button>Excel Options>Popular>When Creating New Workbooks>Use This Font

Excel 2010: ?????

 

[pgc01]

Hi again Chris

Just to clarify there's a difference between my solution and Biff's.

With my solution you are just customising the current workbook.

With Biff's solution you are changing the configuration of excel, which means that you'll exit excel, and, from then on, each time you open excel that will be excel's default font.

Hope this helps.

 

[cganivet]

Just brilliant. Both of them are relevant and extremely helpful. Thank you so much.

Cheers.