Table format

  • Thread starter Thread starter Steven
  • Start date Start date
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.
 
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
 
Back
Top