View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
trip_to_tokyo[_2_] trip_to_tokyo[_2_] is offline
external usenet poster
 
Posts: 70
Default same heading on each page while printing

Page Layout / click on the arrow in the lower right hand corner of the Page
Setup list of options / Page Setup window will launch / Sheet tab / single
left hand click in the Rows to repeat at top: box / then click in the rows
that you wish to repeat at the top (for example rows 1 and 2) / this will put
$1:$2 in the Rows ro repeat at top: box / single left hand click on OK.

This should give you what you want. Steve.



"mariekek5" wrote:

When I have a large document in Excel which I want to print....I only get the
heading on the first page... However, I would like the heading to show up on
each page...is that possible?

So it concerns the first row...

Thansk in advance