top of page
  • Excel Master

What Are The Best Shortcut Keys for Merging Cells in Excel?

Here are some of the best shortcut keys for merging cells in Excel:

  1. Merge & Center: Alt + H + M + C This shortcut key will merge the selected cells and center the contents of the merged cell.

  2. Merge Across: Alt + H + M + A This shortcut key will merge the selected cells across the rows, but not the columns. It is useful when you want to merge cells in a row without affecting the other rows.

  3. Merge Cells: Alt + H + M + M This shortcut key will merge the selected cells without centering the content or affecting the other cells.

  4. Unmerge Cells: Alt + H + M + U This shortcut key will unmerge any merged cells in the selected range, separating the contents back into individual cells.

By using these shortcut keys, you can quickly and efficiently merge and unmerge cells in Excel without having to navigate through multiple menus or using the mouse.

4 views0 comments

Recent Posts

See All

How to Use the Autofit Column Width Shortcut in Excel

To use the Autofit Column Width shortcut in Excel, follow these steps: Open Microsoft Excel and navigate to the worksheet containing the columns you want to autofit. Select the column or columns that

How to Add Axis Labels in Excel

To add axis labels in Excel, follow these steps: Open Microsoft Excel and open the worksheet containing the chart you want to edit. Click on the chart to select it. This will activate the Chart Tools

Comments


bottom of page