How do I change the column header font?

[Bagharmin]

It appears I knew how to do this at some point because I have two workbooks where the column headers for one of them (i.e., "A", "B", "C", etc.) are displayed using a different font than the other. How can I change it so that the "A" in column A is displayed using the font I want?

I'm using Excel 2007. I looked through the options and know how to change the font on the worksheet, but I can't find how to change the column and row headers.

Thanks.

 

[Ron Coderre]

The Row/Column header display font is controlled by the Normal style.
• Right-click on the Normal ribbon button (on the Home tab)
...Select: Modify
...Change the fond to whatever suits you

NOTE: changing that font also impacts the default font throughout the workbook (and maybe all others, too...I haven't tested)

Does that help?

 

[MrKowz]

See this link: http://www.sqldrill.com/excel/gener...-i-change-font-row-column-headers-2007-a.html

 

[Bagharmin]

Thank you both. I've got my new workbooks set up the way I want thanks to the link and Ron, your suggestion quickly fixed my old workbook. Again, thank you both for all your help.