Article ID: 211674 - View products that this article applies to.
This article was previously published under Q211674
This article has been archived. It is offered "as is" and will no longer be updated.
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.
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.
To work around this behavior or lessen the severity of this behavior, use any of the following methods.
Method 1In the worksheet, select the range of cells that you want to print, including cells that surround the cells that contain rotated text. Point to Print Area on the File menu and click Set Print Area.
Method 2Clear the Shrink to fit check box for the cells that contain rotated text. To do this, follow these steps:
Method 3Remove the border from the cells that contain rotated text. To do this, follow these steps:
NOTE: 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.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
This problem occurs because of the way Microsoft Excel calculates the position of page breaks when a column contains cells with rotated text and borders. Normally, when you rotate text in a cell in Microsoft Excel, the cell remains rectangular in shape. However, if you apply a border to the cell, the cell becomes a parallelogram. If the parallelogram crosses a page break, Microsoft Excel may truncate some parts of the cell or may display the parts on another page.
ExampleTo see an example of the problem, follow these steps: