Excel shortcuts

How to Merge Cells in Excel: The Ultimate Guide

If you work with data in Microsoft Excel, you may find yourself in a situation where you need to merge two or more cells into a single cell. For example, you may have a list of employees and their contact information, and you want to merge the cells that contain the employees' first and last names into a single cell. Or, you may have a list of products and you want to merge the cells that contain the product names and descriptions into a single cell. Whatever the reason, Excel makes it easy to merge cells into a single cell.

In this article, we'll show you how to merge cells in Excel so that you can combine data into a single cell. We'll also show you how to unmerge cells in Excel if you need to split a merged cell back into its original, separate cells.

How to Merge Cells in Excel

To merge cells in Excel, follow these steps:

  1. Select the cells that you want to merge. You can select multiple cells by holding down the Ctrl key while you click on the cells.
  2. Click the Home tab on the Ribbon.
  3. Click the Merge & Center button in the Alignment group.

Excel will merge the selected cells into a single cell. If the selected cells contain data, the data will be combined into a single cell, with each piece of data separated by a space. If the selected cells are blank, the merged cell will be blank.

How to Unmerge Cells in Excel

To unmerge cells in Excel, follow these steps:

  1. Select the merged cell that you want to unmerge.
  2. Click the Home tab on the Ribbon.
  3. Click the Merge & Center button in the Alignment group.

Excel will unmerge the selected cell, and the data that was in the merged cell will be split into the individual cells that were merged.

How to Merge Cells in Excel and Keep the Data

If you try to merge cells that contain data, you'll notice that the data is combined into a single cell, with each piece of data separated by a space. If you want to merge cells and keep the data in separate cells, you can use the Concatenate function.

To use the Concatenate function, follow these steps:

  1. Select the cell where you want the merged data to appear.
  2. Click the Formulas tab on the Ribbon.
  3. Click the Text button in the Function Library group.
  4. Click the Concatenate function.
  5. Click the Cell button in the Reference group.
  6. Click the first cell that you want to merge.
  7. Click the Add button.
  8. Click the second cell that you want to merge.
  9. Click the OK button.
  10. Click the OK button.

The Concatenate function will merge the data from the selected cells into the cell where you entered the function. The data will be combined into a single cell, with each piece of data separated by a space.

How to Merge Cells in Excel and Keep the Data in Separate Cells

If you want to merge cells and keep the data in separate cells, you can use the Concatenate function, as we described above. Alternatively, you can use the Text to Columns feature.

To use the Text to Columns feature, follow these steps:

  1. Select the cells that you want to merge.
  2. Click the Data tab on the Ribbon.
  3. Click the Text to Columns button in the Data Tools group.
  4. Click the Delimited option.
  5. Click the Next button.
  6. Clear the Tab checkbox and the Semicolon checkbox.
  7. Click the Space checkbox.
  8. Click the Finish button.

The Text to Columns feature will split the data in the selected cells into multiple columns, with each column containing one piece of data. The data will be split at the spaces, so if you have data that contains spaces, you may want to use the Concatenate function instead.

How to Merge Cells in Excel and Center the Data

If you want to merge cells and center the data, you can use the Merge & Center button, as we described above. Alternatively, you can use the Center button in the Alignment group.

To use the Center button, follow these steps:

  1. Select the cells that you want to merge.
  2. Click the Home tab on the Ribbon.
  3. Click the Center button in the Alignment group.

The Center button will center the data in the selected cells. If the selected cells contain multiple pieces of data, the data will be centered in each cell.

How to Merge Cells in Excel and Keep the Data Left-Aligned

If you want to merge cells and keep the data left-aligned, you can use the Merge & Center button, as we described above. Alternatively, you can use the Align Left button in the Alignment group.

To use the Align Left button, follow these steps:

  1. Select the cells that you want to merge.
  2. Click the Home tab on the Ribbon.
  3. Click the Align Left button in the Alignment group.

The Align Left button will left-align the data in the selected cells. If the selected cells contain multiple pieces of data, the data will be left-aligned in each cell.

How to Merge Cells in Excel and Keep the Data Right-Aligned

If you want to merge cells and keep the data right-aligned, you can use the Merge & Center button, as we described above. Alternatively, you can use the Align Right button in the Alignment group.

To use the Align Right button, follow these steps:

  1. Select the cells that you want to merge.
  2. Click the Home tab on the Ribbon.
  3. Click the Align Right button in the Alignment group.

The Align Right button will right-align the data in the selected cells. If the selected cells contain multiple pieces of data, the data will be right-aligned in each cell.

How to Merge Cells in Excel and Keep the Data Top-Aligned

If you want to merge cells and keep the data top-aligned, you can use the Merge & Center button, as we described above. Alternatively, you can use the Align Top button in the Alignment group.

To use the Align Top button, follow these steps:

  1. Select the cells that you want to merge.
  2. Click the Home tab on the Ribbon.
  3. Click the Align Top button in the Alignment group.

The Align Top button will top-align the data in

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.