Merge cells

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.

1. Select the cells to be merged.

2. Select Home and then choose   Merge & Center.
   From the keyboard, press ALT+H, M, C 

To unmerge, select the merged cells, and select  Merge & Center again, or choose   Unmerge Cells from the dropdown. 

1. Select the cells to be merged.

2. Choose Home and select   Merge & Center.

To unmerge, select the merged cells, and select  Merge & Center again, or choose   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.

1. Select the cells to be merged.

2. 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   Merge & Center again, or choose   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.