Excel shortcuts

How to Merge Cells in Excel: A Step-By-Step 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 column of data that contains first and last names, and you want to merge those into a single cell so that you can sort the data by last name. Or, you may have a column of data that contains street addresses, and you want to merge those into a single cell so that you can sort the data by zip code. Whatever the reason, Excel makes it easy to merge cells into a single cell.

To merge cells in Excel, follow these steps:

  1. Select the cells that you want to merge. You can select cells in a row, column, or range of cells.
  2. On the Home tab, in the Alignment group, click the Merge & Center button.
  3. The cells will be merged into a single cell.

You can also use the Merge Cells dialog box to specify how you want the cells to be merged. To do this, follow these steps:

  1. Select the cells that you want to merge.
  2. On the Home tab, in the Alignment group, click the small arrow next to the Merge & Center button.
  3. Click Merge Cells.
  4. In the Merge Cells dialog box, under Merge Options, choose the way that you want to merge the cells, and then click OK.

Note that when you merge cells, the data in the cells will be combined into a single cell, and the formatting of the merged cell will be based on the formatting of the first cell in the selection. Also, if the cells that you merge contain formulas, the formulas will be lost when the cells are merged.

If you want to keep the data in the cells, but you don't want to merge the cells, you can use the Concatenate function. The Concatenate function will combine the data in the cells, but the cells will remain separate. To use the Concatenate function, follow these steps:

  1. Select the cell where you want the combined data to appear.
  2. On the Home tab, in the Editing group, click the small arrow next to the AutoSum button, and then click More Functions.
  3. In the Insert Function dialog box, in the Or select a category list, click Text.
  4. In the Select a function list, click CONCATENATE.
  5. Click OK.
  6. In the Function Arguments dialog box, in the Number1 box, type the cell reference for the first cell that you want to concatenate. Repeat this step for each cell that you want to concatenate.
  7. Click OK.

The data in the cells will be combined into a single cell, but the cells will remain separate. You can then format the cell as you would any other cell.

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.