How to unmerge merged cells

Method to cancel merged cells: 1. Select the cell and right-click; 2. In the pop-up options, select the Format Cells option; 3. Switch to the Alignment tab and uncheck it Merge cells option, click OK.

The operating environment of this article: windows10 system, microsoft office excel 2010, thinkpad t480 computer.

For example, we want to cancel the merged cells of the worksheet in the picture below.

Click to select the merged cells you want to cancel, right-click the mouse, and select the [Format Cells] option in the pop-up menu options.

As shown below, through the previous step, the [Format Cells] dialog box pops up in the system.

In the [Format Cells] dialog box that pops up in the system through the previous step, click to select the [Alignment] function tab and uncheck the box in the dialog box The [Merge Cells] option, click the [OK] button when finished.

Return to the worksheet, and through the above steps, the selected merged cells will be cancelled. The result is as shown below:

Free video tutorial sharing: php video tutorial

The above is the detailed content of How to unmerge merged cells. For more information, please follow other related articles on the PHP Chinese website!