Cannot copy the merge cells into another sheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pai - 02 Feb 2008 10:26 GMT

hi

I m a new user of excel. Recently i have working on excel.When this
problem occurs.

My problem is that I have a data in one sheet. Which has cities wise
data.And some cells are merge. I have to copy the one city (NEW DELHI)
data into another sheet.
I make the autofilter in the sheet and find the city i:e NEW DELHI

Now the problem started with me is that when i copy the filter data an

ERROR MESSAGE DISPLAY:- CANNOT CHANGE THE PART OF A MERGE CELL.
Is it possible to copy and then paste into another sheet this type of
data.Without unmerge the cell. Because it is not possible to me first
i unmerge the data and then copy& paste because it is huge data apprm.
1025columns about 120 are merged cell

ANY HELP WILL BE APPRECIATE
THANKS
HARDEEP (PAI)

Reply to this Message

Barbara Wiseman - 02 Feb 2008 22:31 GMT

You could unmerge all the cells which are merged and ASAP utilities has a
quick way of doing that.

http://www.asap-utilities.com/index.php

> hi
>
[quoted text clipped - 17 lines]
> THANKS
> HARDEEP (PAI)

Reply to this Message

Gord Dibben - 02 Feb 2008 22:47 GMT

Excel has a quick way also.

CTRL + a(twice in 2003) to select all cells.

Format>Cells>Alignment. Uncheck "merge cells".

But did you actually mean to say that merged cells are causing a problem and OP
should do away with them<vbg>

Gord Dibben MS Excel MVP

>You could unmerge all the cells which are merged and ASAP utilities has a
>quick way of doing that.
[quoted text clipped - 22 lines]
>> THANKS
>> HARDEEP (PAI)

Reply to this Message

DanRoss - 03 Feb 2008 04:33 GMT

You might play with - Right Click / Past Special / Values. . . onto your
second sheet.

> hi
>
[quoted text clipped - 17 lines]
> THANKS
> HARDEEP (PAI)

Reply to this Message

DanRoss - 04 Feb 2008 01:47 GMT

-- ANSWER -- DO NOT COPY THE SHEET.

Activate a Cell on the Page - click "CTL+A" which will select all the data
on the sheet you have filtered.
Then Paste the Contents into the new sheet.

--------------------------

Dear Sir,

thanks for the reply

But i cannot copy the data. When i select the sheet than i copy the
cells it cannot copy the cells. Then how can i do paste special
without copy the cells.

Thanks

Hardeep kanwar

> hi
>
[quoted text clipped - 17 lines]
> THANKS
> HARDEEP (PAI)

Reply to this Message