if one exists I can't find it.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

Merging cells is one of the worst Excel features and should be avoided in
99.9% of the cases where it is used. It messes with formatting and selecting
ranges and adds next to nothing that can't be accomplished better by using
Format-Cells-Alignment and, under Horizontal Alignment, selecting Center
Across Selection.

Having said that, if you insist on merging cells, there's an icon for it on
the default Formatting toolbar. It looks like a little white box with an 'a'
and some arrows in it.

"drgb" wrote:

if one exists I can't find it.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

I agree that merging cells should try and be avoided but the other thing
you can do is set up a custom toolbar with merge and unmerge buttons.

The button with the A in the middle is merge and center but you can
also place buttons on there that merge cells, un-merge, and merge
across.

-Matt


--
qwopzxnm
------------------------------------------------------------------------
qwopzxnm's Profile: http://www.excelforum.com/member.php...o&userid=27557
View this thread: http://www.excelforum.com/showthread...hreadid=483481