Theme Colours

The UK's most regular instructor-led training courses.
Training information: microsoft+excel+training · Excel courses · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2007

1 post

ReplyFri 12 Mar 2010, 17:02Delegate Sarah said...

Sarah has attended:
Excel Introduction course

Theme Colours

How do I set our company colour palette (saved as a theme) to default throughout excel and word?

Version	Date	Location	Places available	Book	Next place rate (£)		List price
Excel VBA Intro Intermediate 2 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice	List price
2007	Mon 9 + Tue 10 Aug 2010	Bloomsbury	0	FULL			£495
2003	Wed 11 + Thu 12 Aug 2010	Southwark	3		£495	£495	£495
2003	Wed 25 + Thu 26 Aug 2010	Bloomsbury	8		£450	£455	£495
2007	Thu 2 + Fri 3 Sep 2010	Bloomsbury	5		£490	£495	£495
2003	Wed 8 + Thu 9 Sep 2010	Southwark	8		£450	£455	£495
2003	Tue 21 + Wed 22 Sep 2010	Southwark	8		£450	£455	£495
Full Schedule: See all 47 Excel VBA Intro Intermediate course dates. Bookings currently available until 28th September 2011.

715 posts

ReplyMon 15 Mar 2010, 11:10Trainer Simon said...

RE: Theme Colours

Hi Sarah,

Thank you for your question and welcome to the forum.

The following instructions below should allow you to use the same theme in Word, Excel or PowerPoint.

Create your theme in your chosen application and then save it to the default document themes folder and then it will be available in the other applications via Custom themes. The path to this folder will be similar to the following link below:

C:\Users\Trainer\AppData\Roaming\Microsoft\Templates\Document Themes

Trainer is my login name.

I hope this answers your question.

Regards

Simon

Mon 22 Mar 2010: Automatically marked as resolved.

· A Blinking Good Excel Tip
· Microsoft Excel Courses Teach Advanced Macro Techniques
· Coping With Compatibility In Excel 2007
· Why Excel Training (Sometimes) Doesn't Work and What You Can Do About It
· Making The Most Of Filtering In Excel

Please browse our web site to find out more about
microsoft+excel+training and other Microsoft training courses.

Excel tip:

Hide data in Excel Worksheets

Let's say you have some data in cell 'C5' you would like to hide from the casual viewer.

Click cell 'C5' to select it.

Click the 'Format' menu, select 'Cells'. When the 'Format Cells' dialogue box opens, click the 'Numbers' tab (if necessary), then select 'Custom' from the 'Category' list.

Double-click the 'Type' entry box and type three semi-colons: ";;;"

Click 'OK' to close the dialogue box and accept the new formatting.

The data in cell 'C5' disappears. It's still there and will work in calculations, but it isn't visible.

If you need to check the data, just click the blank cell and the contents appear in the 'Formula bar'.

View all Excel hints and tips