In Excel 2007, click the Page Layout tab.
Last updated on
Oct 4, 2022
Issue
When you create a document with Microsoft Excel 2007, and then convert the document to PDF, the text in the cells is truncated. The layout of the document might also differ from the layout of the file as you originally created it in Excel. Also, page breaks might be in the wrong places.
Reason
A bug in Microsoft Excel prevents text in Excel spreadsheets to be printed with acceptable quality if print parameters aren't within Excel.
Solution
Solution: Configure the DPI settings in Excel to match the DPI settings of the PDF file.
-
-
In the Page Setup group, click the Page Setup dialog box launcher.
-
In the Print quality list, click 600 dpi for standard output. Or, click 300 dpi for minimum output.
Note: The dpi settings that are available depend on the functionality of the printer that you are using. -
Save an Excel 2007 workbook as a PDF file. Select PDF in the Save As dialog box.
Note: The following two options for output are displayed:- Standard (publishing online and printing): uses 600 dpi for output.
- Minimum size (publishing online): uses 300 dpi for output.
-
Do one of the following:
- If you clicked 600 dpi in step 3, then click Standard (publishing online and printing).
- If you clicked 300 dpi in step 3, then click Minimum size (publishing online).
