The Merge & Center button acts as a toggle. Go to the Home tab ➪ Alignment section ➪ Click on the ‘ Merge & Centre‘ control button which will merge the cells, and the content in the upper-left cells will be centered horizontally.
#Merging cells in excel 2011 how to#
■ METHOD 2: HOW TO MERGE CELLS IN EXCEL ➢ USING THE ‘MERGE & CENTER' CONTROL BUTTON
![merging cells in excel 2011 merging cells in excel 2011](https://support.content.office.net/en-us/media/7433f239-37b7-4f6d-93d0-5f7d9ca0949c.png)
To apply the Merge Cells (usually used Merge and Center option), use the Excel shortcut Alt+H+M+C (sequentially press Alt, H, M, C).
![merging cells in excel 2011 merging cells in excel 2011](https://support.content.office.net/en-us/media/0fa97ae4-5dcf-4632-863c-c579a80e0b67.png)
![merging cells in excel 2011 merging cells in excel 2011](https://i.stack.imgur.com/zyQgz.png)
■ METHOD 1: HOW TO MERGE CELLS IN EXCEL SHORTCUT.Similarly, in the case of unmerging cells, select the merged cells, and click the Merge & Center button again. The cells will be merged, and the content in the upper-left cells will be centered horizontally. To merge cells, select the cells that we want to merge and then click the Merge & Center” button. To avoid deleting data, click Cancel in response to the warning. If we continue, all the data (except in the upper-left cell) will be deleted. If any of the other cells that intend to merge are not empty, Excel displays a warning.
![merging cells in excel 2011 merging cells in excel 2011](https://assolve.com/wp-content/uploads/2020/11/5-1024x576.png)
The range that intends to merge should be empty, except for the upper-left cell. It is typically used for row and column headings in tables of data, where we would like one title to apply to many cells. Similarly, in the same way, we can unmerge them also. We can merge any number of cells occupying any number of rows and columns. Rather, it combines a group of cells into a single cell that occupies the same space. Merge cells never combine the contents of cells. As a result, merge the values of two or more columns (or multiple rows) into a single column (or single row). The Merge & Center in Excel is a useful feature that combines (or merges) the selected cells row-wise or column-wise and merges them into a single cell. In this tutorial, we explain 03 different methods to apply Merge Cells and Unmerge Cells in Excel as well. What is Merge Cells in Excel? How to Merge Cells in Excel? – Both questions are valid in every Excel users' mind.