672
Chapter 24 Excel Essentials
Using Repeating Titles for Multiple Page Printouts
For worksheets that span multiple pages, you can repeat one or more rows or columns (or
both) as titles for the data on each new page. On a typical budget worksheet, for example,
the first column might contain income and expense categories, with columns for each
month’s data extending to the right across several pages. In this case, follow these steps to
repeat the entries in a particular column or row as titles at the left of each page:
1. Choose File, Page Setup, and click the Sheet tab.
2. To specify a column for titles, click in the Columns to Repeat at Left box. T ...