Excel header formatting

[lamadsen]

Is it possible to change the font COLOR in the header? I recognize the ability to change the font style and size. Also the ability to make the font bold and/or italized.....but I am unable to find the ability to change the color.

 

[TonCharr28]

You're talking about what you click on to select columns and rows right? You cannot change their formatting. However, here's what you can do:

-Consider the first row and first column as your new headers. Fill out the worksheet with the data. Note that since you're using normal cells as headers, you can change their formatting.

-When you're done, go to cell B2 (second row and second column). Select Freeze Panes under the Window menu in Excel 2003, or under the View group in Excel 2007.

-Hide the headers: "Simply choose Options from the Tools menu, click the View tab, and then uncheck the Row & Column Headers option in the Windows section. In Excel 2007, this option is in the View group. Click Show/Hide and choose Headings." Source