Fix Excel Printing Wrong Custom Margins on One Computer
Question details
The user needs an Excel workbook to print with its saved 1 cm custom margins instead of the default 1.91 cm margins on one computer.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The same workbook prints correctly for other users, but one computer ignores the workbook's custom margin setting.
- Observed behavior
- Excel uses default margins on the affected computer even though the workbook specifies custom 1 cm margins.
Open the same workbook on the computer that prints correctly and note its selected printer, paper size, orientation, and scaling settings. Keep the affected workbook open so you can compare the settings in Print Preview.
Select the workbook's Custom Margins setting in Excel
Use this first when Excel may be applying a built-in margin preset instead of the custom margins saved for the worksheet.
In Excel, select File > Print and review the settings panel below the printer selection.
Under Margins, select Custom Margins rather than Normal, Wide, or Narrow Margins.
In the Page Setup dialog, open the Margins tab and set Top, Bottom, Left, and Right margins to 1 cm as required.
Check the preview in File > Print, then print a test page to confirm the worksheet uses the selected custom margins.
Match paper, scaling, orientation, and printer settings
Use this when the workbook prints correctly on another computer but has a different layout or margins on the affected computer.
Update, reinstall, or recreate the affected printer
Use this when custom margins are correct in Print Preview or PDF output but are changed when sent to one physical printer.
Set and Preview Custom Print Margins in WPS Spreadsheets
WPS Spreadsheets lets you set custom worksheet margins, verify the page layout in Print Preview, and print or export the workbook while preserving the intended layout.
- 1. Open the workbook in WPS Spreadsheets: Launch WPS Office, select Spreadsheets, and open the affected .xlsx or .xls workbook.
- 2. Open Page Setup: Select Page Layout > Margins > Custom Margins to open the page margin settings.
- 3. Enter the required margins: Set the Top, Bottom, Left, and Right values to 1 cm, then confirm the paper size and orientation in Page Layout.
- 4. Check Print Preview: Select Menu > Print > Print Preview and verify that the worksheet content fits within the custom margins.
- 5. Print or export to PDF: Choose Menu > Print to select a printer, or use Menu > Export to PDF to create a layout-preserving PDF file.
Frequently Asked Questions
Why does Excel use default margins even though my workbook has custom margins?
Excel may have a built-in margin preset selected under File > Print > Margins, or the selected printer driver may be overriding the printable area. Choose Custom Margins and verify the values in Page Setup > Margins.
Can a printer driver change Excel margin output?
Yes. Printer drivers can enforce printable-area limitations, paper-size settings, scaling, or borderless-print options. Compare Printer Properties and test the same workbook with Microsoft Print to PDF.
How can I tell whether Excel or the printer is causing the margin problem?
Select Microsoft Print to PDF in File > Print. If the resulting PDF has the correct 1 cm margins but the physical print does not, the printer configuration or driver is the likely cause.
Which Excel settings should match on both computers?
Compare the active printer in File > Print, Page Layout > Size, Orientation, Scale to Fit settings, Custom Margins values, and options shown in Printer Properties.
Will reinstalling a printer help with incorrect print margins?
It can help when the current driver is corrupted or has incompatible settings. Remove the printer from Windows Settings > Bluetooth & devices > Printers & scanners, add it again, and install the latest manufacturer driver.
