How can I paste into merged cells?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris Mitchell - 09 Jan 2008 06:21 GMT

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?

Reply to this Message

Roger Govier - 09 Jan 2008 07:47 GMT

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.

Signature

Regards
Roger Govier

> 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.
[quoted text clipped - 5 lines]
>
> How can I get around this?

Reply to this Message

CLR - 09 Jan 2008 15:26 GMT

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

> 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.
[quoted text clipped - 5 lines]
>
> How can I get around this?

Reply to this Message