Cannot copy the merge cells

  • Thread starter Thread starter pai_kanwar via OfficeKB.com
  • Start date Start date
P

pai_kanwar via OfficeKB.com

Dear sir,

when I copying the sheet the message shown ( cannot
change the part of a merge cell)
Is there any way without unmerged the cell.
Because I have 253 out of 1024 merge, cell to copy to another sheet it is not
possible for me to first unmerge the cells and than merged one by one

I have post my problem in so many sites but i cannot find any specific
solution.

How can I resolve it?

Thanks and help me to resolve this problem

Hardeep kanwar
 
Hi,

You are probably not getting an answer because something is missing in your
question. There is no problem copying a range, some cells of which are
merged and some cells of which are not merged.

The problem arises if there are merged cells in the destination sheet/range.
Also, there may be a version issue, so tell us what version of Excel you are
using.

Cheers,
Shane
 
Dear Sir,

thanks for showing the interest in my problem

Excel2002 version

thanks
hardeep

Shane said:
Hi,

You are probably not getting an answer because something is missing in your
question. There is no problem copying a range, some cells of which are
merged and some cells of which are not merged.

The problem arises if there are merged cells in the destination sheet/range.
Also, there may be a version issue, so tell us what version of Excel you are
using.

Cheers,
Shane
Dear sir,
Click to expand...
[quoted text clipped - 13 lines]
Hardeep kanwar
Click to expand...
Click to expand...
 
Dear sir,

I have not recevied any reply from your side

Thanks
Hardeep Kanwar(Pai_kanwar)


pai_kanwar said:
Dear Sir,

thanks for showing the interest in my problem

Excel2002 version

thanks
hardeep
Hi,
Click to expand...
[quoted text clipped - 14 lines]
Click to expand...
 
Back
Top