Sometimes mergining multiple cells into one is necessary (especially for titles and labels) in worksheets. Merging multiple cells is not that difficult and there are two ways that this can be accomplished.

To merge cells using the format toolbar, follow the given steps:

• Select the cells to be merged by clicking on the first cell and dragging the mouse across to the other cells.
• After letting the mouse button loose, go to the format toolbar and click on the Merge and Center button.

• Once this button is clicked, the multiple cells that were selected turns into one elongated cell with center alignment. You are now ready to type in the data.

 

 To merge cells using the toolbar option, follow the given steps: 

• Select the cells to be merged by clicking on the first cell and dragging the mouse across to the other cells.
• After letting the mouse button loose, go to Format on the toolbar. Click on the Cells option.

• A Format Cells window will appear with several tabs. Choose the Alignment tab by clicking on it and click on the square near the Merge Cells options toward the bottom. In the Horizontal alignment section, select the format you want (e.g., Left, Right, Center, Fill, Center Across Selection).

• After making the selection, click the OK button and type your data into the new cell.