Part I: Getting Started with Excel
182
To insert a vertical page-break line, move the cell pointer to the cell that will begin the new page.
In this case, though, make sure to place the pointer in row 1. Choose Page Layout ➪ Page
Setup ➪ Breaks ➪ Insert Page Break to create the page break.Removing manual page breaks ......................................................................
To remove a page break you’ve added, move the cell pointer to the first row beneath (or the first
column to the right) of the manual page break and then choose Page Layout ➪ Page Setup ➪
Breaks ➪ Remove Page Break.To remove all manual page breaks in the worksheet, choose Page Layout ➪ Page Setup ➪
Breaks ➪ Reset All Page Breaks.Printing row and column titles ................................................................................
If your worksheet is set up with titles in the first row and descriptive names in the first column, it
can be difficult to identify data that appears on printed pages where those titles do not appear. To
resolve this problem, you can choose to print selected rows or columns as titles on each page of the
printout.Cross-Reference
Row and column titles serve pretty much the same purpose on a printout as frozen panes do in navigating
within a worksheet. See Chapter 3 for more information on freezing panes. Keep in mind, however, that these
features are independent of each other. In other words, freezing panes does not affect the printed output. n
Caution
Don’t confuse print titles with headers; these are two different concepts. Headers appear at the top of each
page and contain information, such as the worksheet name, date, or page number. Row and column titles
describe the data being printed, such as field names in a database table or list. n
You can specify particular rows to repeat at the top of every printed page or particular columns to
repeat at the left of every printed page. To do so, choose Page Layout ➪ Page Setup ➪ Print Titles.
Excel displays the Sheet tab of the Page Setup dialog box, shown in Figure 9.5.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.Note
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. n