excel 2007
i am trying to get new worksheets to start with using text in all cells and
wordwrap. i unhide personal.xls, make the changes, save it. close and reopen
excel.

when i open a new worksheet, it is still the old default, though if i unhide
personal.xls it has the changes.

why don't new worksheets have the formatting changes made to personal.xls?
or, is there a different way to change the defaults?

--
jeffrey

Personal.xls isn't the spot for this kind of stuff.

You can create a new workbook template and save it in your XLStart folder.

Name it Book.xlt and do as much formatting as you want.

In xl2003, a new workbook will be created when you click on the New Icon on the
standard toolbar.

In xl2007, you may need to add that New Icon to the QAT (I'm not sure how xl2007
works).

ps.

If you create another workbook named Sheet.xlt (single worksheet???), then this
will be used when you add new worksheets to existing workbooks.

And now that I think of it, you may want to name the template file:
book.xltm
or
book.xltx

It'll depend on wether you have macros in that template file.

jeffrey wrote:

excel 2007
i am trying to get new worksheets to start with using text in all cells and
wordwrap. i unhide personal.xls, make the changes, save it. close and reopen
excel.

when i open a new worksheet, it is still the old default, though if i unhide
personal.xls it has the changes.

why don't new worksheets have the formatting changes made to personal.xls?
or, is there a different way to change the defaults?

--
jeffrey

--

Dave Peterson

dave,
i'm not having any better luck with any of those 4 names, saved either to
xlstart or template folders.

jeffrey

--
jeffrey
"Dave Peterson" wrote in message
...
Personal.xls isn't the spot for this kind of stuff.

You can create a new workbook template and save it in your XLStart folder.

Name it Book.xlt and do as much formatting as you want.

In xl2003, a new workbook will be created when you click on the New Icon
on the
standard toolbar.

In xl2007, you may need to add that New Icon to the QAT (I'm not sure how
xl2007
works).

ps.

If you create another workbook named Sheet.xlt (single worksheet???), then
this
will be used when you add new worksheets to existing workbooks.

And now that I think of it, you may want to name the template file:
book.xltm
or
book.xltx

It'll depend on wether you have macros in that template file.

jeffrey wrote:

excel 2007
i am trying to get new worksheets to start with using text in all cells
and
wordwrap. i unhide personal.xls, make the changes, save it. close and
reopen
excel.

when i open a new worksheet, it is still the old default, though if i
unhide
personal.xls it has the changes.

why don't new worksheets have the formatting changes made to
personal.xls?
or, is there a different way to change the defaults?

--
jeffrey

--

Dave Peterson