Click the File tab at the top-left corner of the window. Click Print in the column at the left side of the window. Click the button above the blue Page Setup link, then select the No Scaling option.
If you’re using Excel’s “Scaling” feature to automatically size a spreadsheet to fit the dimensions of a printed page, you may have a problem where the page is printed much too small. Both print preview and the printed speadsheet do not fill the page, but instead appear as a small thumbnail or in miniature size rather than filling up all.
Perhaps a certain section of your spreadsheet never printed or the spreadsheet took too many pages to print. Whatever went wrong, you can avoid many printing problems in Excel by following certain tips, such as tweaking the margins, setting the print area, scaling the sheet to print, and choosing the right sheet options.
How to scale to fit before printing Excel spreadsheets Another way to control the printing on multi-page spreadsheets is by setting a certain width, height, or scale. At the Page Layout Ribbon, click the dropdown box next to Width–from here, you can set a specific number of pages to print across.
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.
You could be wondering “Why is my Excel file size so big?”
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.
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 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.
Why does the print preview or the printed speadsheet not fill the page?
Both print preview and the printed speadsheet do not fill the page, but instead appear as a small thumbnail or in miniature size rather than filling up all of the available space. This can be caused by the “print titles” feature in the page setup window.