Table format

S

Steven

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.
 
G

Gord Dibben

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
 
Top