Microsoft Office Tutorials and References
In Depth Information
Figure 10–34. The Print Titles button
Print Titles offers one way to resolve another one of those classic spreadsheet issues—
one already discussed in a slightly different context. If you print a long set of records
topped by a header row, that header row will print, naturally, but it’ll only appear on
page 1. And if you need to print a page 2, 3, and so on, these pages won’t display the
header—at least not by default.
But Print Titles offers a kind of a Freeze Panes command for printing see Chapter 9 . Just
as Freeze Panes keeps designated rows or columns on the screen even as you scroll
away from them, Print Titles allows you to print header rows (or columns) on every page
of a multipage printout, reminding you which data is stored under which heading.
To illustrate, printing this worksheet with 800 rows of data will display the header row on
page 1 only, at least at the outset (see Figure 10–35).
Figure 10–35. Pages 1 and 2 of a lengthy printout: The header row appears only on the first page
As a result, you may not be able to easily tell on page 2 which data is associated with
And that’s where Print Titles comes in.