View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Printing Problem

File | Page Setup; open Sheet tab; set what rows are to be printed on each
page.
You cannot do this using the Print Preview route to Page Setup.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Mark" wrote in message
...
I have a document that is 140 rows in length and page breaks at row 50 and
91.

There is some vital information on rows 1, 2 & 3 that I would like at the
top of pages 2 and 3. Is there any way this can be achieved?

Many thanks in advance for you suggestions.

Mark