Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training program - Excel

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

excel training program - Excel

Resolved · Low Priority · Version Standard

Reply Wed 12 Dec 2007, 14:04Delegate Anies said...

Anies has attended:
Excel Intermediate course

Excel

How do change colour on excel?

For upcoming training course dates see: Pricing & availability

Reply Fri 14 Dec 2007, 13:42Trainer Pete said...

RE: Excel

Hi Anies, Thank you for your post, to change the colour of a cell or a range of cells, select the chosen area, and on the Formatting Toolbar choose the Fill button, from the pallett which appears choose your colour. If you wish to change the text colour, select the range or individual cell, on the Formatting toolbar choose the Text Colour button and from the resulting pallett choose your text colour. Alternatively you could choose the Menu Command Format, Cells and from the options available make your changes to either cell fill or text colour. I hope that helps, best regards Pete

Excel articles

· Customized Financial Excel Courses in London
· Creating Charts with Excel
· Making The Most Of Filtering In Excel
· So Can You Really Sort On Colours In Excel 2007?
· Excel 2010 A Glance Into The Future

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