How do I save the Recent Colors that I frequently use in Excel.

R

ron13106

Standard color palette too dull. Use 6 or 7 normal colors but Excel doesn't
remember which colors I used previously. How to I change the standard color
palette or get Excel to remember my recent colors.
 
F

FSt1

hi
custom color follows the file in which they were created. so if you open a
blank file, they revert back to default.
To keep the new color palette permanent you need to save the file with the
custom colors as an xl template (.xlt) which is the .XLT file in the XLStart
folder. open a worksheet, create your color pallette, then save the file to
the location above with extention .XLT instead of .XLS. after that every new
workbook you create will have your custom color pallett

regards
FSt1
 

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

CAN I PERMANENTLY CHANGE COLORS IN THE 2003 EXCEL PALETTE 1
How do I lock the color palette? 5
How do I lock the color palette? 3
how do I save a custom color? 1
How do I change the CMYK levels for the different graph bar colors 5
Retrieve Excel Colors 2
Excel: is there a way I can lighten the fill colors in a cell? 1
custom color palette does not get transferred with the workbook. Excel 2003 3

Top