Excel 2000

Another Alignment Option: Merge and Center

In Excel, you have another alignment option available to you: merge and center.

When you merge a cell, you are selecting more than one cell and creating one large cell. You can center the contents of a cell across the new merged cell.

Merge and center is helpful when creating worksheet titles.

To Create a Title using Merge and Center:

• Enter the title of the worksheet in the top left cell.
• Select the first row of the worksheet (including the top left cell containing the title of the worksheet). How many cells you select depends on how wide your label is.
• Click the Merge and Center button.

Excel only centers the text in the top left cell of the selection, so if the title is in more than one row, merge and center each title row separately.