Microsoft Office Tutorials and References
In Depth Information
Unmerging all merged cells
Figure 13-3: Finding all merged cells in a worksheet.
Unmerging all merged cells
Here’s a quick way to unmerge all merged cells in a worksheet:
1. Select all cells in the worksheet.
A quick way to do so is to click the triangle at the intersection of the row headers and column
2. Click the Home tab.
3. If the Merge & Center command is highlighted, click it.
In Step 3, if the Merge & Center command isn’t highlighted, there are no merged cells. If
you click the command when all cells are selected, all 17,179,869,184 cells in the
worksheet will be merged.
Search JabSto ::

Custom Search