How to Fix Excel for Mac Printing Sheets Too Small or Centered
Question details
The user needs to fix an issue where Excel worksheets are printing out zoomed out and smaller than expected.
- Product
- Microsoft Excel
- Device & OS
- Mac / macOS
- Scenario
- Printing worksheet data to paper.
- Observed behavior
- Worksheets print significantly smaller than intended and centered on the page, even after resetting the printer and Microsoft 365 installation.
Ensure your Mac printer drivers are up to date and rely on the print preview window to verify changes before actually printing to save paper and ink.
Adjust Excel Page Layout and Scaling Options
Modify the scaling settings in Excel to ensure the sheet fits the page properly instead of defaulting to an unintended percentage.
Often, Excel applies a percentage-based scaling rule or incorrectly interprets the print area, causing the data to shrink. Forcing the workbook to fit onto a specified number of pages usually overrides these errors.
Open your workbook in Excel for Mac and navigate to the 'Page Layout' tab on the ribbon.
Locate the 'Scale to Fit' settings. Change the scaling option from a specific percentage to 'Fit Sheet on One Page' or specify 1 page wide by 1 page tall.
Check that your 'Paper Size' matches your physical paper (e.g., A4 or Letter) and set 'Margins' to 'Normal'.
Go to 'File' > 'Print' to open the print dialog. Check the preview pane to ensure the worksheet now fills the page properly before hitting 'Print'.
Test with a New Workbook and Update Software
Determine if the printing issue is specific to the current workbook's formatting or an application-wide bug in Excel or macOS.
Print Spreadsheets Perfectly with WPS Office for Mac
WPS Office for Mac offers a highly compatible and intuitive Spreadsheet tool that makes managing print layouts, margins, and scaling effortless without formatting errors.
- 1. Open your spreadsheet: Launch WPS Office for Mac and open your .xlsx file directly in the WPS Spreadsheet application.
- 2. Access Print Preview: Click 'Menu' and select 'Print Preview' to see exactly how your sheet will look on paper.
- 3. Adjust Page Setup: Use the 'Page Setup' icon on the top toolbar to set scaling to 'Fit to 1 page(s) wide by 1 tall', then click 'Print'.
Frequently Asked Questions
Why is my Excel print preview completely different from the actual printout on my Mac?
This usually occurs due to outdated or incompatible printer drivers bridging Excel and macOS. Try removing the printer from your Mac's 'Printers & Scanners' settings and adding it back, or download the latest driver directly from the printer manufacturer's website.
How do I clear the print area in Excel for Mac?
Navigate to the 'Page Layout' tab, click on 'Print Area', and select 'Clear Print Area'. This removes any hidden or forgotten boundaries that might be forcing your data to print smaller to fit into an unintended restricted zone.
Does checking 'Center on page' affect the size of my printed Excel sheet?
The 'Center on page' (horizontally or vertically) setting itself only changes the position of the data on the paper, not the size. However, if your scaling is accidentally set too low, the data will appear significantly shrunken and clustered in the middle of the page.
