How to apply headings to all worksheets

B

bill

I have a customized heading and footnote which I want to use for all
worksheets in one file. Can someone tell me how please?
 
C

cycling-rod

If the cells of a spreadsheet with data in them cover one or several
pages, then any header and footer will automatically be printed on one
or several pages too.
 
C

cycling-rod

One way would be to copy and paste the heading from your spreadsheet
into a Header, and the footnotes into a footer. They will them be
automatically printed on each page.
Also, it is possible to repeat the printing of titles on every page:
Quote from excel help file:
If you have column or row labels on a worksheet, they can appear on
every page of the printed worksheet. To set these print titles, click
Page Setup on the File menu, and then click the Sheet tab.
 
Top