

Print to file – save the output for later use
#Excel 2013 print preview shows extra line manual
Please note that using this option will ignore any manual page breaks. To print an Excel spreadsheet on a predefined number of pages, on the Page tab of the Page Setup dialog, under Scaling, enter the number of pages in both Fit to boxes (wide and tall). The smaller the margins, the more room there will be for your data. If your sheet has more columns than rows, change the page orientation to Landscape. The default Portrait orientation works well for worksheets that have more rows than columns. In this case, the following adjustments might be useful: If the Adjust To number is low, a printed copy will be difficult to read. This will open the Page Setup dialog box, where you look at the number in the Adjust to box: To check how much scaling will actually be used, click Custom Scaling Options…. Please be very careful when printing on one page – in a huge sheet, your printout may become unreadable. To remove scaling, choose No Scaling in the list of options. Fit All Rows on One Page – this will print all the rows on one page, but the columns may extend to multiple pages.Fit All Columns on One Page – this will print all the columns on one page while the rows may be split across several pages.Fit Sheet on One Page – this will shrink the sheet so that it fits on one page.To print an Excel sheet on one page, choose one of the following Scaling options that reside at the end of the Settings section in the Print Preview window: So, the bigger your worksheet, the more pages it will take.
#Excel 2013 print preview shows extra line how to
How to print Excel spreadsheet on one pageīy default, Excel prints sheets at their actual size. To set the print area in multiple sheets, you can use these Print Area macros.

This tutorial aims to help you get perfect hard copies of your Excel documents. This is because Excel worksheets are designed for comfortable viewing and editing on screen, not to fit on a sheet of paper. Just click the Print button, right? In reality, a well-organized and beautifully formatted sheet that looks great on a monitor is often a mess on a printed page. At first sight, printing Excel spreadsheets is super easy. Living in a digital world, we still need a printed copy every now and then. Learn how to print Excel spreadsheets exactly the way you want - print selection, sheet or entire workbook, on one page or multiple pages, with proper page breaks, gridlines, titles, and a lot more.
