- 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.
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.
Method 1: Use the same dpi setting for the vertical and horizontal dimensions
- On the File tab, click Print.
- Click Page Setup.
- In the Page Setup dialog box, click the Page tab.
- Select a print quality that has same value for the vertical and horizontal dimensions, and then click OK.
Method 2: Paste as a picture
- Select the text box that has the alignment problem, and then click Copy.
- On the Home tab, click Paste Special in the Paste list.
- In the Paste Special dialog box, click Picture, and then click OK.
Method 3: Substitute an ActiveX control for the text box
- On the Developer tab, click Insert, and then click Text Box (Active X Control).
- Drag an arbitrary rectangle to create the text box.
- Right-click the text box, click TextBox Object, and then click Edit.
Microsoft is researching this problem and will post more information in this article as it becomes available.