Excel Hack

Merge cells in Excel shortcut

Cell merging is a commonly used feature to arrange the design of a sheet. It is Useful when creating list item names, etc. In Excel, cells can be merge and center, and unmerged using the access key without mouse clicking. We will show you how to merge multiple cells using the access key and how to merge cells horizontally.

Shortcuts for cell merging

Merge cells

Windows
Access Key: Alt+ H + M + M

Mac
None

Merge cells horizontally only

Windows
Access Key: Alt + H + M + A

Mac
None

Merge cells with access key

Use access key to merge cells. As an example, merge cells B1 and C1.

Total Time: 1 minute

Select a cell

Select a cell

Select the cell that will be the base of the merge.

Select the cells you want to merge

Select the cells you want to merge

Use Shift + (Right Arrow key) to select the cells to be merged.

Cells are merged

Cells are merged

Press Alt + H + M + M to merge cells.

Merge cells horizontally with access key

Merge cells horizontally using the access key. In this case, we will merge cells B1 to C6 horizontally.

Select cells

Select the cell that will be the base of the merge.

Select all cells to be merged

Use Shift + (Right Arrow key) and (Down Arrow key) to select the cells to be merged.

Cells are merged

Press Alt + H + M + A merges the selected cells horizontally only.

Articles related to Cell & Merge & Shortcut

Comments

Please send us your comments on this article.

0 comments
Inline Feedbacks
View all comments