Merging Cells

Merging Cells

Occasionally, you may want to merge two or more cells to create a large cell that spans several columns or rows. Such a cell is useful for adding a title to your worksheet or inserting row labels that apply to several rows in a worksheet. See Figure 5.4.

Figure 5.4. You can merge two or more cells to create a single, larger cell.

To merge cells, follow these steps:

1. Select the cells you want to merge.

2. Open the Format menu and choose Cells . The Format Cells dialog box appears.

3. Click the Alignment tab to bring it to the front, as shown in Figure 5.5.

   Figure 5.5. You can choose to merge the selected cells.

   

4. Click Merge Cells.

5. Click OK . Excel merges the cells and displays a single large cell in place of the smaller cells.

Note

When Excel merges two or more cells, the resulting cell is assigned the address of the cell in the upper-left corner of the range you merged.

To return the cells to their original (premerged state), repeat the steps, removing the check mark from the Merge Cells box.

Tip

To merge cells and center the entry inside the resulting cell, select the cells you want to merge and then click the Merge and Center button. This capability is especially useful for centering a worksheet title at the top of the worksheet.