Excel header formatting

lamadsen

Distinguished
May 29, 2009
1
0
18,510
0
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

Distinguished
Apr 17, 2009
42
0
18,590
1
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

 
Thread starter Similar threads Forum Replies Date
henrytcasey Apps General Discussion 0
B Apps General Discussion 2
N Apps General Discussion 1
S Apps General Discussion 5
N Apps General Discussion 2
L Apps General Discussion 5
K Apps General Discussion 1
R Apps General Discussion 1
7 Apps General Discussion 37
J Apps General Discussion 11
E Apps General Discussion 15
L Apps General Discussion 5
S Apps General Discussion 1
A Apps General Discussion 1
E Apps General Discussion 1
T Apps General Discussion 1
B Apps General Discussion 23
B Apps General Discussion 2
Q Apps General Discussion 2
JustPlainJef Apps General Discussion 2

Similar threads


ASK THE COMMUNITY

TRENDING THREADS