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. 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. Click Ctrl + P and choose Print Selection in the drop-down list right under Settings.To select adjacent sheets, click the first sheet tab, hold the Shift key and click the last sheet tab.
0 Comments
Leave a Reply. |