TABLE DEFAULT FORMAT

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!!
 
T

trip_to_tokyo

Hi Les. Try:-

Home / Styles / Format as Table.

If my comments have helped please hit Yes.

Thanks!
 
L

LesG

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

LesG

I also forgot to mention that ay style I create is alos not available in new
workbooks
 
L

LesG

sorry, that was suppose to read... "I also forgot to mention that any style I
create is also not available in new workbooks"
 
G

Gord Dibben

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
 
P

pshepard

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