Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Setup / August 2007

Tip: Looking for answers? Try searching our database.

Plz Help in Merging cells!

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Maria - 30 Aug 2007 08:04 GMT
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 - 30 Aug 2007 19:46 GMT
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.
Signature

Hth

Kassie Kasselman
Change xxx to hotmail

> Hi,
>
[quoted text clipped - 10 lines]
> Thanks,
> Maria

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.