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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set default cell format while retaining overrides 3
How to change default date formula on Excel worksheet 2
TABLE DEFAULT FORMAT 9
Default Cell Format Changed? 5
Excel 2002: How to retain default formating after pasting ? 12
Default Comment Format 1
Excel Format Problem - Date Overrides Format 5
Duplicating Pivot Chart / Changing Pivot Chart data range 4

Back
Top