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.
- Click Start, point to Settings, and then click Printers.
Note On a computer that is running Windows Vista, click Start, click Control Panel, and then click Printers.
- In the Printers dialog box, right-click the printer that you want.
- On the shortcut menu, click Printing Preferences.
- On the Paper/Quality tab, click Advanced, and then note the paper size that is selected.
Microsoft Excel 2002 or Microsoft Office Excel 2003
- On the Tools menu, click Options.
- In the Options dialog box, click the International tab.
- Under Printing, click to select or to clear the Allow A4/Letter paper resizing check box, and then click OK.
Microsoft Office Excel 2007
- Click the Microsoft Office Button, and then click Excel Options.
- Click the the Advanced tab.
- Under the General section, click to select or to clear the Scale content to A4 or 8.5x11" paper sizes check box, and then click OK.
Article ID: 288858 - Last Review: Apr 29, 2008 - Revision: 1