Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » training microsoft excel - Merging cells

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

training microsoft excel - Merging cells

Resolved · Low Priority · Version Standard

Reply Thu 20 Sep 2007, 09:55Delegate Natascha said...

Natascha has attended:
Excel Intermediate course
Powerpoint Intermediate Advanced course

Merging cells

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

For upcoming training course dates see: Pricing & availability

Reply Tue 25 Sep 2007, 16:29 Edited on Tue 25 Sep 2007, 16:30Trainer Anthony said...

RE: Merging cells

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

Excel articles

· Compare Different MS Excel Training Methods
· A Beginners Guide To Formulas In Excel
· How To Use Freeze Panes In Excel 2007
· Charting Another Dimension With Excel
· How to Create Better Excel Spreadsheets: Part Two

Excel tip:

Turn Function tooltips on and off

Excel 2002 (XP) and Excel 2003 have the Function tooltips facility. When you type in a function name followed by a bracket, for example, =IF(, a yellow box appears beside the function name and lists the function's arguments. This is very useful when you can't quite remember the order of a function's arguments or what the arguments actually are!

However, Function tooltips can become annoying. To turn them off, choose Tools|Options. and select the General tab. Then, untick the Function tooltips box and choose OK.

View all Excel hints and tips