Here's our Microsoft Office Tip for.. December 4, 2000
Click Here to see a complete list of all of our previously released Tips!
Repeating Headings in Larger Spreadsheets
As your worksheet grows, so does your printout. If your data requires more than one page, you'll probably want to include certain data--column headings for example--on each page. However, in your worksheet, these headings appear only once, at the top of your worksheet. Fortunately, there's an easy way to display a row or column of data on each page. Technically, these repeated ranges are called titles.
To arrange repetitive data for each page in your printout, first choose Page Setup from the File menu. Then, click the Sheet tab. In the Print Titles section, indicate the row and/or column that you want repeated on each page. Click OK to return to your worksheet. At this point, you can click Print to print the worksheet or try Print Preview to see how the new titles will look.