Excel Optimize

Problem: The report shown in Fig. 30 has 90 rows of data. You want tohave the title rows print at the top of each printed page.

Strategy: Printing options are controlled on the fourth tab of the Page Setup dialog box. In this case, you want rows 1 through 5 to print at the top of each page.

1. Select Page Setup from the File menu. The dialog box offers four tabs. Select the fourth tab, called Sheet. See Fig. 31.
2. Enter 1:5 in the box called Rows to Repeat at Top, as shown in Fig. 31, in order to have rows 1 through 5 repeated at the top of each printed page. Select Print Preview to ensure that the results are what you desire.

Alternate Solution: Rather than typing 1:5 in the text box, you could click the reference icon on the right side of the box, as shown in Fig. 32
This will shrink the Page Setup dialog box to just the Rows to Repeat at Top dialog. You can now use the mouse to select rows 1 through 5. Choose the icon at the right side of the text box to return to the Page Setup dialog box, as shown in Fig. 33.

Alternate Solution: If the rows you desire to repeat at the top are visible behind the dialog box, as shown in Fig. 34, use the mouse to highlight them while the cursor is in the Rows to repeat at top textbox.

Summary: Use the Page Setup command on the File menu to have titles and headings appear at the top of every page.

Cross Reference: Another way to have text appear at the top or bottom of every page is to use the Header/Footer command on the Page Setup dialog.