Excel shortcuts

22 essential Excel shortcuts for merging and centering data

If you work with data in Microsoft Excel, you know how important it is to be able to manipulate that data quickly and efficiently. That's why we've put together this list of 22 essential Excel shortcuts for merging and centering data. These shortcuts will help you save time and increase your productivity, whether you're working with a small data set or a large one.

1. To merge cells in Excel, select the cells you want to merge, then press Ctrl + M on your keyboard. This shortcut will merge the selected cells into one cell.

2. To center data in Excel, select the cells you want to center, then press Ctrl + E on your keyboard. This shortcut will center the data in the selected cells.

3. To merge and center data in Excel, select the cells you want to merge and center, then press Ctrl + M followed by Ctrl + E on your keyboard. This shortcut will merge the selected cells into one cell and center the data in that cell.

4. To unmerge cells in Excel, select the merged cell, then press Ctrl + U on your keyboard. This shortcut will unmerge the selected cell and return the data to its original state.

5. To merge and center cells across multiple columns in Excel, select the cells you want to merge and center, then press Ctrl + Shift + M followed by Ctrl + E on your keyboard. This shortcut will merge the selected cells into one cell, center the data in that cell, and apply the formatting to the other cells in the column.

6. To merge and center cells across multiple rows in Excel, select the cells you want to merge and center, then press Ctrl + M followed by Ctrl + Shift + E on your keyboard. This shortcut will merge the selected cells into one cell, center the data in that cell, and apply the formatting to the other cells in the row.

7. To merge and center cells across an entire worksheet in Excel, select the cells you want to merge and center, then press Ctrl + A followed by Ctrl + M followed by Ctrl + E on your keyboard. This shortcut will select all cells in the worksheet, merge the selected cells into one cell, and center the data in that cell.

8. To quickly merge and center cells in Excel, select the cells you want to merge and center, then press Alt + H, then M, then C on your keyboard. This shortcut will open the Merge and Center dialog box, which will allow you to merge and center the selected cells with just a few clicks.

9. To merge and center cells without losing data in Excel, select the cells you want to merge and center, then press Ctrl + Shift + M followed by Ctrl + E on your keyboard. This shortcut will merge the selected cells into one cell, center the data in that cell, and keep the data from the other cells intact.

10. To merge and center cells, and apply the formatting to the other cells in the column, select the cells you want to merge and center, then press Ctrl + Shift + M followed by Ctrl + E on your keyboard. This shortcut will merge the selected cells into one cell, center the data in that cell, and apply the formatting to the other cells in the column.

11. To merge and center cells, and apply the formatting to the other cells in the row, select the cells you want to merge and center, then press Ctrl + M followed by Ctrl + Shift + E on your keyboard. This shortcut will merge the selected cells into one cell, center the data in that cell, and apply the formatting to the other cells in the row.

12. To merge and center cells, and apply the formatting to all other cells in the worksheet, select the cells you want to merge and center, then press Ctrl + A followed by Ctrl + M followed by Ctrl + E on your keyboard. This shortcut will select all cells in the worksheet, merge the selected cells into one cell, center the data in that cell, and apply the formatting to all other cells in the worksheet.

13. To quickly merge and center cells, and apply the formatting to all other cells in the worksheet, select the cells you want to merge and center, then press Alt + H, then M, then C, then A on your keyboard. This shortcut will open the Merge and Center dialog box, which will allow you to merge and center the selected cells and apply the formatting to all other cells in the worksheet with just a few clicks.

14. To merge and center cells, without losing data, and apply the formatting to all other cells in the worksheet, select the cells you want to merge and center, then press Ctrl + Shift + M followed by Ctrl + E, then Ctrl + A on your keyboard. This shortcut will merge the selected cells into one cell, center the data in that cell, keep the data from the other cells intact, and apply the formatting to all other cells in the worksheet.

15. To quickly merge and center cells, without losing data, and apply the formatting to all other cells in the worksheet, select the cells you want to merge and center, then press Alt + H, then M, then C, then K, then A on your keyboard. This shortcut will open the Merge and Center dialog box, which will allow you to merge and center the selected cells, keep the data from the other cells intact, and apply the formatting to all other cells in the worksheet with just a few clicks.

16. To merge cells in Excel, and keep the data from the other cells, select the cells you want to merge, then press Ctrl + Shift + M on your keyboard. This shortcut will merge the selected cells into one cell, and keep the data from the other cells intact.

17. To quickly merge cells in Excel, and keep the data from the other cells, select the cells you want to merge, then press Alt + H, then M, then C, then K on your keyboard. This shortcut will open the Merge and Center dialog box, which will allow you to merge the selected cells and keep the data from the other cells intact with just a few clicks.

18. To merge and center cells in Excel, and keep the data from the other cells, select the cells you want to merge and center, then press Ctrl + Shift + M followed by Ctrl + E on your keyboard. This shortcut will merge the selected cells into one cell, center the data in that cell, and keep the data from the other cells intact.

19. To quickly merge and center cells in Excel, and keep the data from the other cells, select the cells you want to merge and center, then press Alt + H, then M, then C, then K, then E on your keyboard. This shortcut will open the Merge and Center dialog box, which will allow you to merge and center the selected cells and keep the data from the other cells intact with just a few clicks.

20. To merge and center cells across multiple columns in Excel, and keep the data from the other cells, select the cells you want to merge and center, then press Ctrl + Shift + M followed by Ctrl + E, then Ctrl + Shift + M on your keyboard. This shortcut will merge the selected cells into one cell, center the data in that cell, and keep the data from the other cells in the column intact.

21. To quickly merge and center cells across

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.