XL98: No "Center Across Columns" Toolbar Button

Last reviewed: February 26, 1998
Article ID: Q181710
The information in this article applies to:
  • Microsoft Excel 98 Macintosh Edition

SYMPTOMS

In Microsoft Excel 98 Macintosh Edition, no Center Across Columns button appears on the Formatting toolbar. Instead, a Merge And Center toolbar button appears.

WORKAROUND

Although the Center Across Columns toolbar button is no longer available, you can 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. Click the Alignment tab.

  3. In the Horizontal list box, select Center Across Selection.

  4. Click OK.

STATUS

This behavior is by design of Microsoft Excel 98 Macintosh Edition.

MORE INFORMATION

The Merge And Center toolbar button in Microsoft Excel 98 Macintosh Edition provides a level of functionality that is very similar to the functionality that is provided by the Center Across Columns toolbar button in earlier versions of Microsoft Excel. Basically, the button allows you to center information in a single cell across a range of cells.

Note that there are some minor differences in behavior between the two buttons. The following examples illustrate these differences.

Examples

Assume that you have created a new worksheet in Microsoft Excel that contains the following information:

   A1: test
   A2: hello

In Microsoft Excel 5.0, if you select the range A1:E1 and click the Center Across Columns toolbar button, the word "test" appears centered across the range A1:E1, and the gridlines between the cells disappear. However, the range consists of five individual cells.

In Microsoft Excel 98 Macintosh Edition, if you select the range A1:E1 and click the Merge And Center toolbar button, the range A1:E1 is merged into a single cell. The word "test" appears centered within this cell.

In Microsoft Excel 5.0, if you select the range A1:E2 and click the Center Across Columns toolbar button, the word "test" appears centered across the range A1:E1, and the word "hello" appears centered across the range A2:E2. The gridlines between cells in these two smaller ranges disappears. The range consists of ten individual cells.

In Microsoft Excel 98 Macintosh Edition, if you select the range A1:E2 and click the Merge And Center toolbar button, the entire range A1:E2 is merged into a single cell. The word "test" appears centered within this cell. In addition, because merging cells removes the contents of all cells within the range except for the upper leftmost cell, you receive the following message:

   The selection contains multiple data values. Merging into one cell
   will keep the upper-left most data only.

If you click OK, the word "hello" is deleted and the cells are merged. If you click Cancel, the merge and center process is cancelled.

If the other cells in the range must retain their contents, or if you want to center multiple rows of information, use the workaround in this article to format the cells with the Center Across Selection alignment.

REFERENCES

For more information about merging cells, click the Index button in Microsoft Excel Help, type the following text

   merging cells

click Show Topics, and then double-click the displayed Help topic.


Additional query words: XL98
Keywords : xlui kbui kbdta kbfaq
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbprb


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 26, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.