Column width

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

Resolved · Low Priority · Version 2003

Column width

Pat has attended:
Excel Introduction course
Excel Intermediate course

by - delegate Pat [8 posts] (2008 Apr 29 Tue, 16:15) Reply

how do I make all columns automatically fit the width of the contents, please?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course				List price £225
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 May 19 Mon	Bloomsbury	0	FULL
2003/XP	2008 May 20 Tue	Tooting	0	FULL
2003/XP	2008 May 20 Tue	Bayswater	1	book now	£195	£205
2003/XP	2008 May 22 Thu	Bloomsbury	7	book now	£188	£215
2003/XP	2008 May 29 Thu	Southwark	4	book now	£207	£215
2003/XP	2008 Jun 3 Tue	Bayswater	5	book now	£198	£215
Full Schedule: See all 169 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: column width

by - trainer Mark gold contributer [147 posts] (2008 May 6 Tue, 14:27) Reply

Hi Pat

Thank you for asking this question, and sorry we haven't got back to you before now

this question has been asked before so your not alone in this, what you will have to do is highlight all the columns you want to auto fit the text, then when you have done this move your mouse to the separator of any of the columns i.e. between B and C.

You should have a double headed arrow at that point just double click your mouse and that should do the trick

Please let me know if there is anything else

If this has answered your query then I would request you to please mark the question as Resolved!! If not and you have a specific question related to this then please click Reply or post it as a new question and we should be able to answer that!!

Many Thanks

Mark East
MOUS Master Instructor

Mark@microsofttraining.net