Go to the cell you want to unmerge. If you then hit Alt + O, then e, a dialog box will open up with tabs starting with Number format. Arrow to the next tab over, which is Alignment, and tab down to the Merge Cells options. Uncheck that box and you should be set to go. I'm sure there is a way to do it on the ribbon, but I'm leveraging that Microsoft left the menu commands intact from Excel 2003 and I really like accessing the dialog box I used in 2003.
-----Original Message----- From: Talk [mailto:talk-bounces+robin_van_lant=key....@lists.window-eyes.com] On Behalf Of Deborah Hill via Talk Sent: Sunday, April 19, 2015 6:21 AM To: talk@lists.window-eyes.com Subject: Excel; Unmerging One Cell Hi, Doesanyone know how to unmerge one cell in a worksheet? I must have copied the format from another sheet. Thanks for any help! Deborah _______________________________________________ Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Ai Squared. For membership options, visit http://lists.window-eyes.com/options.cgi/talk-window-eyes.com/robin_van_lant%40key.com. For subscription options, visit http://lists.window-eyes.com/listinfo.cgi/talk-window-eyes.com List archives can be found at http://lists.window-eyes.com/private.cgi/talk-window-eyes.com This communication may contain privileged and/or confidential information. It is intended solely for the use of the addressee. If you are not the intended recipient, you are strictly prohibited from disclosing, copying, distributing or using any of this information. If you received this communication in error, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. This communication may contain nonpublic personal information about consumers subject to the restrictions of the Gramm-Leach-Bliley Act. You may not directly or indirectly reuse or redisclose such information for any purpose other than to provide the services for which you are receiving the information. 127 Public Square, Cleveland, OH 44114 If you prefer not to receive future e-mail offers for products or services from Key send an e-mail to mailto:dnereque...@key.com with 'No Promotional E-mails' in the SUBJECT line. _______________________________________________ Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Ai Squared. For membership options, visit http://lists.window-eyes.com/options.cgi/talk-window-eyes.com/archive%40mail-archive.com. For subscription options, visit http://lists.window-eyes.com/listinfo.cgi/talk-window-eyes.com List archives can be found at http://lists.window-eyes.com/private.cgi/talk-window-eyes.com