Article ID: 288858 - View products that this article applies to.
This article was previously published under Q288858
When you print a Microsoft Excel worksheet, the printed text may appear to be a slightly different size than expected. The number of rows printed per page may not be the same as expected, or the margins may not appear to be the same width that you set.
This behavior can occur because Excel automatically detects the size of the paper that is in the printer, by reading the paper size selection in the printer driver.
Excel can detect whether the printer contains A4-sized paper or letter-sized paper by reading the settings from the printer driver. When you print a worksheet, if the paper size stated by the printer driver does not match the paper size that is actually in the printer, Excel adjusts the printer output to match the reported paper size. The printed worksheet appears differently than in Print Preview.
To resolve this behavior, check the paper size in the printer properties, and then ensure that the printer actually contains paper of that size. Because Excel determines the paper size in the printer by reading the settings in the printer driver, it is very important that the paper size settings in the printer driver match the actual size of the paper that the printer is using.
To view the selected paper size in the printer properties, follow these steps:
Microsoft Excel 2002 or Microsoft Office Excel 2003
Microsoft Office Excel 2007
Article ID: 288858 - Last Review: January 30, 2007 - Revision: 3.2