If you need to use one heading for multiple columns or rows, centering the heading text across multiple cells gives a cleaner appearance to an Excel table. You can center text across cells with or without merging the cells in Excel 2007. The method with merging works for a horizontal or vertical range of cells, while the method without merging only works for a horizontal range.
Select the first cell in the range you want to merge and hold down the mouse button. Drag the pointer horizontally or vertically to select all the cells you want to merge.
Click the "Home" tab on the top toolbar, then click "Merge & Center" in the "Alignment" section. If your cell range is horizontal, the cells will merge and any text in them will center. If the cell range is vertical, the cells will merge, but the text will align at the bottom of the merged cell.
Select the merged cell if it is vertical. Right-click and select "Format Cells..." from the drop-down menu. Click the "Alignment" tab in the "Format Cells" dialogue box and choose "Center" from the drop-down menu under "Vertical:" in the "Text alignment" section. Click "OK" at the bottom of the dialogue box.
Click the first cell you want to center across and drag the pointer horizontally to select all the cells you want the text to center across.
Right-click in the selected cells and choose "Format Cells..." from the drop-down menu.
Click the "Alignment" tab at the top of the "Format Cells" dialogue box. Choose "Center Across Selection" from the drop-down menu under "Horizontal:" in the "Text alignment" section. Click the "OK" button at the bottom of the "Format Cells" box.
Tips & Warnings
- Make sure you have text in only one of the cells you want to center the text across. The "Merge & Center" command deletes all text except that in the leftmost or top cell, while the "Center Across Selection" command centers the text from one cell and leaves any other text in its previous format.