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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sharing workbooks limitations - Merged Cells 12
Best solution to merge multiple Outlook contacts easily 2
Copy/Paste into merged cells 2
Pasting into merged cells 1
Merge Cell Cut & Paste 1
Merging multiple columns into one column (dynamically) 1
Need to add text to all cells in excel or merge the text in two ce 1
How to merge 2 + contiguous cells without lossing data? 2

Back
Top