Shortcut To Merge Cells In Excel

Article byPradeep S
Edited byNannila Jai Ratna
Reviewed byDheeraj Vaidya, CFA, FRM

What Is Shortcut Key To Merge Cells In Excel?

Shortcut to merge cells in Excel is most widely used in data formatting for better layout or appearance. We can merge cells through “Controls” in the “Alignment” tab dialog box under the “Home” tab toolbar.

For example, consider the below table showing marks obtained in 3 different subjects in semester 1. We can see data in cell A1 is showing representing column A.

Shortcut to Merge cells Intro

Now, we need to merge cells A1 and B1 to organize the table effectively.

Shortcut to Merge cells Intro - Output

Simply select A1 and B1 and click on Merge & Center option to merge the cells.

Key Takeaways

  • Merge cells in Excel is used to merge two or more cells, rows or columns.
  • The shortcut keys to merge cells in excel are ALT H+M+M
  • We can also merge cells using Merge & Center option under Alignment group.
  • Also, we can organize multiple sections under one heading.
  • It is used most commonly when big title of tabular datasets is to be centered over the top in a particular section of a spreadsheet.
  • The shortcut keys to unmerge cells in Excel is ALT H+M+U.

Top 4 Types Of Merge Cell Options In Excel (With Shortcuts And Examples)

Merge Cells: It is the art of combining multiple cells of rows or columns into a single cell or columns to a single cell.

You can download this Shortcut to Merge Cells Excel Template here – Shortcut to Merge Cells Excel Template

Various types of Merge options with Shortcut keys to merge cells in excel are as follows:

  1. Merge Cells (Excel Shortcut key – ALT H+M+M)
  2. Merge & Center (Excel Shortcut key – ALT H+M+C)
  3. Merge Across (Excel Shortcut key – ALT H+M+A)
  4. Unmerge Cells (Excel Shortcut key – ALT H+M+U)

–>> If you want to learn Excel and VBA professionally, then ​Excel VBA All in One Courses Bundle​ (35+ hours) is the perfect solution. Whether you’re a beginner or an experienced user, this bundle covers it all – from Basic Excel to Advanced Excel, Macros, Power Query, and VBA.

#1 – Merge Cells (Excel Shortcut)

It merges the range into a single cell, but the position of text in cell content is not centered.

Use the excel shortcut – Merge Cells (ALT H+M+M)

Merge cells

For Example

Merge cells 1

#2 – Merge & Center (Excel Shortcut)

It merges the range of cells into one cell, and the position of text in cell content is centered here. i.e., a position of text horizontally centers the content.

  • Note: It will keep only the left column of data and delete the data from other columns.
  • Use the Excel shortcut key – Merge & Center (ALT H+M+C).
Merge & center

For Example

Merge & center eg

#3 – Merge Across (Excel Shortcut)

It will combine each row in the selected range across the columns in the range. However, it will not merge the data into one cell.

  • Note: only the left column of data will be kept, and the data of other columns will be deleted.
  • Use the excel shortcut key – Merge Across (ALT H+M+A)
Merge across

For Example

Merge across example

#4 – Unmerge Cells (Excel Shortcut)

It reverses the merge option where it returns the merged cell to a range of individual cells (unmerged) when you are working on a dataset. If you have mistakenly merged some of the cells, then this option is helpful to unmerge them.

Use the excel shortcut key – Unmerge Cells (ALT H+M+U)

unmerge cells

For Example

unmerge cells example

Important Note:

All the merge options can only merge the cells, but not the text present within these cells.

For Example, In the below-mentioned example, suppose we try to merge the texts of cells A2 and B2; a popup appears asking you, “Merging cells only keeps the upper-left value, and discards other values.” It means it will keep the text from the leftmost cell (A2 in this case) and remove the text from another cell (cell B2).

merge cell popup

If you click “OK,” only the content or text of cell A2 appears in the merged cells. The text of B2 cells disappears (Note: It may warn you before this happens, with a popup window).

Important Things To Note

  • With the merge option, your spreadsheet looks visually presentable and highly organized.
  • There is also an alternative to merging cells in Excel. We can select the data we want to combine, right-click, and choose the “Format” option. The “Format Cells” window appears, and at last select “Center Across Selection” in the “Text alignment” section.
center across selection

Frequently Asked Questions

1. What is merge cells in Excel?

Merge Cells in Excel is the art of combining multiple cells of rows or columns into a single cell.

For example, consider the below table showing temperatures of different countries. We can see data in cell A1 is showing representing column A.

Shortcut to Merge cells FAQ 1

Now, we need to merge cells A1 and B1 to organize the table effectively.

Shortcut to Merge cells FAQ 1 - Output

Simply select A1 and B1 and click on Merge & Center option to merge the cells.

2. What are the shortcuts used to merge cells in Excel?

We can use the shortcut keys, ALT H+M+M to merge cells in Excel.

Also, to merge & center, we can use the shortcut keys, ALT H+M+C to merge and align the data in the center.

3. How to unmerge cells in Excel?

In Excel, unmerging cells is as easy as merging cells. The shortcut keys to unmerge cells in Excel are ALT H+M+U.

This article has guided the Shortcut Key to Merge Cells in Excel. Here, we discuss merging cells in Excel using shortcuts and formulas, practical examples, and a downloadable Excel template. You may learn more about Excel from the following articles: –