In the Margins tab, under the Center on page section, check the Horizontally checkbox.Ħ.Go to the Page Layout tab on the ribbon, click on the Margins dropdown, and select Custom Margins.The first thing to do is to center your data on the page. Since Excel, by default, doesn’t give you clearly defined pages, it may be difficult to know where one page ends, and the next one begins. And sometimes, errors in printing may be caused by scaling issues. Scaling is best used when you want to make an Excel spreadsheet fit on your screen, but it can be used for other things too. You’ll have to go through each page in the print preview to make sure no blank ones appear. You can also apply this fix if blank pages appear in the middle of your Excel printout and all your data is printed. All you have to do is check the number of pages before printing and leave out the ones that are blank. It can be annoying if many blank pages are printed at the tail end of your Excel document, but this can be dealt with easily. We have an informative article on how to set an area to print in Excel, as well as how to expand and clear the print area. Go to View > Page Break Preview to see how pages are set to be printed.
0 Comments
Leave a Reply. |