The "Center Across Columns" button does not appear on the toolbar or on the Ribbon in Excel

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

This article was previously published under Q212022
For a Microsoft Excel 97 version of this article, see 156442.
In Microsoft Excel 2000, in Microsoft Excel 2002, and in Microsoft Office Excel 2003, the Center Across Columns button does not appear on the Formatting toolbar. In Microsoft Office Excel 2007, a Center Across Columns button does not appear on the Home tab.
Although the Center Across Columns toolbar button is no longer available, you can still center text across columns without merging cells. To do this, follow these steps:
  1. Select the range of cells over which you want to center text.
  2. Right-click the selected cells, and then click Format Cells.
  3. Click the Alignment tab.
  4. In the Horizontal list, click Center Across Selection.
  5. Click OK.
The Merge and Center toolbar button in Excel provides alevel of functionality that is very similar to the functionality providedby the "Center Across Columns" toolbar button in versions ofMicrosoft Excel earlier than Excel 97. The button allows you to center information contained in a single cell across a range of cells.
XL2000 merge center cells columns xl2002 xl2003 xl2007

Article ID: 212022 - Last Review: 01/05/2007 21:49:53 - Revision: 4.0

Microsoft Office Excel 2007, Microsoft Office Excel 2003, Microsoft Excel 2002 Standard Edition, Microsoft Excel 2000 Standard Edition

  • kbprb kbualink97 KB212022