How to Use Merge and Center in Excel

Sometimes you may need to add titles, headers, or maybe details to your dataset in Excel. But you will see the texts are displayed inside different cells. Don’t worry Microsoft Excel has a handy feature to merge the entire text in compress the cells into one single cell. This article will show you how to use the Merge & Center command in Excel and also how to unmerge the cells.

Merge & Center Usage Guide

I have a sample dataset of the monthly profit report of a company here. I will merge cells of row 1 and move the word ‘Report’ (situated in cell A1) to the middle of the row.

First, select all the cells you want to merge (cells A1, B1, C1, and D1).

Then click on the Home tab.

After that, select the Merge & Center command from the Alignment group.

Use Merge and Center Command in Excel

Final Result

You will find the text has shifted in the middle of the row.

How to Use Merge and Center in Excel

Other options of Merge & Center

In the Merge & Center drop-down menu, you will find two more options for merging and one option for unmerging.

Other options of Merge & Center in Excel

Try and explore the other two options to find your preferable merging style.

For instance, I will apply the Merge Across command to show you the outcome of this merging style.

The Merge Across command merges all the selected cells in a single row. It doesn’t merge cells from multiple rows.

Now select the targeted cells of Row 1.

Click on the Merge & Center drop-down menu.

Now select the Merge Across command from the list.

Merge Across command of Merge & Center menu in Excel

The cells of Row 1 have been merged and the word ‘Report’ is placed in the cell A1 position.

Unmerge Cells in Excel

You can undo the merging by using the Unmerge Cells command.

To do that,

First, select the already merged cells of Row 1 (cells A1, B1, C1, D1).

Secondly, click on the Home tab.

Then hit the Merge & Center drop-down menu (from the Alignment group).

Finally, select the Unmerge Cells option from the list.

Use Unmerge Cells command in Excel

Final Result

See the cells are unmerged now.

Merge Cells Keyboard Shortcuts in Excel

  • Merge Cells: Select the targeted cells and press ALT+H+M+M.
  • Merge and Center: Select the preferred cells and press ALT+H+M+C.
  • Merge Across: Select the desired cells and press ALT+H+A+M.
  • Unmerge Cells: Select the cells and press ALT+H+M+U. 

🔗 65 Shortcut Keys in Excel

Conclusion

I hope now you have a clear idea of how to use the Merge & Center command and how to Unmerge Cells in Excel. Now you can use these options properly while working with a worksheet. Please visit our Blog page for more helpful articles. Also, tell us in the comment section if you find something confusing.

(Visited 36 times, 1 visits today)

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *