Excel shortcuts

10 Shortcuts for Merging and Unmerging Cells in Excel

If you work with data in Microsoft Excel, you'll inevitably need to merge and unmerge cells. Merging cells combines two or more cells into a single cell, while unmerging cells splits a single cell into multiple cells. These operations can be performed using the mouse and menu commands, but there are also keyboard shortcuts that can save you time.

To merge cells in Excel, select the cells you want to merge, then press Ctrl+M (or Command+M on a Mac). To unmerge cells, select the merged cell and press Ctrl+U (or Command+U on a Mac).

1. Merge Cells

The first shortcut is for merging cells. To use it, select the cells you want to merge and press Ctrl+M (or Command+M on a Mac).

This shortcut will merge the selected cells into a single cell. The contents of the cells will be combined into a single cell, with the contents of the first cell appearing first, followed by the contents of the second cell, and so on.

If the cells you're merging contain formulas, the formulas will be combined into a single formula in the merged cell. However, if the cells you're merging contain values, the values will be concatenated, with the value from the first cell appearing first, followed by the value from the second cell, and so on.

2. Unmerge Cells

The second shortcut is for unmerging cells. To use it, select the merged cell and press Ctrl+U (or Command+U on a Mac).

This shortcut will unmerge the selected cell, splitting it into the number of cells that were originally merged to create it. The contents of the cell will be split evenly between the new cells, with the first cell getting the first part of the contents, the second cell getting the second part, and so on.

If the merged cell contains a formula, the formula will be split into multiple formulas, with each new formula being placed in a separate cell. However, if the merged cell contains values, the values will be split evenly between the new cells.

3. Merge Across

The third shortcut is for merging cells across multiple columns. To use it, select the cells you want to merge and press Ctrl+Shift+M (or Command+Shift+M on a Mac).

This shortcut will merge the selected cells into a single cell, with the contents of the cells being combined into a single cell, with the contents of the first cell appearing first, followed by the contents of the second cell, and so on.

If the cells you're merging contain formulas, the formulas will be combined into a single formula in the merged cell. However, if the cells you're merging contain values, the values will be concatenated, with the value from the first cell appearing first, followed by the value from the second cell, and so on.

4. Unmerge Across

The fourth shortcut is for unmerging cells across multiple columns. To use it, select the merged cell and press Ctrl+Shift+U (or Command+Shift+U on a Mac).

This shortcut will unmerge the selected cell, splitting it into the number of cells that were originally merged to create it. The contents of the cell will be split evenly between the new cells, with the first cell getting the first part of the contents, the second cell getting the second part, and so on.

If the merged cell contains a formula, the formula will be split into multiple formulas, with each new formula being placed in a separate cell. However, if the merged cell contains values, the values will be split evenly between the new cells.

5. Merge and Center

The fifth shortcut is for merging and centering cells. To use it, select the cells you want to merge and press Ctrl+E (or Command+E on a Mac).

This shortcut will merge the selected cells into a single cell and center the contents of the cell. The contents of the cells will be combined into a single cell, with the contents of the first cell appearing first, followed by the contents of the second cell, and so on.

If the cells you're merging contain formulas, the formulas will be combined into a single formula in the merged cell. However, if the cells you're merging contain values, the values will be concatenated, with the value from the first cell appearing first, followed by the value from the second cell, and so on.

6. Unmerge and Center

The sixth shortcut is for unmerging and centering cells. To use it, select the merged cell and press Ctrl+Shift+E (or Command+Shift+E on a Mac).

This shortcut will unmerge the selected cell and center the contents of the cells that are created. The contents of the cell will be split evenly between the new cells, with the first cell getting the first part of the contents, the second cell getting the second part, and so on.

If the merged cell contains a formula, the formula will be split into multiple formulas, with each new formula being placed in a separate cell. However, if the merged cell contains values, the values will be split evenly between the new cells.

7. Merge and Center Across

The seventh shortcut is for merging and centering cells across multiple columns. To use it, select the cells you want to merge and press Ctrl+Shift+E (or Command+Shift+E on a Mac).

This shortcut will merge the selected cells into a single cell and center the contents of the cell. The contents of the cells will be combined into a single cell, with the contents of the first cell appearing first, followed by the contents of the second cell, and so on.

If the cells you're merging contain formulas, the formulas will be combined into a single formula in the merged cell. However, if the cells you're merging contain values, the values will be concatenated, with the value from the first cell appearing first, followed by the value from the second cell, and so on.

8. Unmerge and Center Across

The eighth shortcut is for unmerging and centering cells across multiple columns. To use it, select the merged cell and press Ctrl+Shift+U (or Command+Shift+U on a Mac).

This shortcut will unmerge the selected cell and center the contents of the cells that are created. The contents of the cell will be split evenly between the new cells, with the first cell getting the first part of the contents, the second cell getting the second part, and so on.

If the merged cell contains a formula, the formula will be split into multiple formulas, with each new formula being placed in a separate cell. However, if the merged cell contains values, the values will be split evenly between the new cells.

9. Merge Cells Without Losing Data

The ninth shortcut is for merging cells without losing data. To use it, select the cells you want to merge and press Ctrl+Shift+M (or Command+Shift+M on a Mac).

This shortcut will merge the selected cells into a single cell, but the data in the cells will not be lost. The contents of the cells will be combined into a single cell, with the contents of the first cell appearing first, followed by the contents of the second cell, and so on.

If the cells you're merging contain formulas, the formulas will be combined into a single formula in the merged cell. However, if the cells you're merging contain values, the values will be concatenated, with the value from the first cell appearing first, followed by the value from the second cell, and so on.

10. Unmerge Cells Without Losing Data

The tenth shortcut is for unmerging cells without losing data. To use it, select the merged cell and press Ctrl+Shift+U (or Command+Shift+U on a Mac).

This shortcut will unmerge the selected cell, but the data in the cell will not be lost. The contents of the cell will be split evenly between the new cells, with the first cell getting the first part of the contents, the second cell getting the second part, and so on.

<

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.