Microsoft Office Tutorials and References
In Depth Information
Center Text Across Multiple Columns
Formatting Excel Ranges
Excel opens the Format Cells
dialog box with the Alignment
4 Click the Horizontal and then
click Center Across Selection .
5 Click OK.
A Excel centers the text across the
Is there an easier way to center text across multiple columns?
Yes, although this technique also merges the selected cells into a
single cell. (See Chapter 3 to learn more about merging cells.)
Follow these steps:
1 Repeat Steps and .
2 In the Alignment group, click the Merge & Center button (
Excel merges the selected cells into a single cell and centers
the text within that cell.