XL2000: No "Center Across Columns" Toolbar Button

• Microsoft Excel 2000

SYMPTOMS

In Microsoft Excel 2000, 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 2000 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.

Additional query words: XL2000 merge center cells columns

Keywords : kbualink97 xlui
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb