Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

XL: Diagonal Border Disappears with Rotated Text


View products that this article applies to.

Symptoms

In Microsoft Excel, when you use rotated text (any angle between 90 and -90 degrees) and a diagonal border in the same cell, the diagonal border may disappear.

↑ Back to the top


Cause

This behavior can occur because when text is rotated in a cell, the left and right cell borders automatically adjust to the same angle as the rotated text. Therefore, the diagonal border is unnecessary.

↑ Back to the top


Resolution

The following example shows you how to format a cell so that the cell contents are rotated and the cell borders (left and right) are rotated at the same angle as the cell contents.
  1. Create a new workbook and type the following data into Sheet1:
       A1:   B1:
       A2:   B2: sample data
    					
  2. Select cell B2, and then click Cells on the Format menu.
  3. In the Format Cells dialog box, click the Alignment tab, and then under Orientation, set the number of degrees to -45.
  4. Click the Border tab, and then under Presets, click Outline.
  5. Click OK.
The cell text and the left and right cell borders are rotated 45 degrees.

NOTE: In step 4, if you also click either diagonal border style, the diagonal border does not appear in the cell. Any time you use rotated text and apply a border to any one of the cell sides, the diagonal border does not appear.

↑ Back to the top


References

For more information about rotated text, click Microsoft Excel Help on the Help menu, type center, align, indent, or rotate data in a cell in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

For more information about how to troubleshoot rotated text, click Microsoft Excel Help on the Help menu, type troubleshoot formatting cells in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

↑ Back to the top


Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

↑ Back to the top


Article Info
Article ID : 212129
Revision : 2
Created on : 1/1/0001
Published on : 1/1/0001
Exists online : False
Views : 299