Colors keep changing

T

Tracey

Hi I'm new to this forum. I use excel alot and I like to change my
colors, I'm not wild about excels default colors. If I have a workbook
and I adjust the colors (Tools/Options/Color...) I will close the
spreadsheet and then later when I reopen it, the colors have all
changed. Is there a way to change all the default colors for all of my
work? Also if I change the colors in 1 workbook, how can I get them to
stay?
Thank you,
Tracey
 
N

Nick Hodge

Tracey

You can get it to stay by changing your colours and then saving the workbook
as a template, called Book.xlt in your xlStart folder. (This has differing
locations on XL versions)

Any customisations made in this book will be loaded with XL
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Colors are suddenly shot, and Excel thinks there's two workbooks inmemory. 3
Word Globally Changing Specific Color Highlight to Background Color 0
Excel 2007: How to change fill color in Theme Colors 2
Changing color 9
alternating colors as column values change w/ CF 4
Changing Tab Colors (Globally) In Excel 2007 1
Colors for Text and Cell Background 3
SUMPRODUCT and SUMIFS combined with Sumifbycolor (VBA code) 1

Top