importing colour palette

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Importing colour palette

Importing colour palette

resolvedResolved · Medium Priority · Version 2007

Jess has attended:
Excel Intermediate course
Excel Advanced course

Importing colour palette

Hi there

We had a custom colour palette set up for Excel 2003 and have now moved to 2007. How do I import the palette, please?

Thanks
Jess

RE: Importing colour palette

Hello Jess,

Hope you enjoyed your Microsoft Excel Intermediate course with Best STL.

Thank you for your question regarding importing a custom colour palette from Excel 2003 to 2007. It seems that you are not the only one looking for a solution to this problem. Microsoft in their wisdom have taken away the old colour palette we liked so much in 2003 and have not provided a way to import our hard work.

The next best thing would be to go to the Page Layout ribbon and in the Themes section select Colors and click Create New Theme Colors. Choose the exact colours you used in 2003 and make sure you save the creation. If you then apply the new colour theme to your worksheet all fonts and fills etc. will take on the colours you have setup. The new setting will always be available for use every time you open Excel.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer

Thu 2 Dec 2010: Automatically marked as resolved.


 

Excel tip:

Wrapping Text in a Cell in an Excel 2010 Workbook

When you have a lot of text you want to put in a particular cell but you can't decrease the font size to fit because the text will then become ineligible, then manually wrap the text in a cell by simply pressing ALT+ENTER.

View all Excel hints and tips


Server loaded in 0.08 secs.