Pasting into Merged Cells

  • Thread starter Thread starter Squid
  • Start date Start date
S

Squid

I know you cannot paste text into a merged cell. But what
is the reason why Excel is not designed to allow this?

Thanks
Mike
 
Hi Mike
that's the reason why most people recommend NOT to use merged cells.
The small benefits they have (layouting) are not worth the MANY
drawbacks they have.
So I'd recommend: Try to avoid merged cells :-)
 
Yeah, but unfortunately when you are trying to recreate a
layout of printed form you are forced to use merged cells.
 
Hi Squid
Yeah, but unfortunately when you are trying to recreate a
layout of printed form you are forced to use merged cells.
Click to expand...

Have you try

Center across selection on the alignment tab of the
Format Cells dialog (Format>Cells in the menubar)
 
Back
Top