Print different titles for each excel page in the same worksheet
Sal at work asked me how to print different titles for each page. headings didn't work b/c they repeated on every page.
Print titles:
If your printout contains multiple pages, you might want a title heading or column headings on top of each page, or row heading in the first column of each page.
Position the worksheet so that the rows or columns that contain the title(s) are displayed. Choose File, Page Setup, and select the Sheet tab. In the Print Titles box, enter the rows or columns that you want printed as titles. Click OK.
http://www.somerset.kctcs.edu/titleiii/Excel%20Tips.htm
i used google and searched under "title excel sheet", but came up withbad results. the best results surprisingly came from "title excel sheet each page different". usually longer search phrases is bad, but i guess it worked out in this case. i have yet to try this technique.

0 Comments:
Post a Comment
<< Home