Plz Help in Merging cells!

[Maria]

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

 

[kassie]

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.