Excel 2010 Bible

Chapter 9: Printing Your Work

183

FIGURE 9.5

Use the Sheet tab of the Page Setup dialog box to specify rows or columns that will appear on each printed
page.

Scaling printed output .............................................................................................

In some cases, you may need to force your printed output to fit on a specific number of pages. You

can do so by enlarging or reducing the size. To enter a scaling factor, choose Page Layout ➪ Scale

to Fit ➪ Scale. You can scale the output from 10% up to 400%. To return to normal scaling, enter

100%.

To force Excel to print using a specific number of pages, choose Page Layout ➪ Scale to Fit ➪

Width and Page Layout ➪ Scale to Fit ➪ Height. When you change either one of these settings, the

corresponding scale factor is displayed in the Scale control.

Caution
Excel doesn’t care about legibility, however. It will gladly scale your output to be so small that no one can
read it. n

Printing cell gridlines ..............................................................................................

Typically, cell gridlines aren’t printed. If you want your printout to include the gridlines, choose

Page Layout ➪ Sheet Options ➪ Gridlines ➪ Print.

Alternatively, you can insert borders around some cells to simulate gridlines. See Chapter 6 for

information about borders.