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
headers.
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.
Note
Search JabSto ::




Custom Search