unmerge all cells in excel spreadsheet

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

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Open in new window

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

Unmerge All Cells In A Workbook:

Sub Unmerge()
    Dim wSheet As Worksheet
    For Each wSheet In Worksheets
    Next wSheet  
End Sub
Venn TorrenceData Analyst
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