Works 6: Text Is Not Correctly Centered Across a Selected Range of Cells (265893)


The information in this article applies to:

  • Microsoft Works 6
  • 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 "Select horizontal position" 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.
Modification Type:MajorLast Reviewed:10/7/2003
Keywords:kbbug kbgraphic kbpending KB265893
©2003 Microsoft Corporation. All rights reserved.