Section 8 - Merge and Center

Excel allows you the option to merge several cells into one large cell and center the contents of the cell. This is commonly used when creating a title for a spreadsheet. To merge and center cells:

• Decide on the range of cells you want your title centered over. click in the left cell of your desired range and type the title. In the example below the title was typed in cell A1.

• Next, click and highlight the range of cells to be merged.

• In Excel XP or MAC Excel 2004, click the Merge and Center button on the Formatting Toolbar.

• In Excel 2007, under the Home tab click on the Merge and Center button in the alignment group.

• The cells will be merged and the contents of the cell will center across the range of cells you selected.