Article ID: 265893 - Last Review: January 27, 2007 - Revision: 2.1

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

This article was previously published under Q265893
Expand all | Collapse all

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.

APPLIES TO
  • Microsoft Works 6.0
  • Microsoft Works Suite 2001
Keywords: 
kbbug kbgraphic kbpending KB265893
Retired KB ArticleRetired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
 

Article Translations

 

Related Support Centers