microsoft excel training - Chart - [demo testing]

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

Resolved · Low Priority · Version Standard

Chart - [demo testing]

by - trainer Katie gold contributer [208 posts] (2007 Jun 29 Fri, 09:51) Reply

how to format columns?

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

RE: Chart - [demo testing]

by - trainer Tracy platinum contributer [586 posts] (2007 Jun 29 Fri, 15:02) Reply

You can change the width of columns but locating your mouse between the letter of the columns and waiting for the shape to turn to a two-headed arrow, then you can drag the column to become wider or narrower as you wish. Also if you double-click on the mouse the column will automatically resize to fit the contents of that column.

I do hope that helps you, if there is anything else please do not hesitate to post in another question

Trace

· 3 Reasons why Your Small Business Office Needs Microsoft Excel Training
· Microsoft Excel Training Course
· Do You Really Need Excel VBA Training?
· Database Tips from an Excel Training Course
· How to Create Better Excel Spreadsheets: Part Three

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