Hi,

While updating the contents on a huge excel sheet
(Original), first I entered the updates in a separate Excel sheet and tried
to copy the whole sheet into the original one. But when i pasted, the format
of the sheet completely changed and the already merged cells are not merged
now.

When i looked into Format - Cells , the check box for Merge cells is
disabled. can't understand the reason, do we have an option for enabling and
disabling Merge Cells.

Thanks,
Maria

Maria,

Do you have a specific reason why you want to merge cells, or is it really
just a matter of trying to centre text across a number of columns? If the
latter, then instead of merging, select the columns across which you want to
centre text, right click, select Format Cells, select the Alignment tab, and
change Horizontal alignment to Centre across selection.
--
Hth

Kassie Kasselman
Change xxx to hotmail


"Maria" wrote:

Hi,

While updating the contents on a huge excel sheet
(Original), first I entered the updates in a separate Excel sheet and tried
to copy the whole sheet into the original one. But when i pasted, the format
of the sheet completely changed and the already merged cells are not merged
now.

When i looked into Format - Cells , the check box for Merge cells is
disabled. can't understand the reason, do we have an option for enabling and
disabling Merge Cells.

Thanks,
Maria