training microsoft excel - merging cells
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
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

training microsoft excel - Merging cells

resolvedResolved · Low Priority · Version Standard

replyReply 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

replyReply 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 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


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard