XL: No "Center Across Columns" Toolbar Button (212022)


The information in this article applies to:

  • Microsoft Excel 2000
  • Microsoft Excel 2002
This article was previously published under Q212022
For a Microsoft Excel 97 version of this article, see 156442.

SYMPTOMS

In Microsoft Excel, no Center Across Columns button appears on the Formatting toolbar.

WORKAROUND

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. On the Format menu, click Cells.
  3. Click the Alignment tab.
  4. In the Horizontal list, click Center Across Selection.
  5. Click OK.

MORE INFORMATION

The Merge and Center toolbar button in Excel provides a level of functionality that is very similar to the functionality provided by the "Center Across Columns" toolbar button in versions of Microsoft Excel earlier than Excel 97. The button allows you to center information contained in a single cell across a range of cells.

REFERENCES

For more information about merging cells, click Microsoft Excel Help on the Help menu, type merging cells in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.
Modification Type:MajorLast Reviewed:10/7/2003
Keywords:kbprb kbualink97 KB212022
©2003 Microsoft Corporation. All rights reserved.