XL97: Text Is Cut Off When Printing or Viewing a Worksheet (173156)
The information in this article applies to:
- Microsoft Excel 97 for Windows
This article was previously published under Q173156 SYMPTOMS
When you print a worksheet or view a worksheet in print preview or page
break preview, the text and borders of cells at the edge of the page may
be truncated or may be printed on another page.
CAUSE
This problem may occur when you apply a combination of rotated text,
borders, and the Shrink To Fit formats to a cell.
NOTE: The "More Information" section in this article contains an example
that demonstrates this problem.
WORKAROUND
To work around this problem or lessen the severity of this problem, use
any of the following methods.
Method 1
In the worksheet, select the range of cells that you want to print,
including cells that surround the cells that contain rotated text. Then,
point to Print Area on the File menu and click Set Print Area.
Method 2
Clear the Shrink To Fit check box for the cells that contain rotated text.
To do this, follow these steps:
- Select the cells with rotated text.
- On the Format menu, click Cells. Then, click the Alignment tab.
- Click to clear the Shrink To Fit check box. Then, click OK.
Method 3
Remove the border from the cells that contain rotated text. To do this,
follow these steps:
- Select the cells with rotated text.
- On the Format menu, click Cells. Then, click the Border tab.
- Click None and click OK.
When you print the worksheet or view it in print preview or page break
preview, the cells with rotated text appear correctly. Note that it may be
necessary to use two or more of these methods to correct the problem.
If the rotated text still does not appear correctly, try deleting page
breaks, inserting or removing columns, or manually adjusting the widths of
columns in the worksheet.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article.
Modification Type: | Major | Last Reviewed: | 9/7/2001 |
---|
Keywords: | kbprint KB173156 |
---|
|