training ms excel advanced - Cells

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

Resolved · Low Priority · Version Standard

Cells

Peter has attended:
Excel Introduction course

by - delegate Peter [1 post] (2007 Aug 1 Wed, 12:57) Reply

how do i merge and align cells

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	6	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: cells

by - trainer Tracy platinum contributer [586 posts] (2007 Aug 1 Wed, 15:16) Reply

If you highlight across the cells you wish to merge you can use the Format menu, go to the alignment tab and tick the box towards the bottom of the dialog box which says merge. Once merged you can use the other options on that box to centre the text horizontally across the cells.

There is also a button on your formatting toolbar which merges and centres. It looks like a lower case 'a' with two arrows pointing away from the a. Like this
<--a--> if you find it that does the same job!

regards

Tracy

· How to Create Better Excel Spreadsheets: Part One
· Take the Anxiety out of Domestic Finances with Microsoft Excel
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· Microsoft Excel's Best Kept Secret
· Prepare for your MOS Certification with MS Excel Courses