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