Common questions about merge and split cells usually focus on retained data, sorting and filtering impact, and where to find the command. This FAQ covers 3 common answers.
FAQ
Will data be lost after I merge cells?
- Check whether multiple cells in the selected range already contain content.
- Keep in mind that only the upper-left cell value is usually retained after merging.
- If you need to keep all original content, copy or back up the data before merging.
Does merging cells affect sorting and filtering?
- Merged cells can affect sorting, filtering, and other data-processing actions.
- If the range will later be sorted, filtered, or used for calculations, avoid merging cells in the main data area.
- Unmerge the cells before running those data operations.
Where else can I find merge or unmerge commands besides the top menu bar?
- Select the target cell or cell range first.
- Right-click to open the shortcut menu.
- Find the merge or unmerge command in the shortcut menu and apply it.
Glossary
| Term | Definition |
|---|---|
| Merge and Center | Combines multiple cells into one cell and centers the content in the merged area. |
| Unmerge Cells | Restores a merged cell back into separate individual cells. |
| Merge by Row | Merges the selected range by row and usually keeps only the upper-left value in each merged result. |