Excel Optimize

Problem: As shown in Fig. 35, you are sending out a worksheet that contains instructions, followed by a lengthy report. You would like the headings to appear at the top of each page after the first page. You don’t want the headings to appear at the top of the letter on page one.

Strategy: Printing options are controlled on the fourth tab of the Page Setup dialog box. If you specify that a row in the middle of the print range should be repeated at the top of the pages, it will not begin repeating until the next page.

1. Select Page Setup from the File menu. The dialog box offers four tabs. Select the fourth tab, called Sheet. See Fig. 36.
2. Enter 19:19 in the box called Rows to Repeat at Top, as shown in Fig. 36, to have row 19 print at the top of each page after page 1.

Result: The headings do not print at the top of page 1, but at the top of pages 2 and beyond. Fig. 37 shows the first page in Print Preview mode.

Fig. 38 shows the second page in Print Preview mode:

Summary: The Rows to Repeat at Top figure does not have to be at the top of the print range. If your selection is in the middle of the print range, the headings will only print on subsequent pages.