Excel

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

Resolved · Low Priority · Version 2003

Excel

David has attended:
Excel Intermediate course

by - delegate David [1 post] (2008 Jun 10 Tue, 17:01) Reply

How do you get rid of clipboards for all time?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 9 Fri	Bloomsbury	1	book now	£240	£245
2007	2009 Jan 14 Wed	Bloomsbury	5	book now	£235	£245
2002/XP	2009 Jan 14 Wed	Tooting	0	FULL
2003	2009 Jan 16 Fri	Southwark	0	FULL
2007	2009 Jan 21 Wed	Bloomsbury	3	book now	£240	£245
2003	2009 Jan 21 Wed	Southwark	2	book now	£235	£240
Full Schedule: See all 114 Excel Advanced course dates. Bookings currently available until 31st March 2010.

RE: Excel

by - trainer Amanda diamond contributer [1298 posts] (2008 Jun 11 Wed, 14:30) Reply

Hi David

Thank you for your question and welcome to the forum.

Try the following:
Open the Clipboard (Edit - Office Clipboard)
Click the Options button down at the bottom of the Clipboard
Select the Collect Without Showing Office Clipboard option.
Close the Clipboard.

I hope this helps.
Amanda

· Database Tips from an Excel Training Course
· Reporting and Analysis with Excel
· Tips for Transitioning to Excel 2007
· Prepare for your MOS Certification with MS Excel Courses
· What's Better Than the Help Function in Excel? Microsoft Training

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

Excel tip:

Bracketed negative numbers

Often Excel users wish to display negative numbers in colour red and bracketed

Intstructions
Step1. Select Format > Cells menu options. Within Numbers tabsheet, select Category = Custom.
Step 2. Select a type such as #,##0;[Red]-#,##0;; that specifies a colour in square brackets.
Step 3. Amend as follows; #,##0;[Red](#,##0;;

Notes: Excel formatting featues are of the form
"Positive; Negative;Zero;Text" separated by semicolon.

View all Excel hints and tips

Rate this page: