Table format
 

I want to change the default format for tables (excel 2007) . I know
how to change the default for the open worksheet , but do not know how
to retain this is the default format for new worksheets. Any help on
this subject will be appreciated.

Table format
 

New workbook.

Format as you wish.

Save as Template(*.xltx)

Name it Book and save to XLSTART folder.

This becomes the default new workbook.

For sheets, save as Sheet.xltx


Gord Dibben MS Excel MVP

On Thu, 10 Sep 2009 06:53:58 -0700 (PDT), Steven
wrote:

I want to change the default format for tables (excel 2007) . I know
how to change the default for the open worksheet , but do not know how
to retain this is the default format for new worksheets. Any help on
this subject will be appreciated.