For all new workbooks.

ToolsOptionsGeneralStandard FontSize.

For existing workbooks, right-click on any sheet tab and "select all sheets"
to group the sheets.

CTRL + a to select all cells on the active sheet

Change the font to 8. Select a single cell.

Ungroup the worksheets...............select any of the non-active sheet tabs
to clear the grouping.


Gord Dibben MS Excel MVP

On Mon, 12 Jan 2009 13:09:01 -0800, JAS
wrote:

To save the bother of changing the font size from 10 to 8 in every cell, I
would like to set the default font as 8.