Merge cells

Support

Hello,

Select a different account.

You have multiple accounts

Choose the account you want to sign in with.

Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web More...Less

Select the cells to be merged.
Choose Home and select Merge & Center.

To unmerge, select the merged cells, and select Excel merge and center icon Merge & Center again, or choose UnMerge cells button Unmerge Cells from the dropdown.

Important: When you merge cells that contain data, only the content in the upper left or left most cell is preserved.

To merge cells and keep the data, see Use the TEXTJOIN function.

Select the cells to be merged.
Choose Home and select Merge & Center.
If you don't see Merge & Center select Merge and then choose Merge & Center.

To unmerge, select the merged cells, and select Excel merge and center icon Merge & Center again, or choose UnMerge cells button Unmerge Cells from the dropdown.

Important: When you merge cells that contain data, only the content in the upper left or left most cell is preserved.

To merge cells and keep the data, see Use the TEXTJOIN function.