Format Row and Column headers - Excel 2007

  Format Row and Column headers - Excel 2007

It is feasible to format the Row Numbers and Column Heading in Excel 2007 and Earlier versions.

Here I am going to explain it in Excel 2007.
Go to Home tab, under the "Styles" group there is a drop down for Cell Styles. Click on the drop down.
The very first click-able option is "Normal" under Good, Bad and Neutral. 

Picture1.1 Cell Style

Picture 1.2 Modify

Picture 1.3 Style dialog Box

Right Click "Normal". "Normal" option shows the Font type, size, and other default behavioral value for Excel Row/column and Excel sheet in general.  In the shortcut menu, select "Modify". ( As shown in Picture 1.2 Modify)

Once you click over there. You will get "Style" dialog box with a "Normal" type of formatting. "Normal" type of format comprises of Font type "Calbri" font size 11, with no borders, no shading General Alignment for both. ( As shown in Picture 1.3)

Row and Column Header are formatted with Wingding font. ( As shown in Picture 1.4) 

Picture 1.4  Column and Rows with Wingding Font

Selecting Color in Fill Tab of Format will fill color in Excel sheet, and not in Row/Column headers. See the Row/Column Header font changed to "Lucida Handwriting". ( See picture 1.5 Fill option used)

Picture 1.5 Fill option used

Note: To see the enlarge view of pictures, click on the required picture.