Excel file printing forcing margins

There are a number of things at play.

• Layout margins vs. print marginsThere are physical limits to the area a printer can actually print on. When you set layout margins, that is for appearance, but the margins must be at least what is required to keep the output within the physical print area of the printer.

• Different print margins for different printersEach printer can have different print margins. Outputting to PDF or printing to a PDF virtual printer doesn't impose a print margin because it is not a physical device. It is up to you to ensure that the layout margins are adequate for the printers that will eventually be used with the PDF.

• Landscape vs. portrait - printerMost printers do their actual printing in portrait (wide format printers allow you to actually feed the paper in landscape). On a regular printer, a landscape page is just mapped sideways onto a portrait page for printing purposes. The printer margins apply to the paper, not the document, so when you print a landscape page, the top and bottom non-print areas on the printed page are really the left and right non-print areas of the printer.

• Landscape vs portrait - ExcelIn Excel, the margin settings are not linked to the orientation setting (at least in the 2007 version; can't vouch for later versions). If you set the margins (or use default margins) for a portrait layout and then select landscape, the margins don't automatically reverse orientation. You must verify that the margins are appropriate for the orientation.

• Printer non-printing areaThe printer margin reflects the physical configuration of the printer. Most printers will map the print output to the paper and anything in the non-printing area will just be cut off. Some printers don't do a good job of that and the output will be offset on the page.

• Shrink to fitSome printer drivers provide a shrink to fit option, which reduces the output to fit within the print margins. Excel has a similar feature built into its layout functions. If you go into the page break view, it will show you where the page breaks will be based on current settings. You can manually move those margins to force more content on the page. Excel will shrink the content as necessary to fit.

To diagnose what's going on in your case, review all of those factors and settings. If you still can't determine what's causing the problem, edit your question to include what all of those settings are, and describe what happens to the output when you change specific settings.