ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pattern colors (https://www.excelbanter.com/excel-discussion-misc-queries/236467-pattern-colors.html)

Akram Najjar

Pattern colors
 
I received an Excel file with a far better (and quite different) set of
Pattern colors. I attempted to use the "Copy colors from..." in Options but
could not make the new colors permanently there, as the default Pattern
colors in Excel.

Can I do that?

Shane Devenshire[_2_]

Pattern colors
 
The Copy From command brings the color pallette from one workbook to another,
it does not set the default.

There is nothing in Excel to change the default pallette, however, you can
open a blank workbook and copy the colors in as you did. Then choose File,
Save As, name the file Book, change the Files of type to template (xlt) and
save it to the XLStart folder. You can do a windows search for this folder.
It is usually in C:\Program Files\Office\Office 2003\XLStart

all new workbooks will have the color pallette

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Akram Najjar" wrote:

I received an Excel file with a far better (and quite different) set of
Pattern colors. I attempted to use the "Copy colors from..." in Options but
could not make the new colors permanently there, as the default Pattern
colors in Excel.

Can I do that?


Akram Najjar

Pattern colors
 
Great idea, thank you Shane.

It is wierd that in the Excel Options, you can customise colors as you wish
but not on the toolbar pallete. You can in Word but not Excel. Maybe
Microsoft can do something about that.

Akram

"Shane Devenshire" wrote:

The Copy From command brings the color pallette from one workbook to another,
it does not set the default.

There is nothing in Excel to change the default pallette, however, you can
open a blank workbook and copy the colors in as you did. Then choose File,
Save As, name the file Book, change the Files of type to template (xlt) and
save it to the XLStart folder. You can do a windows search for this folder.
It is usually in C:\Program Files\Office\Office 2003\XLStart

all new workbooks will have the color pallette

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Akram Najjar" wrote:

I received an Excel file with a far better (and quite different) set of
Pattern colors. I attempted to use the "Copy colors from..." in Options but
could not make the new colors permanently there, as the default Pattern
colors in Excel.

Can I do that?



All times are GMT +1. The time now is 07:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com