Home >Topics >excel >How to unmerge merged cells

How to unmerge merged cells

王林
王林Original
2021-04-12 16:18:35124069browse

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.

How to unmerge merged cells

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.

How to unmerge merged cells

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.

How to unmerge merged cells

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

How to unmerge merged cells

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.

How to unmerge merged cells

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

How to unmerge merged cells

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn