Error when opening workbook “Margins Do Not Fit Page Size” Print driver is reading the margins incorrectly in Print Preview. This can be the cause even when you have not tried to print but merely tried to open the Workbook. Reboot your computer. If that doesn’t resolve the issue change the Page Layout.
My error “Margins do not fit page size” went away when I: 1. Went to Control Panel -> Devices and printers and set a normal printer that can print A4 as the default printer. Opened Excel and printed A4 and PDF with no problems.
Also, how to set the paper size and margins in Excel?
The Page tab will allow you to set the paper size and select if you want Excel to automatically size the output using “Fit to” or manually size the output “Adjust To” options. You can also manually set the margins using Print Preview and clicking on the margin and dragging it.
Why can’t I print margins on my pages?
Margins do not fit page size. Additionally, many pages that have a scale of 10 percent may be printed. Cause This issue may occur if the printer driver uses the XML Paper Specification (XPS) Page, and scaling feature.
You could be thinking “How do I set the margins?”
Margins are the boundaries on the page that define where text and pictures can be printed on the page. There are four margins: Left, Top, Right, and Bottom. You can set these manually by clicking File > Page Setup > Margins. The error is saying that the current settings are too large for the current paper size.
Why excel size is so large?
Another reason for large file size is having many unused or hidden worksheets in your Workbook. Each Excel Worksheet has it’s own share of metadata, more importantly, however, you may be keeping sheets with similar datasets, copies or unnecessary Pivot Tables that also take up a lot of space.
Some think that Remove Hidden / Unused Worksheets Another reason for large file size is having many unused or hidden worksheets in your Workbook. Each Excel Worksheet has it’s own share of metadata, more importantly, however, you may be keeping sheets with similar datasets, copies or unnecessary Pivot Tables that also take up a lot of space.
Another popular inquiry is “How do I reduce the size of my Excel file?”.
Remove “blank space” in your sheets This is definitely the most common source of large Excel file sizes, and fortunately one of the easiest to fix. Excel has a “used range” for every sheet in your workbook. The larger this is, the bigger the file size becomes.
In effect the XSLX file format will always be larger than the XLSB. To save a file in binary format go to FILEclick on Save Asand select Excel Binary Workbook (*.xlsb) as shown below. Remove Used Cell Range A troublesome thing that can increase your Excel file size is Used Range. Imagine the worksheet below.
Bigger is not always better. This is certainly true for Excel files. Large workbooks take more time to open and calculate, occupy more storage space, consume more real-time resources, and are more prone to crashing and corruption.
How do I use the fit to option in an Excel workbook?
In a Microsoft Office Excel workbook, you select the Fit to option in the Page Setup dialog box. However, when you print this workbook or when you use the print preview feature to view the workbook, you receive the following error message: Margins do not fit page size. Additionally, many pages that have a scale of 10 percent may be printed.