Number 233 - September 2002

EXCEL Make Excel Worksheets Fit Your Paper
Office Tips edited by John Heenan, NOCCC - July 08, 2002
Large worksheets in Excel can make for cumbersome printouts, with rows spreading across several sheets and pages breaking in the wrong places. To get the hard copies you want, select File | Page Setup.     In the Page Setup dialog box, select the orientation for the worksheet Landscape orientation is better when the number of columns exceeds 20.     In the Scaling section of the dialog box, click "Fit to," and then use the arrows to indicate the number of pages wide and number of pages tall the worksheet should be. At this point, click the Print Preview button to check the results.	Click the Zoom button in the Print Preview window. If you can't read the worksheet on screen, you probably won't be able to read it on paper. You've squeezed your worksheet into too few pages. To change the number of pages, click Page Setup button. If the worksheet does not fit properly, go back to the worksheet and adjust column sizes.     To check the position of page breaks, click Page Break Preview while in the Print Preview window. Scroll down until you see a blue line indicating a page break. If it's not where you want it, click and drag it up. (You can't drag it down.) Click File | Print Preview to return to the Preview window.     When you're satisfied, click Print in the Preview window or the Page Setup dialog box to put your worksheet on paper.
Number 233 - September 2002