'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel Margins Do Not Fit Page Size Error
Question details
The user is experiencing a formatting issue where an Excel document is unexpectedly divided into hundreds of tiny pages with incorrect margin sizes.
- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Opening, viewing, or attempting to print a spreadsheet in Microsoft Excel.
- Observed behavior
- Excel displays extremely small page sizes and inserts hundreds of page breaks because the Windows default printer is set to a label printer.
Before proceeding, ensure that your primary full-size printer is turned on, connected to your computer, and has the latest drivers installed.
Select a Standard Printer or PDF Exporter in Excel
Excel dynamically adjusts its page layout and margins based on the currently selected printer. Switching to a standard document printer or a PDF creator resolves the tiny page formatting issue.
Because Excel relies on your default printer to determine maximum page dimensions, having a label or receipt printer selected will force Excel to shrink the printable area to match the label's dimensions.
Changing the active printer within Excel will instantly recalculate your page breaks.
Click on the 'File' tab in the top left corner of the Excel ribbon, then select 'Print' from the left-hand menu to open the print preview screen.
Locate the 'Printer' dropdown menu. Click on it and select a standard full-size printer (like a laser or inkjet printer) or choose 'Microsoft Print to PDF'.
Click the back arrow to return to your worksheet. The hundreds of page breaks should now be gone, and the margins will reflect a standard letter or A4 page size.
Disable Windows Automatic Default Printer Management
Prevent Windows from automatically switching your default printer to the last used device, which stops the label printer from taking over your Excel layouts in the future.
Easily Manage Page Sizes and Print Layouts with WPS Office
If you frequently struggle with print settings and page breaks, WPS Spreadsheet offers an intuitive Page Layout interface that makes formatting your documents for print completely hassle-free.
- 1. Open your Spreadsheet in WPS Office: Launch WPS Spreadsheet and open your existing Excel workbook.
- 2. Access Page Layout Settings: Navigate to the 'Page Layout' tab on the top ribbon to view standard controls for Margins, Orientation, and Size.
- 3. Adjust Print Area: Highlight the cells you want to print, click 'Print Area', and select 'Set Print Area' to ensure only the necessary data is printed.
- 4. Preview and Print: Click the 'Print Preview' icon to verify your margins fit perfectly before sending the document to your desired printer.
Frequently Asked Questions
Why does my Excel spreadsheet suddenly have hundreds of page breaks?
This usually happens when your computer's default printer is changed to a specialty device with a very small print area, such as a label maker or receipt printer. Excel uses the default printer's paper size to calculate page breaks.
How do I remove manual page breaks in Excel?
To remove all manual page breaks, go to the 'Page Layout' tab on the ribbon, click on 'Breaks' in the Page Setup group, and select 'Reset All Page Breaks'.
Can I set a specific printer just for Excel without changing my Windows default?
Yes. When you are ready to print in Excel, go to File > Print, and select your preferred printer from the dropdown menu. This will only affect the current Excel session and will not change your Windows default printer.
Why is the Print Area option grayed out in Excel?
The Print Area option can be grayed out if you have multiple worksheet tabs grouped together, if you are actively editing a cell (your cursor is blinking inside it), or if you do not have a valid printer driver installed on your computer.
