Excel shortcuts

The Top 10 Excel Keyboard Shortcuts for Merging Cells

If you work with Excel on a regular basis, you know that there are certain tasks that you perform over and over again. Merging cells is one of those tasks. If you find yourself constantly merging cells in Excel, you can save yourself some time by using a keyboard shortcut. In this article, we'll show you the top 10 Excel keyboard shortcuts for merging cells.

1. Ctrl + M

This shortcut will merge the selected cells into one cell. If you have a range of cells that you want to merge, simply select those cells and press Ctrl + M. Excel will automatically merge the cells and center the text.

2. Ctrl + Shift + M

This shortcut will merge the selected cells, but it will also keep the text left-aligned. This is useful if you want to merge cells but you don't want the text to be centered.

3. Ctrl + D

This shortcut will merge the selected cells and center the text, but it will also apply the Borders and Shading dialog box to the merged cell. This is a quick way to apply borders and shading to a merged cell without having to open the Borders and Shading dialog box.

4. Ctrl + Shift + D

This shortcut will merge the selected cells and keep the text left-aligned, but it will also apply the Borders and Shading dialog box to the merged cell. This is a quick way to apply borders and shading to a merged cell without having to open the Borders and Shading dialog box.

5. Ctrl + J

This shortcut will merge the selected cells and center the text, but it will also apply the Borders and Shading dialog box to the merged cell. This is a quick way to apply borders and shading to a merged cell without having to open the Borders and Shading dialog box.

6. Ctrl + Shift + J

This shortcut will merge the selected cells and keep the text left-aligned, but it will also apply the Borders and Shading dialog box to the merged cell. This is a quick way to apply borders and shading to a merged cell without having to open the Borders and Shading dialog box.

7. Ctrl + K

This shortcut will merge the selected cells and center the text, but it will also apply the Borders and Shading dialog box to the merged cell. This is a quick way to apply borders and shading to a merged cell without having to open the Borders and Shading dialog box.

8. Ctrl + Shift + K

This shortcut will merge the selected cells and keep the text left-aligned, but it will also apply the Borders and Shading dialog box to the merged cell. This is a quick way to apply borders and shading to a merged cell without having to open the Borders and Shading dialog box.

9. Ctrl + L

This shortcut will merge the selected cells and center the text, but it will also apply the Borders and Shading dialog box to the merged cell. This is a quick way to apply borders and shading to a merged cell without having to open the Borders and Shading dialog box.

10. Ctrl + Shift + L

This shortcut will merge the selected cells and keep the text left-aligned, but it will also apply the Borders and Shading dialog box to the merged cell. This is a quick way to apply borders and shading to a merged cell without having to open the Borders and Shading dialog box.

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.