Trending September 2023 # How To Use Merge And Center In Excel? # Suggested October 2023 # Top 18 Popular

You are reading the article How To Use Merge And Center In Excel? updated in September 2023 on the website Chivangcangda.com. We hope that the information we have shared is helpful to you. If you find the content interesting and meaningful, please share it with your friends and continue to follow and support us for the latest updates. Suggested October 2023 How To Use Merge And Center In Excel?

Merge and Center in Excel How to use Merge and Center in Excel?

We use Merge and Center in Excel to merge a group of cells or to center the headings or text. Merge and Center are located in the Home menu tab under the Alignment section. Using Merge and Center in Excel is very easy and convenient.

You can download this Merge and Center Excel Template here – Merge and Center Excel Template

Let’s understand how to Merge and Center in Excel with some examples.

Merge and Center in Excel – Example #1

We have sales data for products of a month below. And we have named this table Sales and Order, which is on the top row in font size 20, to have pure clarity and visibility of the performed function.

To merge the table name Sales and Order in one cell to become the table’s heading, select the cells you want to merge with Sales and Order text, as shown below.

Merge and Center in Excel – Example #2

We will see another function of Merge and Center in Excel: Merge Across. Unlike Merge and Center in Excel, Merge Across is used to merge multiple rows or line items. In Merge and Center, we could only merge one cell with multiple cells.

In Merge Across, a text comes to one side of the selected cells or row.

Below, we have some numbers in different rows. Here, we will merge them into one row.

If we need to unmerge the merged cells, select the Unmerge Cells options from the drop-down, as shown below.

Merge and Center in Excel – Example #3

We can directly merge any cell content with multiple cells. This is an easy and quick process to perform. For that, we have sample data below.

The above screenshot shows some numbers from 1 to 5 in sequence. Now Let’s try to merge any of the numbers with one or more than one cell. First, select the range of those cells that we need to merge, as shown below.

Above, we have selected the cell from B2 to D2 in a range. Now select Merge Cells from the drop-down list of Merge & Center, as shown in the below screenshot.

Let’s see what happens when we merge the cell number B5 and B6, as selected in the below screenshot.

Once we do that, the selected cells will merge with only one value: the first or upper value from the range, as shown below.

If I want to see the value in the previous format, then unmerge the cells by selecting Unmerge Cells option from a drop-down list of Merge & Center, as shown below.

After that, all the merged cells will get separated, and only the upper or first value will be retained further, as shown below, losing the rest of the value.

Pros

It manages data to look good by having a single value for multiple headers.

By changing the position of merged cells, we can adjust the data and its visibility as per requirement.

Merge & Center can be used for both rows and columns.

Cons

Things to Remember

Always change the alignment of the merged cell to help adjust and look for correct attributes.

Use Wrap Text, which is located above Merge & Center, so that if a cell has lengthy text, then by wrapping, it will be visible in the same cell and will be on its border.

If all selected cells contain data, it merges and carries only the first or upper cell value.