[mso] Re: Shortcut to Merge Cells

"Center across selection" is ok in some instances.  However, "center" is not 
always what you want, and merged cells allow multi-rows, word-wrap, etc.

Copying areas containing merged cells is not a problem - the merged cells 
copy quite happily with the rest.  Pasting OVER merged cells quite correctly 
gives errors if you would otherwise break the merge.

There are disadvantages to merged cells (row auto-height and 
paste/special/formula to name a couple), but normal copy/paste is not a 
problem.

Regards, Dave S

----- Original Message ----- 
From: "Wilson Baptista Junior" <wilsonbaptista@xxxxxxxxxxxx>
To: <mso@xxxxxxxxxxxxx>
Sent: Sunday, September 17, 2006 8:42 AM
Subject: [mso] Re: Shortcut to Merge Cells


> Hi Terry,
> I would advise you to *never, never*  use merged cells in Excel.
> It's better to use the Format-->Cells-->Alignment-->"Center across 
> selection" option instead.
> Merged cells tend to cause problems whenever you have to copy a selection 
> containing them to another place.
> Wilson
>
> At 19:18 16/9/2006,TerryLBradshaw@xxxxxxx wrote:
>>Is there a keyboard shortcut in Excel I can use to merge  cells?
>>
>>Thanks in advance,
>>
>>Terry
>
>
> *************************************************************
> You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
> MicrosoftOffice@xxxxxxxxxxxxxxxx
>
> To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>
> To Unsubscribe from this group, visit the group's homepage and use the 
> dropdown menu at the top.  This will allow you to unsubscribe your email 
> address or change your email settings to digest or vacation (no mail).
> http://www.freelists.org/webpage/mso
>
> To be able to use the files section for sharing files with the group, send 
> a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an 
> invitation with instructions.  Once you are a member of the files group, 
> you can go here to upload/download files:
> http://www.smartgroups.com/vault/msofiles
>
> If you are using Outlook and you see a lot of unnecessary code in your 
> email messages, read these instructions that explain why and how to fix 
> it:
> http://personal-computer-tutor.com/abc3/v28/greg28.htm
> ************************************************************* 

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: