Thread: Printing Frozen Cells Automatically on every page
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Printing Frozen Cells Automatically on every page
File|Page setup|Sheet tab
Rows to repeat at top: 1:1


gin2000 wrote:

Hi,

I have put headings on the first row (and frozen that row). Underneath
the headings, are numbers which go on for many rows (about 3 pages).
How do I print so that I can get the headings on every page?

Thx much!

--
gin2000
------------------------------------------------------------------------
gin2000's Profile: http://www.excelforum.com/member.php...o&userid=34606
View this thread: http://www.excelforum.com/showthread...hreadid=562117

--

Dave Peterson
Reply With QuoteReply With Quote