Centering a Heading

In Excel, you can use another type of alignment command called Merge and Center. The Merge and Center button (its icon has a page with the letter a and two arrows) on the Formatting toolbar lets you quickly center text in the left-most cell across the entire range of cells you select. This feature is good for centering a title and subtitle at the top of a worksheet. Figure 46.9 shows a title centered across the table in cell F1.

Figure 46.9. A title centered across a table with the Merge and Center button.