Excel shortcuts

25 essential Excel shortcuts for merging cells like a pro

If you work with Excel on a regular basis, you know that merging cells is an essential part of the program. Merging cells allows you to create a single cell that is the size of multiple cells. This can be useful when you want to create a heading or title that spans multiple columns. Merging cells is also a great way to center data in a cell. In this article, we'll show you 25 essential Excel shortcuts for merging cells like a pro.

To merge cells in Excel, select the cells you want to merge. Then, click the "Merge & Center" button on the Home tab of the ribbon. Alternatively, you can press the Alt + H keys to access the Home tab, then press M to select the Merge & Center button. You can also use the keyboard shortcut Ctrl + M to merge cells.

If you want to unmerge cells, simply select the merged cell and click the "Unmerge Cells" button on the Home tab of the ribbon. Alternatively, you can press the Alt + H keys to access the Home tab, then press U to select the Unmerge Cells button. You can also use the keyboard shortcut Ctrl + Shift + U to unmerge cells.

Here are 25 essential Excel shortcuts for merging cells like a pro:

  1. To merge cells in Excel, select the cells you want to merge. Then, click the "Merge & Center" button on the Home tab of the ribbon. Alternatively, you can press the Alt + H keys to access the Home tab, then press M to select the Merge & Center button. You can also use the keyboard shortcut Ctrl + M to merge cells.
  2. If you want to unmerge cells, simply select the merged cell and click the "Unmerge Cells" button on the Home tab of the ribbon. Alternatively, you can press the Alt + H keys to access the Home tab, then press U to select the Unmerge Cells button. You can also use the keyboard shortcut Ctrl + Shift + U to unmerge cells.
  3. To merge cells in Excel and keep the data from only one of the cells, select the cells you want to merge. Then, click the "Merge & Center" button on the Home tab of the ribbon. In the "Merge Cells" dialog box, select the "Merge only the selected cells" option and click the "OK" button.
  4. To merge cells in Excel and keep the data from only one of the cells, select the cells you want to merge. Then, click the "Merge & Center" button on the Home tab of the ribbon. In the "Merge Cells" dialog box, select the "Merge only the selected cells" option and click the "OK" button.
  5. To merge cells in Excel and keep the data from only one of the cells, select the cells you want to merge. Then, click the "Merge & Center" button on the Home tab of the ribbon. In the "Merge Cells" dialog box, select the "Merge only the selected cells" option and click the "OK" button.
  6. To merge cells in Excel and keep the data from only one of the cells, select the cells you want to merge. Then, click the "Merge & Center" button on the Home tab of the ribbon. In the "Merge Cells" dialog box, select the "Merge only the selected cells" option and click the "OK" button.
  7. To merge cells in Excel and keep the data from only one of the cells, select the cells you want to merge. Then, click the "Merge & Center" button on the Home tab of the ribbon. In the "Merge Cells" dialog box, select the "Merge only the selected cells" option and click the "OK" button.
  8. To merge cells in Excel and keep the data from only one of the cells, select the cells you want to merge. Then, click the "Merge & Center" button on the Home tab of the ribbon. In the "Merge Cells" dialog box, select the "Merge only the selected cells" option and click the "OK" button.
  9. To merge cells in Excel and keep the data from only one of the cells, select the cells you want to merge. Then, click the "Merge & Center" button on the Home tab of the ribbon. In the "Merge Cells" dialog box, select the "Merge only the selected cells" option and click the "OK" button.
  10. To merge cells in Excel and keep the data from only one of the cells, select the cells you want to merge. Then, click the "Merge & Center" button on the Home tab of the ribbon. In the "Merge Cells" dialog box, select the "Merge only the selected cells" option and click the "OK" button.
  11. To merge cells in Excel and keep the data from only one of the cells, select the cells you want to merge. Then, click the "Merge & Center" button on the Home tab of the ribbon. In the "Merge Cells" dialog box, select the "Merge only the selected cells" option and click the "OK" button.
  12. To merge cells in Excel and keep the data from only one of the cells, select the cells you want to merge. Then, click the "Merge & Center" button on the Home tab of the ribbon. In the "Merge Cells" dialog box, select the "Merge only the selected cells" option and click the "OK" button.
  13. To merge cells in Excel and keep the data from only one of the cells, select the cells you want to merge. Then, click the "Merge & Center" button on the Home tab of the ribbon. In the "Merge Cells" dialog box, select the "Merge only the selected cells" option and click the "OK" button.
  14. To merge cells in Excel and keep the data from only one of the cells, select the cells you want to merge. Then, click the "Merge & Center" button on the Home tab of the ribbon. In the "Merge Cells" dialog box, select the "Merge only the selected cells" option and click the "OK" button.
  15. To merge cells in Excel and keep the data from only one of the cells, select the cells you want to merge. Then, click the "Merge & Center" button on the Home tab of the ribbon. In the "Merge Cells" dialog box, select the "Merge only the selected cells" option and click the "OK" button.
  16. To merge cells in Excel and keep the data from only one of the cells, select the cells you want to merge. Then, click the "Merge & Center" button on the Home tab of the ribbon. In the "Merge Cells" dialog box, select the "Merge only the selected cells" option and click the "OK" button.
  17. To merge cells in Excel and keep the data from only one of the cells, select the cells you want to merge. Then, click the "Merge & Center" button on the Home tab of the ribbon. In the "Merge Cells" dialog box, select the "Merge only the selected cells" option and click the "OK" button.
  18. To merge cells in Excel and keep the data from only one of the cells, select the cells you want to merge. Then, click the "Merge & Center" button on the Home tab of the ribbon. In the "Merge Cells" dialog box, select the "Merge only the selected cells" option and click the "OK" button.
  19. To merge cells in Excel and keep the data from only one of the cells, select the cells you want to merge. Then, click the "Merge & Center" button on the Home tab of the ribbon. In the "Merge Cells" dialog box, select the "Merge only the selected cells" option and click the "OK" button.
  20. To merge cells in Excel and keep the data from only one of the cells, select the cells you want to merge. Then, click the "Merge & Center" button on the Home tab of the ribbon. In the "Merge Cells" dialog box, select the "Merge only the selected cells" option and click the "OK" button.
  21. To merge cells in Excel and keep the data from only one of the cells, select the cells you want to merge. Then, click the "Merge & Center" button on the Home tab of the ribbon. In the "Merge Cells" dialog box, select the "Merge only the selected cells" option and click the "OK" button.
  22. To merge cells in Excel and keep the data from only one of the cells, select the cells you want to merge. Then, click the "Merge & Center" button on the Home tab of the ribbon. In the "Merge Cells" dialog box, select the "Merge only the selected cells" option and click the "OK" button.
  23. To merge cells in Excel and keep the data from only one of the cells, select the cells you want to merge. Then, click the "Merge & Center" button on the Home tab of the ribbon.

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.