Excel 2019 Bible

(singke) #1

Chapter 7: Printing Your Work


7


Activate the appropriate box (either Rows to Repeat at Top or Columns to Repeat at Left)
and then select the rows or columns in the worksheet. Or you can enter these references
manually. For example, to specify rows 1 and 2 as repeating rows, enter 1:2.

When you specify row and column titles and use Page Layout view, these titles will repeat on every page (just as
when the document is printed). However, the cells used in the title can be selected only on the page in which they
first appear.


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.

Excel doesn’t ensure legibility. It will gladly scale your output to be so small that no one can read it.


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. Change the
border color to White Background 1, 25% Darker to get a pretty good simulation of a grid-
line. To change the color, choose Home ➪ Font ➪ Borders ➪ More Borders. Make sure you
change the color before you apply the border.

See Chapter 5, “Formatting Worksheets,” for information about borders.

Printing row and column headers
By default, row and column headers for a worksheet are not printed. If you want your print-
out to include these items, choose Page Layout ➪ Sheet Options ➪ Headings ➪ Print.

Using a background image
Would you like to have a background image on your printouts? Unfortunately, you can’t.
You may have noticed the Page Layout ➪ Page Setup ➪ Background command. This button
Free download pdf