I saw this on Twitter yesterday: Wanted "Break Apart all merged cells in entire spreadsheet" button

If you've done much work in Excel, you've probably encountered problems that are the result of merged cells on a worksheet. Merging cells can seem like a good idea at the time, but can interfere with sorting and filtering, and other things that make an Excel workbook useful.

I don't know what version of Excel that tweeter is using, but there's an Unmerge Cells command on the Excel 2007 Ribbon, and you could add one to the toolbar in earlier versions of Excel.

Unmerge All Cells on All Worksheets

To get rid of all the merged cells in an Excel 2007 workbook, follow these steps:

Make a backup copy of the workbook, and store it somewhere safe. Right-click one of the sheet tabs, and click Select All Sheets On the active sheet, click the

Continue reading Unmerge Excel Cells