Page 302 - Excel 2013 All-in-One For Dummies

284 Working with the Page Setup Options
Figure 5-9:
Page 2 of
a sample report
in Print Preview with defined print titles.
Using the buttons in the Scale to Fit group
If your printer supports scaling options, you’re in luck. You can always get a worksheet to fit on a single page simply by selecting the 1 Page option on the Width and Height drop-down menus attached to their command buttons in the Scale to Fit group on the Layout Page tab of the Ribbon. When you select these options, Excel figures out how much to reduce the size of the informa- tion you’re printing to fit it all on one page.
If you preview this one page in the Print screen of the Backstage view (Ctrl+P) and find that the printing is just too small to read comfortably, return to the worksheet view. Then, reopen the Page tab of the Page Setup dialog box and try changing the number of pages in the Page(s) Wide and Tall text boxes (to the immediate right of the Fit To option button).
Instead of trying to stuff everything on one page, check out how your work- sheet looks if you fit it on two pages across. Try this: Select 2 Pages from the Width button’s drop-down list on the Page Layout tab and leave 1 Page selected in the Height drop-down list. Alternatively, see how the worksheet looks on two pages down: Select 1 Page from the Width button’s drop-down list and 2 Pages from the Height button’s drop-down list.