Jeremy- Highlight the merged cells. Go to Format>Cells and click on the alignment tab. Unclick the box "Merge Cells". THat's all there is to it. Parker Renaud "All who wander are not lost." prenaud@xxxxxxxxxxxxxxxxxx -----Original Message----- From: Jeremy Naylor [mailto:jeremy.naylor@xxxxxxxx] Sent: Wednesday, August 14, 2002 5:44 AM To: mso@xxxxxxxxxxxxx Subject: [mso] Unmerging cells in Excel Hey guys, How do you unmerge cells in Excel please? By the way - don't worry about my sum formula problem anymore - I've decided not to do that. :) Thanks, Jeremy Naylor. p: +64 21 184 7056. e: jeremy.naylor@xxxxxxxxx w: http://www.r2.co.nz/~jeremy. w: http://e-living.wellington.net.nz. This e-mail message may be confidential and contain personally and/or commercially sensitive information. Only the intended recipient[s] may access or use it. If you are not the intended recipient[s] please delete this e-mail message and notify us promptly. I use virus scanning software but exclude all liability for viruses or similar in this email message or any attachment. I support OSS in NZ - see www.openz.org. ************************************************************* 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, send an email to mso-request@xxxxxxxxxxxxx?Subject=unsubscribe Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //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 ************************************************************* ************************************************************* 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, send an email to mso-request@xxxxxxxxxxxxx?Subject=unsubscribe Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //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 *************************************************************