Text box margins are lost in an Excel workbook when the workbook is saved as "Excel 97-2003 Workbook" and then reopened in Excel 2003

Symptoms

Consider the following scenario:
  • You insert a text box in a workbook in Microsoft Excel 2013, 2010 or 2007.
  • You type text, such as aaa, in the text box.
  • You save the workbook as the Excel 97-2003 Workbook (*.xls) type.
  • You open the workbook in Excel 2003.

In this scenario, the text in the text box is aligned against the left side of the text box, as in the following example:
Text box

Cause

This problem occurs because of a limitation in the Excel 97-2003 Workbook (*.xls) text converter.

Workaround

To work around this problem, reset the margins of the text box in Excel 2003. To do this, follow these steps:
  1. Right-click the text box, and then click Format Text Box.
  2. Click the Margins tab.
  3. Under Internal margin, click to clear the Automatic check box. By default, the internal margins of the text box should match the following specifications:
    • Left: 0.1"
    • Right: 0.1"
    • Top: 0.05"
    • Bottom: 0.05"
  4. Click OK.

The position of the text should now resemble the following:
Fixed Text Box


Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Eigenschaften

Artikelnummer: 983129 – Letzte Überarbeitung: 01.11.2012 – Revision: 1

Feedback