How can I paste into merged cells?

[Chris Mitchell]

I have a spreadsheet that contains blocks of 9 rows, where the first 'cell'
in each row is made up of a number of merged cells.



I want to be able to copy and paste 9 single cell rows at a time from a
table in a Word document, in to the first 'cell' in 9 rows in my
spreadsheet, but Excel is unable to change part of a merged cell so won't
allow me to paste.



How can I get around this?

 

[Roger Govier]

Hi Chris

That is one of the many problems with merged cells.
Either Unmerge the cells and have a wider column A
or unmerge the cells>Select the cells again that were
merged>Format>Cells>Alignment>Center across selection.

 

[CLR]

If it's any help, you can copy and paste multiple cells into a Drawing Object
that can be superimposed over a merged-cell area.

Or, you can select your block of cells and use the CAMERA feature to produce
a likeness of the range which can be pasted over the Merged-cell block (note
it's dynamic and will change values as the real range values change)


Vaya con Dios,
Chuck, CABGx3