training microsoft excel

training microsoft excel - Merging cells

Resolved · Low Priority · Version Standard

Merging cells

Natascha has attended:
Excel Intermediate course
Powerpoint Advanced course

by - delegate Natascha [4 posts] (2007 Sep 20 Thu, 09:55) Reply

How can I merge two cells together and then unmerge them??
Please?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	3	book now	£475	£495
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	4	book now	£499	£530
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	8	book now	£345	£425
2003	2009 Jan 22 Thu + 23 Fri	Southwark	5	book now	£450	£485
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	6	book now	£450	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	7	book now	£450	£475
Full Schedule: See all 34 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Merging cells

by - trainer Anthony gold contributer [113 posts] (2007 Sep 25 Tue, 16:29) Edited on 2007 Sep 25 Tue, 16:30 Reply

Hi Natasha. Select the cells you want to merge and then chose Format - Cells - the Alignment tab and tick the merge cells box.

Alternatively use the icon on your formatting toolbar, it looks like an "a" with two arrows on either side. Clicking the icon again (or unticking the merge cells tick box) splits the cells back in two.

Hope this helps,

Anthony