Formatting

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

Resolved · Low Priority · Version Standard

Formatting

Ruth has attended:
Excel Introduction course
Excel Intermediate course

by - delegate Ruth [2 posts] (2008 Feb 28 Thu, 15:20) Reply

Colours occasionally "change" on workbooks I use when I close and then return. Is this a known problem with Excel or do you think that it is my computer setup?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Aug 28 Thu	Southwark	0	FULL
2002/XP	2008 Aug 29 Fri	Tooting	0	FULL
2003	2008 Sep 2 Tue	Bloomsbury	4	book now	£207	£215
2003	2008 Sep 4 Thu	Bayswater	5	book now	£195	£205
2007	2008 Sep 4 Thu	Bloomsbury	0	FULL
2003	2008 Sep 9 Tue	Bloomsbury	4	book now	£207	£215
Full Schedule: See all 139 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Formatting

by - trainer Mara silver contributer [73 posts] (2008 Mar 8 Sat, 18:30) Reply

Hello Ruth,
I hope you enjoyed your Excel training sessions with us.

In response to your question, I have not come across this issue, but I have heard complaints related to colour change with Windows Vista and Excel 2007. Are you running these two versions? If so, I believe it is a known bug. If you are running earlier versions, I would need to investigate this further. Perhaps you could give me more detail of what is changing specifically.

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. And please feel free to ask any other questions you may have.

Have a great day.

Regards,
Mara
Microsoft Office Specialist Master Trainer

· MS Excel: Excel At Making The Most Of Your Christmas
· Advanced Excel Training - takes you to the next level
· Customized Financial Excel Courses in London
· What's Better Than the Help Function in Excel? Microsoft Training
· Benefits of learning about Excel charts

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

Excel tip:

Sorting List Subtotals

If you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows.
IMPORTANT: If you do not hide the details rows before sorting a subtotalled list, your subtotals will be removed and all of the rows in your list will be reordered.

View all Excel hints and tips