How to apply headings to all worksheets
 

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

How to apply headings to all worksheets
 

contor+tab of the worksheets . all worksheets will be selected
now you type in sheet 1 whatever header you want. it will be repeated in all
the sheets
remember to select any one of the sheets so that selection of all sheets is
deselected


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

How to apply headings to all worksheets
 

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.


--
cycling-rod
------------------------------------------------------------------------
cycling-rod's Profile: http://www.excelforum.com/member.php...o&userid=13520
View this thread: http://www.excelforum.com/showthread...hreadid=495884

How to apply headings to all worksheets
 

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.


--
cycling-rod
------------------------------------------------------------------------
cycling-rod's Profile: http://www.excelforum.com/member.php...o&userid=13520
View this thread: http://www.excelforum.com/showthread...hreadid=495884