unmerge all cells in excel spreadsheet

jamesmetcalf74
jamesmetcalf74 used Ask the Experts™
on
i have a large spreadsheet that has merged cells all over the place.... is there  a way to unmerge all cells
excel 2013
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
ActiveSheet.Cells.UnMerge

Open in new window

Press Ctrl + A to select all cells in the sheet and then click on merge & center.
Commented:
Hi jamesmetcalf74,

Unmerge All Cells In A Workbook:

Sub Unmerge()
    Dim wSheet As Worksheet
     
    For Each wSheet In Worksheets
        wsheet.cells.unmerge
    Next wSheet  
     
End Sub
Venn TorrenceData Analyst
Commented:
You can easily merge and unmerge cells from “Merge & Center”. But if you need to more explanation you can visit here: http://www.wikihow.com/Unmerge-Cells-in-Excel

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial