TABLE DEFAULT FORMAT

  • Thread starter Thread starter LesG
  • Start date Start date
L

LesG

I have just converted to 2007. When I create tables (old lists in previous
versions), it appears that the default format is a striped blue format. I
know how to change the format and create new formats, but what I would like
to do, is change the default format to either another pre-defined format or
one of my own formats... I cant seem to find this functionality anyweher.
HELP!!
 
Hi Les. Try:-

Home / Styles / Format as Table.

If my comments have helped please hit Yes.

Thanks!
 
Hi Peggy,
I tried that, but only sets the default in that specific workbook. If I open
a ne workbook, the old "blue" style is sill defaulted.
 
sorry, that was suppose to read... "I also forgot to mention that any style I
create is also not available in new workbooks"
 
Les

Create a Template for all new workbooks.

Open a new workbook...........format as you wish.

Save As>File Type>Template(*.xltx)

Name it BOOK............this will be default for NEW workbooks.


Gord Dibben MS Excel MVP
 
Excel 2007 -

If you search on default style, help in Excel will give you more detail on
how to do this.

Be sure to save the template into the XLSTART folder, you can find the path
using Windows Explorer.

After making changes to a blank workbook and saving the file name as
BOOK.xltx into your XLSTART folder - close Excel and reopen to see a new
blank workbook with the changes that you have made.
 
Back
Top