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)

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



"pai" <(E-Mail Removed)> wrote in message
news:35576586-59ef-45c8-aaf2-(E-Mail Removed)...
> 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)

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

On Sat, 2 Feb 2008 22:31:17 -0000, "Barbara Wiseman"
<(E-Mail Removed)> wrote:

>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
>
>
>
>"pai" <(E-Mail Removed)> wrote in message
>news:35576586-59ef-45c8-aaf2-(E-Mail Removed)...
>> 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)
>

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




"pai" <(E-Mail Removed)> wrote in message
news:35576586-59ef-45c8-aaf2-(E-Mail Removed)...
> 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)

-- 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



"pai" <(E-Mail Removed)> wrote in message
news:35576586-59ef-45c8-aaf2-(E-Mail Removed)...
> 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)