Not possible AFAIK without changing default Font at ToolsOptionsGeneral
which is a global setting for all new Excel workbooks.

You probably wouldn't like the 8 pt font for column and row headers as well
as default font size in cells.

I suggest a quick macro saved in your Personal.xls

Sub Set_Footer_Font()
With ActiveSheet.PageSetup
.LeftFooter = "&""Arial,Regular""&8"
End With
End Sub

That will set the font size to 8 pt for whatever you enter as a left footer.

Which could also be set in the above macro.


Gord Dibben MS Excel MVP


On Mon, 01 Dec 2008 23:31:11 GMT, "bwong" wrote:

I would like to make a change so it becomes default.



It is in Print Preview - Setup - Header/Footer tab. I want to make the font
size 8 as default, I think the current default is 10.



Is this possible?