View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
cycling-rod
 
Posts: n/a
Default 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