Microsoft KB Archive/265893

= Works 6: Text Is Not Correctly Centered Across a Selected Range of Cells =

Article ID: 265893

Article Last Modified on 1/27/2007

-

APPLIES TO


 * Microsoft Works 6.0
 * Microsoft Works Suite 2001

-



This article was previously published under Q265893



SYMPTOMS
When you attempt to center text across a selected range of cells in a Microsoft Works Spreadsheet document, the text may be centered across a different range of cells than that which you have selected.

For example, if you type the following text in cell C2

testing centering

and then attempt to center the text across the cell range B2:D2, instead the text is centered across the cell range C2:D2.



CAUSE
This behavior can occur if there are empty cells to the left of the text that you want to center, and the empty cells are included in the range of cells across which you want to center the text.

Works Spreadsheet ignores any empty cells to the left of the text that you want to center.



RESOLUTION
To work around this behavior, follow these steps:
 * 1) Type the text that you want to center in the leftmost cell of the range across which you want to center it.
 * 2) Select the entire range of cells across which you want to center the text.
 * 3) On the Format menu, click Alignment.
 * 4) In the &quot;Select horizontal position&quot; pane, click Center across selection, and then click OK.



MORE INFORMATION
For more information about how to center an entry across columns, click Microsoft Works Help on the Help menu, type center in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Additional query words: works6 w_works

Keywords: kbbug kbgraphic kbpending KB265893

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.