Hi Les,

Home / Styles / Format as Table - then right click and select as default.
--
If this post helps click Yes
---------------
Peggy Shepard


"LesG" wrote:

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

"pshepard" wrote:

Hi Les,

Home / Styles / Format as Table - then right click and select as default.
--
If this post helps click Yes
---------------
Peggy Shepard


"LesG" wrote:

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

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

"pshepard" wrote:

Hi Les,

Home / Styles / Format as Table - then right click and select as default.
--
If this post helps click Yes
---------------
Peggy Shepard


"LesG" wrote:

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

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

"LesG" wrote:

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

"pshepard" wrote:

Hi Les,

Home / Styles / Format as Table - then right click and select as default.
--
If this post helps click Yes
---------------
Peggy Shepard


"LesG" wrote:

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

Les

Create a Template for all new workbooks.

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

Save AsFile TypeTemplate(*.xltx)

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


Gord Dibben MS Excel MVP



On Thu, 17 Sep 2009 22:46:01 -0700, LesG
wrote:

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

"pshepard" wrote:

Hi Les,

Home / Styles / Format as Table - then right click and select as default.
--
If this post helps click Yes
---------------
Peggy Shepard


"LesG" wrote:

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

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.
--
If this post helps click Yes
---------------
Peggy Shepard


"Gord Dibben" wrote:

Les

Create a Template for all new workbooks.

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

Save AsFile TypeTemplate(*.xltx)

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


Gord Dibben MS Excel MVP



On Thu, 17 Sep 2009 22:46:01 -0700, LesG
wrote:

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

"pshepard" wrote:

Hi Les,

Home / Styles / Format as Table - then right click and select as default.
--
If this post helps click Yes
---------------
Peggy Shepard


"LesG" wrote:

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

Thanks Peggy

I forgot to post that info<g


Gord

On Fri, 18 Sep 2009 09:53:01 -0700, pshepard
(donotspam) wrote:

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