Book1 - Save Default Format Settings

M

mdalby

1- I deleted any XLT files in the XLStart folder.
2- I open Excel
3- I make my default settings in the formatting toolbar so that the
border, fill color etc have the default options that I want in the
toolbar.
4- I then save the book as Book.xlt in the XLStart folder
5- When I get back in to Excel the Format Toolbar is back to the
original settings.

Maybe we cannot preset the formatting toolbar to certain settings
automatically.

Thanks for everyone's help.

MD
 
D

Dave Peterson

This was posted by Debra Dalgleish:

This should set the default (fill) colour for any new books:

1. Create a new, blank workbook.
2. Choose Tools>Options
3. On the Colour tab, click on the yellow square
4. Click Modify, select a colour as the default, click OK
5. To make yellow available, select the square that has the same colour
as the new default, and change it to yellow
6. Click OK.
7. Choose File>Save As
8. Save as Type: Template
9. FileName: Book
10. Location -- save the file in your XLSTART folder
11. Click Save


======
And you can do the same thing with the font color. Just look for that color and
modify it.
 
Top