Duke,
What if you want the text to wrap?

"Duke Carey" wrote:

You don't need to merge the cells if the text is too long for a single cell.
Simply use the left alignement and allow the text toextend beyond the cell's
right border. If you want it right-aligned then move the text to the
right-most cell and use the right align button/format

BTW, though I didn't state as emphatically as JE, I agree that Merge should
be HARD to do so that it's used rarely, while Center Across selection should
be part of the standard toolbar.


"Michele" wrote:

Duke and JE: Thanks very much and for responding so quickly. I'll practice
using the "center across" until the advantages become clearer in my brain.
BTW, what if I don't want to CENTER items? What if I want to still have a
left or right alignment? How is that overcome? Thanks again.

"Duke Carey" wrote:

Merging cells interferes with selecting a range - to apply formatting, for
instance.

Simple example:
If B3 & C3 are merged and you want to select A1:B4, you end up with A1:C4

I *think* in older versions of Excel it also hindered the column autofit
feature activated by double clicking the border between column headers.

"Michele" wrote:

When is it more appropriate to "center across" selection rather than "merge"
cells? What are the advantages/disadvantages to these two types of cell
alignment? Thanks very much.