Feature Summary
The merge and split feature is used to combine multiple cells into one cell, or to split a merged cell into multiple cells, facilitating sheet layout adjustment.
Feature Description
| Feature Dimension | Description |
|---|---|
| Membership Restriction | No membership restriction |
| Version Restriction | No version restriction |
Steps
Merge Cells
Feature Entry
「Start」tab → 「Merge & Center」dropdown arrow
- Select multiple cells to be merged
- Click the dropdown arrow below the 「Merge & Center」 in the Start tab to quickly merge cells
- Click the arrow below the button to choose a merge method:
- Merge & Center: Content is centered after merging
- Merge Content: Original alignment is kept after merging
- Merge by Row: The merged cell will only keep the value in the upper-left corner, discarding other values
- Merge Identical Cells: Merge cells with identical content together
Split Cells
Feature Entry
「Start」tab → Dropdown arrow below the 「Merge & Center」button → 「Unmerge Cells」option
- Select the merged cell
- Click the dropdown arrow below the Merge & Center button in the Start tab
- Click the 「Unmerge Cells」 button, or the 「Split and Fill Content」 button
FAQ
Q1: Will data be lost after merging cells?
- Solution: Only the data in the upper-left cell is kept after merging; data in other cells will be lost. It is recommended to back up before merging.
Q2: Does merging cells affect sorting and filtering?
- Solution: Merged cells will affect sorting and filtering functions. It is recommended to avoid using merged cells in areas where sorting and filtering are needed.
Notes
- Merging cells only keeps the data in the upper-left cell
- Merged cells can be split and restored
- Merged cells will affect data processing functions
- The merge/unmerge option can also be found in the right-click menu when cells or a cell range are selected