Text is printed above a shape's boundary in Excel 2013

Symptoms

Consider the following scenario:
  • You use Microsoft Excel 2013.
  • You have a printer that lets you set different printing resolutions by adjusting the horizontal and vertical dots per inch (dpi) values. For example, you have an Epson LQ-630 ESC/P 2.
  • You configure the Page Setup options to use horizontal and vertical dpi settings that differ. For example, you set a resolution of 360x180.
  • You create a spreadsheet that contains a shape, such as a text box, AutoShape, WordArt, or Math Object.
In this scenario, when you print the spreadsheet or view the spreadsheet in Print Preview mode, the text is vertically misaligned and is displayed outside the shape's boundaries.

Note This issue is not specific to the example printer. This issue can affect any printer on which you set different vertical and horizontal dpi values.

Resolution

Method 1: Use the same dpi setting for the vertical and horizontal dimensions

  1. On the File tab, click Print.
  2. Click Page Setup.
  3. In the Page Setup dialog box, click the Page tab.
  4. Select a print quality that has same value for the vertical and horizontal dimensions, and then click OK.

Method 2: Paste as a picture

  1. Select the text box that has the alignment problem, and then click Copy.
  2. On the Home tab, click Paste Special in the Paste list.
  3. In the Paste Special dialog box, click Picture, and then click OK.

Method 3: Substitute an ActiveX control for the text box

  1. On the Developer tab, click Insert, and then click Text Box (Active X Control).
  2. Drag an arbitrary rectangle to create the text box.
  3. Right-click the text box, click TextBox Object, and then click Edit.

Status

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

Microsoft is researching this problem and will post more information in this article as it becomes available.

More Information

This issue does not occur in Excel 2010.



Third-party information disclaimer

Properties

Article ID: 2930123 - Last Review: 5 Feb 2014 - Revision: 1

Feedback